# 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"]
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:
    +access: public

    project_moments:
      +schema: "project_moments"
      +access: public

    label_reviews:
      +schema: "label_reviews"
      +access: public

      oasis_analysis_nov_2023:
        +schema: "dev_label_reviews"

    bi_analytics:
      bi_analytics_store_models:
        +full_refresh: false
        +access: public

      bi_analytics_use_case_models:
        +full_refresh: false
        +access: public

    bi_looker_reporting:
      label_manager_control_panel:
        +schema: "label_manager_control_panel"
        +access: public

    bi_business_reviews:
      +schema: "business_reviews"
      +access: public

    +snowflake_warehouse: "{{env_var('DBT_SNOWFLAKE_WAREHOUSE','PROD_ANALYTICS_ORCHARD_MEDIUM')}}"
  elementary:
    +schema: "elementary"
    +enabled: "{{ (target.name == 'prod') | as_bool }}"

    +meta:
      models:
vars:
  test_labels: "21966,21989,24792,28847,32439,32277,25223"
  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




flags:
  require_generic_test_arguments_property: true