Schema

1version: 2
2
3# Dimensions must have a unique, non-null key — otherwise they fan out every fact they join.
4models:
5    - name: dim_date
6      description: Calendar dimension, one row per day.
7      columns:
8          - name: date
9            data_tests: [unique, not_null]
10    - name: dim_country
11      description: Country dimension with region/continent, one row per ISO-2 code.
12      columns:
13          - name: country_code
14            data_tests: [unique, not_null]
15          - name: region
16
17seeds:
18    - name: country_region
19      description: Static country_code -> region/continent lookup.
20      columns:
21          - name: country_code
22            data_tests: [unique, not_null]