subscription_id string, not null
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_month timestamp, not null
Timestamp that identifies the month 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.
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.