Schema

1version: 2
2
3# Tests + docs for marts. Every mart ships with tests: they are dbt's equivalent
4# of the aliasing/validation the PostHog view path enforces automatically.
5models:
6    - name: fct_daily_active_users
7      description: One row per day with the count of distinct active persons.
8      columns:
9          - name: day
10            description: Calendar day (UTC).
11            data_tests:
12                - unique
13                - not_null
14          - name: active_users
15            description: Distinct persons with at least one event that day.
16            data_tests:
17                - not_null
18
19# Dimension example — assert one row per entity and referential integrity from facts:
20#  - name: dim_customer
21#    columns:
22#      - name: customer_id
23#        data_tests: [unique, not_null]
24#  - name: fct_mrr
25#    columns:
26#      - name: customer_id
27#        data_tests:
28#          - relationships:
29#              to: ref('dim_customer')
30#              field: customer_id