# 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: 'bi_analytics_dbt'
version: '1.0.0'
config-version: 2

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

# 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"]

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

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

# In this example config, we tell dbt to build all models in the example/ directory
# as tables. These settings can be overridden in the individual model files
# using the `{{ config(...) }}` macro.

seeds:
  bi_analytics_dbt:
    +schema: seed_data

models:
  bi_analytics_dbt:
    snowflake_warehouse: "{{env_var('DBT_SNOWFLAKE_WAREHOUSE','PROD_ANALYTICS_ORCHARD_MEDIUM')}}"

    project_moments: 
      +schema: "project_moments"

    label_reviews: 
      +schema: "label_reviews"

      oasis_analysis_nov_2023: 
        +schema: "dev_label_reviews"

    bi_analytics:
      bi_analytics_store_models:
        +full_refresh: false
      
      bi_analytics_use_case_models:
        +full_refresh: false
    
    bi_looker_reporting:
      label_manager_control_panel:
        +schema: "label_manager_control_panel"

    bi_business_reviews:
      +schema: "business_reviews"

  elementary:
    +schema: "elementary"
    models:
    +enabled: "{{ (target.name == 'prod') | as_bool }}"

vars: 
  test_labels: "21966,21989,24792,28847,32439,32277"
  awal_test_labels: "42946,61359,56734,37934"
  altafonte_test_labels: "784730,784730,784229,789358,790148"
  abacus_test_ids: "65137, 56442, 60449, 53354, 56734"
  # Make sure these are in alphabetical order % the final wh has no comma
  analytics_warehouses: " 'ANALYTICS_AD_HOC',
                          'ANALYTICS_DBT_FORECASTING',
                          'AWAL_LOOKER_WH',
                          'DEV_ANALYTICS_ORCHARD',
                          'DEV_ANALYTICS_ORCHARD_LARGE',
                          'KNR_LOOKER_WH',
                          'LOOKER_HIGH_PERFORMANCE',
                          'LOOKER_WH',
                          'LOOKER_WH_2',
                          'LOOKER_WH_ABACUS',
                          'LOOKER_WH_EXPLORE',
                          'LOOKER_WH_SONY',
                          'LOOKER_WH_X_SMALL',
                          'PROD_ANALYTICS_ORCHARD_BACKFILL',
                          'PROD_ANALYTICS_ORCHARD_EXTERNAL',
                          'PROD_ANALYTICS_ORCHARD_LARGE',
                          'PROD_ANALYTICS_ORCHARD_MEDIUM',
                          'PROD_ANALYTICS_ORCHARD_XL',
                          'PROD_KNR_ORCHARD_LARGE',
                          'PROD_KNR_ORCHARD_MEDIUM',
                          'PROD_RIGHTS_MGMT_ORCHARD_LARGE',
                          'PROD_RIGHTS_MGMT_ORCHARD_MEDIUM',
                          'PROD_STRATEGY_ORCHARD_LARGE',
                          'PROD_STRATEGY_ORCHARD_MEDIUM',
                          'LOOKER_WH_PUBLISHING',
                          'LOOKER_WH_ACCOUNTING_AGGREGATES',
                          'LOOKER_WH_INTEGRATION',
                          'LOOKER_WH_PDE',
                          'LOOKER_WH_ORCHARD_BIZ_REV',
                          'LOOKER_WH_YOUTUBE',
                          'LOOKER_WH_SONY_PODCASTING',
                          'LOOKER_WH_STRATEGY'"

  download_transaction_ids: 26,23,22,19,13,12,8,7,6,4
  large_warehouse: "PROD_ANALYTICS_ORCHARD_LARGE"
  xl_warehouse: "PROD_ANALYTICS_ORCHARD_XL"

  require_explicit_package_overrides_for_builtin_materializations: false
  mute_ensure_materialization_override: true