dbt_project.yml

# Name your project! Project names should contain only lowercase characters
# and underscores. A good package name should reflect your organization's
# name or the intended use of these models
name: 'tpch'
version: '1.0.0'
config-version: 2

# This setting configures which "profile" dbt uses for this project.
profile: 'tpch'

# These configurations specify where dbt should look for different types of files.
# The `source-paths` config, for example, states that models in this project can be
# found in the "models/" directory. You probably won't need to change these!
model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]
asset-paths: ["assets"]


target-path: "target"  # directory which will store compiled SQL files
clean-targets:         # directories to be removed by `dbt clean`
    - "target"
    - "dbt_modules"
    - "dbt_packages"

vars:
  start_date: '1999-01-01'
  dbt_cloud_account_id: 43786

# Configuring models
# Full documentation: https://docs.getdbt.com/docs/configuring-models

models:
  use_anonymous_sproc: true

  tpch:
    staging:
      +materialized: view
      tpch:
        +tags: "pii"
      stocks:
        +group: investment_research

    marts:
      core:
        +materialized: table
        +group: sales
    ml:
      +enabled: false

seeds:
  tpch:
    snowflake_contract_rates:
      +column_types:
        effective_date: DATE
        rate: NUMBER

dbt-cloud:
  defer-env-id: '218762'
  project-id: '270542'