Release Notes

June 2025

Effective June 23, 2025 we use a new June 2025 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

4 total changes • 0 possible breaking changes

Table/column	Change type	New name
`HOSTED_PAGE`
table	New Table	`HOSTED_PAGE`
`HOSTED_PAGE_TRANSACTION`
table	New Table	`HOSTED_PAGE_TRANSACTION`
`SUBSCRIPTION_RENEWAL_ESTIMATE`
table	New Table	`SUBSCRIPTION_RENEWAL_ESTIMATE`
`SUBSCRIPTION_RENEWAL_ESTIMATE_INVOICE_LINE_ITEM`
table	New Table	`SUBSCRIPTION_RENEWAL_ESTIMATE_INVOICE_LINE_ITEM`

May 2025

Effective May 2, 2025 we use a new May 2025 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

15 total changes • 14 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`CONTRACT_TERM`
table	New Table		`CONTRACT_TERM`
`INVOICE_LINE_ITEM`
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
`SUBSCRIPTION`
column	Discontinued Column	`contract_term_action_at_term_end`
column	Discontinued Column	`contract_term_billing_cycle`
column	Discontinued Column	`contract_term_cancellation_cutoff_period`
column	Discontinued Column	`contract_term_contract_end`
column	Discontinued Column	`contract_term_contract_start`
column	Discontinued Column	`contract_term_created_at`
column	Discontinued Column	`contract_term_id`
column	Discontinued Column	`contract_term_object`
column	Discontinued Column	`contract_term_remaining_billing_cycles`
column	Discontinued Column	`contract_term_status`
column	Discontinued Column	`contract_term_total_contract_value`
column	Discontinued Column	`contract_term_total_contract_value_before_tax`
column	Rename Column	`monthly_reccuring_revenue`	`monthly_recurring_revenue`

April 2025

We have changed the sync strategy for the TRANSACTION table. We now re-import this table once a day to capture updates and deletes.

March 2025

Effective March 12, 2025 we use a new March 2025 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`EVENT`
column	New Column			`origin_user`

December 2024

The Chargebee Product Catalog 2.0 connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. For the Chargebee Product Catalog 2.0 connector, priority-first syncs fetch the past 30 days' worth of data from the QUOTE and QUOTE_SUBSCRIPTION tables.

To learn more, see our priority-first sync documentation.

Effective December 5, 2024 we use a new December 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

33 total changes • 0 possible breaking changes

Table/column	Change type	New name
`CREDIT_NOTE_LINE_ITEM`
column	New Column	`reference_line_item_id`
`INVOICE_DUNNING_ATTEMPT`
column	New Column	`transaction_amount`
column	New Column	`transaction_status`
`INVOICE_LINKED_PAYMENT`
column	New Column	`transaction_amount`
column	New Column	`transaction_date`
column	New Column	`transaction_status`
`QUOTE`
table	New Table	`QUOTE`
`QUOTE_DISCOUNT`
table	New Table	`QUOTE_DISCOUNT`
`QUOTE_LINE_ITEM`
table	New Table	`QUOTE_LINE_ITEM`
`QUOTE_LINE_ITEM_DISCOUNT`
table	New Table	`QUOTE_LINE_ITEM_DISCOUNT`
`QUOTE_LINE_ITEM_ITER`
table	New Table	`QUOTE_LINE_ITEM_ITER`
`QUOTE_LINE_ITEM_TAX`
table	New Table	`QUOTE_LINE_ITEM_TAX`
`QUOTE_NOTE`
table	New Table	`QUOTE_NOTE`
`QUOTE_SUBSCRIPTION`
table	New Table	`QUOTE_SUBSCRIPTION`
`QUOTE_SUBSCRIPTION_ADDON`
table	New Table	`QUOTE_SUBSCRIPTION_ADDON`
`QUOTE_SUBSCRIPTION_COUPON`
table	New Table	`QUOTE_SUBSCRIPTION_COUPON`
`QUOTE_SUBSCRIPTION_DISCOUNT`
table	New Table	`QUOTE_SUBSCRIPTION_DISCOUNT`
`QUOTE_SUBSCRIPTION_EVENT_BASED_ADDON`
table	New Table	`QUOTE_SUBSCRIPTION_EVENT_BASED_ADDON`
`QUOTE_SUBSCRIPTION_ITEM`
table	New Table	`QUOTE_SUBSCRIPTION_ITEM`
`QUOTE_SUBSCRIPTION_ITEM_ITER`
table	New Table	`QUOTE_SUBSCRIPTION_ITEM_ITER`
`QUOTE_TAX`
table	New Table	`QUOTE_TAX`
`SUBSCRIPTION`
column	New Column	`active_id`
column	New Column	`changes_scheduled_at`
column	New Column	`contract_term_total_contract_value_before_tax`
column	New Column	`shipping_address_index`
`SUBSCRIPTION_DISCOUNT`
table	New Table	`SUBSCRIPTION_DISCOUNT`
`SUBSCRIPTION_ITEM_PRICE`
column	New Column	`billing_period`
column	New Column	`billing_period_unit`
column	New Column	`charge_once`
column	New Column	`free_quantity_in_decimal`
column	New Column	`proration_type`
column	New Column	`trial_end`
column	New Column	`usage_accumulation_reset_frequency`

