Changelog

19th Aug 2025 Release

Three new metadata columns are now available across all tables, enabling better tracking of data flow.

  • record_extracted_at: The column represents the timestamp when the updated data became available in Chargebee’s data lakehouse.
  • record_exported_at: The column represents the timestamp when the data was exported to the configured destination.
  • change_type: The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly

24th June 2025 Release

item_entitlements table has been removed from Automatic Exports until further notice.

14th May 2025 Release

Fourteen new tables have been added:

  • business_entity_transfers: business_entity_transfer encapsulates the details of the movement of a resource (such as customer and subscription) from one business_entity to another.
  • contract_terms: Subscriptions can run indefinitely, or they may run for a fixed number of billing cycles. Subscription can have 'contract terms', which define a lock-in period on the subscription for a certain number of billing cycles. This prevents the subscription from being canceled by the customer when it is within the contract term.
  • orders: Orders are automatically generated for an invoice when it gets paid, based on the shipping preference chosen for the invoice's product and the shipping date configuration.
  • order_line_item_discounts: The list of discounts applied for the order.
  • order_line_item_taxes: The list of taxes applied on the order line items.
  • order_line_items: The list of line items for this order.
  • order_linked_credit_notes: The credit notes linked to the order.
  • resent_orders: The list of resent orders applied on the order.
  • ramps: The ramp resource or a subscription ramp represents a planned change to a subscription set to occur at a future date. By using this resource, you can define and schedule modifications to a subscription, such as updating pricing, altering the quantity, or transitioning to a different plan, without immediately applying them.
  • ramp_coupons_to_add: Details about the coupons added to the subscription through this ramp.
  • ramp_discounts_to_add: Details about the discounts added to the subscription through this ramp.
  • ramp_item_tiers: Overrides the item_tiers for specific item_prices of the subscription.
  • ramp_items_to_add: Details about the item prices added to the subscription through this ramp.
  • ramp_items_to_update: Details about the item prices updated in the subscription through this ramp.

10th Apr 2025 Release

Two new tables have been added:

24th Jan 2025 Release

Three new tables have been added to enhance subscription and MRR analysis:

Table Name Table Description
subscription_mrr_changes This table captures the historical changes in subscription status and Monthly Recurring Revenue (MRR) for each subscription. Each row represents a distinct change event, allowing for a comprehensive view of a subscription's lifecycle. The table is designed to facilitate root cause analysis of subscription upgrades, downgrades, and cancellations when joined with internal product analytics datasets.
subscription_mrr_daily_summary The subscription_mrr_daily table offers a comprehensive daily view of Monthly Recurring Revenue (MRR) for each subscription in both the billing currency and the site’s reporting currency.
subscription_mrr_monthly_summary The subscription_mrr_monthly table offers a comprehensive monthly view of Monthly Recurring Revenue (MRR) for each subscription in both the billing currency and the site’s reporting currency.

Note: All tables automatically recalculate when reporting timezone or currency settings change.

7th Jan 2025 Release

New field available: dunning_status is added to the invoices table.

3rd Dec 2024 Release

New table available: invoice_dunning_attempts