dbt_project.yml

# Project names should contain only lowercase characters and underscores. 
name: 'palladium_kenya_analytics'
version: '1.0.0'
config-version: 2

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

# Configuring models
models:
  palladium_kenya_analytics:
    staging_layer:
     +materialized: table
     +schema: staging_layer
    dimensional_layer:
      +materialized: table
      +schema: dimensional_layer
    intermediate_layer:
      +materialized: table
      +schema: intermediate_layer
    universal_semantic_layer:
      +materialized: table
      +schema: universal_semantic_layer
# Configuring where test failures are saved
tests:
  +store_failures: true
  +schema: dbt_test__audit  


# Configuring varibales to be used in the transformations
vars:
  years_back: 3
  unknown_key: "md5(cast('-1' as varchar))"
  date_unknown_key: "md5(cast('1900-01-01' as varchar))"

# These configurations specify where dbt should look for different types of files.
model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]

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


dispatch:
  - macro_namespace: dbt_utils
    search_order: ['tsql_utils', 'dbt_utils']
  - macro_namespace: dbt_date
    search_order: ['tsql_utils', 'dbt_date']
  - macro_namespace: dbt_expectations
    search_order: ['tsql_utils', 'dbt_expectations']
  - macro_namespace: audit_helper
    search_order: ['tsql_utils', 'audit_helper']