October 2024

Effective October 14, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to prevent or resolve data integrity issues.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`INVOICE_LINE_ITEM`
column	Primary Key Change		`invoice_id`	`invoice_id` 🔑	Added to primary key.

June 2024

Effective June 28, 2024 we use a new June 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to align with source changes.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

3 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name
`DIFFERENTIAL_PRICE_TIER`
table	New Table		`DIFFERENTIAL_PRICE_TIER`
`ITEM_PRICE_TIER`
table	New Table		`ITEM_PRICE_TIER`
`PRICE_TIER`
table	Discontinued Table	`PRICE_TIER`

January 2024

We have added a new column, free_quantity, to the SUBSCRIPTION_ITEM_PRICE table.

September 2023

We no longer capture deletes for the INVOICE and SUBSCRIPTION tables. We no longer update the _fivetran_deleted column in these tables.

August 2023

You can now configure your Chargebee Product Catalog 2.0 connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.

We have added the following new tables:

COUPON_METADATA
EVENT_METADATA
ITEM_METADATA
ITEM_PRICE_METADATA
PAYMENT_SOURCE_MANDATE
PRICE_TIER
SUBSCRIPTION_METADATA

We have combined the DIFFERENTIAL_PRICE_TIER and ITEM_PRICE_TIER tier tables into a new table, PRICE_TIER.

We have renamed the ORDER table to ORDERS.

We have made the following changes to the COUPON_ITEM_CONSTRAINT table:

Renamed the constraint column to constraints
Added the item_type column to the set of composite primary keys

We have made the following changes to the CREDIT_NOTE_LINKED_REFUND and INVOICE_LINKED_PAYMENT tables:

Renamed the txn_id column to transaction_id
Removed the txn_amount, txn_date, and txn_status columns

We have made the following changes to the EVENT table:

Renamed the user column to users
Removed the metadata_* column

We have made the following changes to the INVOICE_ADJUSTMENT_CREDIT_NOTE and INVOICE_ISSUED_CREDIT_NOTE tables:

Renamed the cn_id column to credit_note_id
Removed the cn_create_reason_code, cn_date, cn_reason_code, cn_status, and cn_total columns

We have made the following changes to the INVOICE_APPLIED_CREDIT table:

Renamed the cn_id column to credit_note_id
Removed the cn_create_reason_code, cn_date, cn_reason_code, and cn_status columns

We have made the following changes to the INVOICE_LINKED_ORDER table:

Renamed the id column to order_id
Removed the batch_id, created_at, document_number, fulfilment_status, order_type, reference_id, and status columns

We have made the following changes to the ITEM_PRICE table:

Added a new column, accounting_detail_sku
Removed the metadata_* column

We have made the following changes to the SUBSCRIPTION_ITEM_TIER_PRICE table:

Added a new column, index
Removed the price and price_in_decimal columns

We have made the following changes to the TRANSACTION_LINKED_CREDIT_NOTE table:

Renamed the cn_id column to credit_note_id
Removed the cn_create_reason_code, cn_date, and cn_reference_invoice_id columns

We have made the following changes to the TRANSACTION_LINKED_PAYMENT table:

Renamed the transaction_txn_id column to transaction_id
Removed the amount, date, and status columns

We have renamed the following columns in the COUPON_APPLICABLE_ITEM_PRICE table:

coupon_item_constraint_constraint to coupon_item_constraints
coupon_item_constraint_item_type to coupon_item_constraint_type

We have renamed the gift_receiver_customer_id column to gift_receiver in the GIFT table.

We have renamed the following columns in the SUBSCRIPTION table:

auto_close_invoices to auto_close_invoice
mrr to monthly_reccuring_revenue

We have renamed the following columns in the TRANSACTION table:

iin to issuer_identification_number
last4 to last_4
txn_id to refunded_transaction_id

We have renamed the following columns in the TRANSACTION_REFUND table:

refunded_txn_id to refunded_transaction_id
txn_amount to transaction_amount
txn_date to transaction_date
txn_status to transaction_status

We have added a new column, recurring, to the INVOICE table.

We have removed the metadata_* column from the COUPON and ITEM tables.

We have removed the following columns from the CREDIT_NOTE_INVOICE_ALLOCATION table:

allocated_at
invoice_date
invoice_status

We have removed the txn_amount and txn_status columns from the INVOICE_DUNNING_ATTEMPT table.

We have removed the following columns from the ORDER_LINKED_CREDIT_NOTE table:

amount
amount_adjusted
amount_refunded
status
type

We have removed the following columns from the SUBSCRIPTION_ITEM_PRICE table:

current_term_end
free_quantity
free_quantity_in_decimal
next_billing_at
trial_end

We have removed the following columns from the TRANSACTION_INVOICE table:

invoice_date
invoice_total
invoice_status

July 2023

We have changed the sync strategy of our Chargebee Product Catalog 2.0 connector. We now incrementally sync the following tables and their child tables:

COMMENT
COUPON
CREDIT_NOTE
CUSTOMER
DIFFERENTIAL_PRICE
EVENT
GIFT
INVOICE
ITEM
ITEM_FAMILY
ITEM_PRICE
PAYMENT_SOURCE
ORDER
SUBSCRIPTION
TRANSACTION

October 2022

Lite connectors are now available for the following sources: