Omnichannel subscription transactions - Chargebee Data Catalog

Maps the relationship between omnichannel transactions and omnichannel subscriptions. Use this table to associate multiple transactions (such as initial purchases, renewals, and upgrades) with a single omnichannel subscription across app store sources such as the Apple App Store and Google Play Store.

UPSERT KEY

omnichannel_transaction_id + record_id

Each row is uniquely identified by this combination. Use these columns together as the upsert key when applying incremental datasets to your warehouse.

Columns

omnichannel_transaction_id string, not null

Foreign Key omnichannel_transactions.id

The unique identifier of the related omnichannel transaction.

omnichannel_subscription_id string, null

Foreign Key omnichannel_subscriptions.id

The unique identifier of the related omnichannel subscription. This represents the subscription that the transaction is associated with.

change_type string

The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly.

record_exported_at timestamp

The column represents the timestamp when the data was exported to the configured destination.

record_extracted_at timestamp

The column represents the timestamp when the updated data became available in Chargebee's data lakehouse.

record_id integer

The column represents the unique integer identifier for each child record within a parent subset.