Maps each group-by attribute of a metered feature to the column that stores its values on the meter usage tables. Each row is one group-by attribute for one feature. A metered feature can define up to five group-by attributes, stored in groupby_1 through groupby_5. Join feature_id to meter_usage_hourly, meter_usage_daily, and meter_usage_monthly.

Columns

No match found

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.

feature_id string, not null
Unique identifier of the metered feature these group-by attributes belong to. Maximum length is 50 characters. See metered features.

groupby_attribute string, not null
Name of the group-by attribute on the metered feature. Names are case-sensitive and match the attribute in the feature query's GROUP BY clause.

groupby_position bigint, not null
Position of this attribute in the metered feature's group-by list. Position 1 is stored in groupby_1 on the meter usage tables, through position 5 in groupby_5.

physical_column_name string, not null
Name of the column on the meter usage tables that stores this attribute's values, such as groupby_1.

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.

updated_at timestamp, null
Timestamp indicating when this record was last updated.