Stores daily aggregated usage for a subscription and metered feature. Each row is one subscription, one metered feature, one day, and one group-by combination. Join subscription_id to the subscriptions table, and join feature_id to groupby_mapping to interpret groupby_1 through groupby_5. The same usage at other grains is in meter_usage_hourly and meter_usage_monthly. This table contains rows only when the site records usage for metered features.

Columns

No match found

subscription_id string, not null
Foreign Key subscriptions.id
Unique identifier of the subscription this usage belongs to. Maximum length is 50 characters. Join with the subscriptions table to retrieve subscription details.

aggregated_usage decimal, null
Usage quantity aggregated for this subscription, metered feature, period, and group-by combination. Stored as a decimal with precision (38, 9). The total follows the aggregation in the metered feature's query.

aggregation_day timestamp, not null
Timestamp that identifies the day this usage is aggregated for. Interpreted in the time zone given by time_zone.

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 this usage belongs to. Maximum length is 50 characters. Join with groupby_mapping on this value to resolve groupby_1 through groupby_5.

groupby_1 string, null
Value of the first group-by attribute for this usage group. Null when the metered feature has no group-by attribute in position 1. Resolve the attribute name from groupby_mapping where feature_id matches and groupby_position is 1.

groupby_2 string, null
Value of the second group-by attribute for this usage group. Null when the metered feature has no group-by attribute in position 2. Resolve the attribute name from groupby_mapping where feature_id matches and groupby_position is 2.

groupby_3 string, null
Value of the third group-by attribute for this usage group. Null when the metered feature has no group-by attribute in position 3. Resolve the attribute name from groupby_mapping where feature_id matches and groupby_position is 3.

groupby_4 string, null
Value of the fourth group-by attribute for this usage group. Null when the metered feature has no group-by attribute in position 4. Resolve the attribute name from groupby_mapping where feature_id matches and groupby_position is 4.

groupby_5 string, null
Value of the fifth group-by attribute for this usage group. Null when the metered feature has no group-by attribute in position 5. Resolve the attribute name from groupby_mapping where feature_id matches and groupby_position is 5.

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.

time_zone string, not null
Time zone used to place this usage into its aggregation period.

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