ecomm-analysis/dbt_project.yml at main · rohithay/ecomm-analysis · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
name: "ecomm_analysis"
version: "1.0.0"
config-version: 2

profile: ecomm_analysis

model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]
docs-paths: ["docs"]
asset-paths: ["assets"]
target-path: "target"

clean-targets:
  - "target"
  - "dbt_packages"

query-tag: "ecomm_analysis_{{ target.name }}"

# Global model configs
models:
  ecomm_analysis:
    # Staging: views for lightweight transformation
    staging:
      +materialized: view
      +schema: staging
      +tags: ["staging", "raw"]

    # Intermediate: ephemeral or views for complex joins
    intermediate:
      +materialized: ephemeral
      +tags: ["intermediate", "daily"]

    # Marts: tables for BI consumption
    marts:
      +materialized: table
      +tags: ["marts", "analytics", "core"]
      core:
        +materialized: table
        +schema: core
      analytics:
        +materialized: view
        +schema: analytics

tests:
  +store_failures: true
  +severity: warn

vars:
  # Date range filter for incremental loads
  start_date: "2016-01-01"
  end_date: "2018-12-31"