economic-data-project/dbt_project/dbt_project.yml at 88fb5f77847edf3794ca4a9449a7198200a582b6 · C00ldudeNoonan/economic-data-project · 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
56
57
58
59
60
61
62
63
64
65
66
name: "dbt_project"
version: "1.0.0"
config-version: 2
profile: "econ_database"

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

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

# Model configurations
# Schema values map to BigQuery datasets. generate_schema_name appends
# environment suffixes for dev and staging targets while leaving prod canonical.
models:
  dbt_project_evaluator:
    +enabled: "{{ var('enable_dbt_project_evaluator', false) }}"
  dbt_project:
    +materialized: table
    staging:
      +schema: economics_staging
      +materialized: view
      corporate_actions:
        +enabled: "{{ var('enable_legacy_staging_alias_models', false) }}"
      split_adjusted_prices:
        +enabled: "{{ var('enable_legacy_staging_alias_models', false) }}"
    markets:
      +schema: economics_marts
      +materialized: table
      major_indicies_summary:
        +enabled: "{{ var('enable_legacy_misspelled_market_models', false) }}"
      major_indicies_analysis_return:
        +enabled: "{{ var('enable_legacy_misspelled_market_models', false) }}"
    commodities:
      +schema: economics_marts
      +materialized: table
    government:
      +schema: economics_marts
      +materialized: table
    signals:
      +schema: economics_signals
      +materialized: table
    semantic_layer:
      +schema: economics_marts
      +materialized: table
    agents_preprocess:
      +schema: economics_analysis
      +materialized: view
    data_quality:
      +schema: economics_staging
      +materialized: table
    analysis:
      +schema: economics_analysis
      +materialized: table
    backtesting:
      +schema: economics_backtesting
      +materialized: incremental
      +file_format: iceberg
      +catalog: iceberg_catalog