poc-data-engineering-coding-challenge/dbt_project.yml at master · helloextend/poc-data-engineering-coding-challenge · 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
name: 'principal_de_interview'
version: '1.0.0'
config-version: 2

profile: 'dbt_duckdb'

model-paths: ["models"]
analysis-paths: ["analysis"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]

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

models:
  principal_de_interview:
    orders:
      base:
        +materialized: view
        +schema: orders_base
      staging:
        +materialized: view
        +schema: orders_staging
      dw:
        +materialized: incremental
        +schema: orders_dw
      reporting:
        +materialized: view
        +schema: orders_reporting
    merchants:
      base:
        +materialized: view
        +schema: merchants_base
      staging:
        +materialized: view
        +schema: merchants_staging
      lookup:
        +materialized: table
        +schema: merchants_lookup