Business entity transfers - Chargebee Data Catalog

business_entity_transfer encapsulates the details of the movement of a resource (such as customer and subscription) from one business entity to another.

UPSERT KEY

Each row is uniquely identified by this column. Use it as the upsert key when applying incremental datasets to your warehouse.

Columns

id string, not null

Primary Key

Unique identifier of the business_entity_transfer record.

active_resource_id string, not null

Unique identifier of the active version of the table linked to the destination business entity.

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.

created_at timestamp, not null

The date and time when this business entity transfer record was created.

destination_business_entity_id string, not null

Unique identifier of the destination business entity to which the table data was transferred.

reason_code string, not null

The reason for transferring table data to another business entity. Possible values are:

correction: Correction of a wrongly assigned business entity.

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.

resource_id string, not null

Unique identifier of the deprecated version of the table linked to the source business entity.

resource_type string, not null

Type of the table that was transferred. Possible values are:

customer: Refers to a customer table.
subscription: Refers to a subscription table linked to a customer.

source_business_entity_id string, not null