dbt Project

1# Minimal dbt project skeleton for modeling PostHog + business data.
2# Copy into a new dbt project and adjust `profile` to match your ~/.dbt/profiles.yml
3# (the profile is where warehouse credentials live — Snowflake/BigQuery/Postgres/DuckDB).
4name: posthog_models
5version: '1.0.0'
6config-version: 2
7
8profile: posthog_models
9
10model-paths: ['models']
11seed-paths: ['seeds'] # put static lookups here, e.g. currency rates: seeds/currency_rates.csv
12
13models:
14    posthog_models:
15        staging:
16            +materialized: view # staging stays cheap and always-fresh
17            +schema: staging
18        marts:
19            +materialized: table # marts are computed once per run; switch to incremental for large facts
20            +schema: marts