_date
, _month
, _year
depending on the level of granularity.
created_date
updated_month
_at
.
created_at
updated_at
created_at
refers to the time in UTC.created_at_eu_fr
refers to the time in Europe/Paris timezone._id
.
user_id
product_id
order_user_id
order_product_id
_id
and prefixed with the relationship name.
manager_id
parent_id
quantity
price
length_cm
weight_kg
__dbt_inserted_at
aggregation
_object
_context
_units
Aggregation:
Should be:
count
when measuring the quantity of discrete objects e.g. conversationssum
when measuring the quantity of continuous quantities e.g. ARRcount_support_tickets_inbound
count_support_tickets_inbound_from_email
count_support_tickets_resolved_by_teammate
sum_teammate_time_active_in_hours
median_arr_per_app
avg_cost_per_request_in_usd