Semantics

name: orders                      # unique across the whole project
connection: warehouse_pg          # which connection this comes from
table: analytics.fct_orders       # physical relation
grain: [order_id]                 # row uniqueness: drives fanout safety
description: "One row per order."

columns:
  - { name: order_id,    type: string,  nullable: false }
  - { name: customer_id, type: string,  nullable: false }
  - { name: status,      type: string,  nullable: false }
  - { name: amount,      type: decimal, nullable: false }
  - { name: created_at,  type: timestamp, nullable: false }

measures:
  - name: total_revenue
    expr: "sum(amount)"
    additivity: additive           # additive | semi_additive | non_additive
  - name: order_count
    expr: "count(distinct order_id)"
    additivity: non_additive

dimensions:
  - { name: status,     column: status }
  - { name: order_date, column: created_at, granularity: day }

joins:
  - to: customers                  # another semantic source's `name`
    on: "orders.customer_id = customers.customer_id"
    relationship: many_to_one      # one_to_one | many_to_one | one_to_many | many_to_many

filters:
  - { name: completed, expr: "status = 'completed'" }

meta:                              # system-managed, not hand-edited
  provenance: inferred             # board_approved | human_curated | inferred
  source_fingerprint: "sha256:…"
  last_validated_at: "2026-06-13T00:00:00Z"