# Name your package! Package 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: 'dbt_dev'
version: '1.1'

# This setting configures which "profile" dbt uses for this project. Profiles contain
# database connection information, and should be configured in the  ~/.dbt/profiles.yml file
profile: 'dbt_dev'

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

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

# You can define configurations for models in the `source-paths` directory here.
# Using these configurations, you can enable or disable models, change how they
# are materialized, and more!

# In this example config, we tell dbt to build all models in the example/ directory
# as views (the default). These settings can be overridden in the individual model files
# using the `{{ config(...) }}` macro.
models:
  dbt_dev:
      accounting_analytics_blend:
          materialized: table
          enabled: TRUE

      accounting_analytics_blend_v2:
          materialized: view
          enabled: TRUE

      restrictions:
          materialized: view

      delivery_history:
          materialized: view

      iTunes_content_validation:
          materialized: view

      release_track_artists:
          materialized: view

      weekly_analytics:
          materialized: table

      analytics_last_sales_week:
          materialized: table

      daily_spikes:
          pre-hook: "USE ROLE PROD_DATALYTICS_ROLE"
          materialized: table

      youtube_invalid_references:
          materialized: view

      estimated_revenue:
          materialized: table

      bits_per_sample:
         materialized: view

      daily_top_content:
         materialized: table
         pre-hook: "USE ROLE PROD_DATALYTICS_ROLE"
         vars:
           store_name: "Dummy"
           country_name: "Dummy"
           feedid: "Dummy"
           table_name: "Dummy"
           trending_tracks_country_name: "Dummy"

      genre_benchmarking:
         materialized: view

      test_pipenv:
        pre-hook: "USE ROLE PROD_DATALYTICS_ROLE"


      estimated_revenue_baseline_remaps:
        enabled: True
        vars:
            activityperiodid: "Dummy"
            activity_month: "Dummy"
            table_name: "Dummy"

      top_genres_subgenres_artists_other_labels:
        enabled: True
        materialized: table
        vars:
            labelid: 'Dummy'
            startdate: 'Dummy'

      top_artists_other_label_by_artist_by_listener:
        enabled: True
        materialized: table
        vars:
            labelid: 'Dummy'
            startdate: 'Dummy'
            artistid: 'Dummy'

      push_notifications:
        enabled: True

      push_notifications_social:
        enabled: True

      release_schedule_dashboard:
        enabled: True

      global_impact_analysis:
        enabled: True

      editorial_playlists:
        enabled: True
        materialized: table
        post-hook:
          - "GRANT ALL ON intelligence.prod.dim_editorial_playlist_top_non_editorial_playlist TO ROLE DEV_ENGINEERING"
          - "GRANT ALL ON intelligence.prod.dim_editorial_playlist_top_non_editorial_playlist TO ROLE QA_SWF_ACTIVITY_DETECTOR "
          - "GRANT ALL ON intelligence.prod.dim_editorial_playlist_top_non_editorial_playlist TO ROLE PROD_SWF_ACTIVITY_DETECTOR"

      fact_analytics_2020:
        enabled: True

      apple_pitch_grid:
        enabled: True

      iTunes_language_validation:
        enabled: True

      util_views:
        enabled: True

      orchard_store_pricing:
        enabled: True

      store_genre_subgenre_mappings:
        enabled: True

      release_change_log:
        enabled: True

      release_forecasting:
        enabled: True
        materialized: table

      storefront_links:
        enabled: True

      test_bi_rollup:
        enabled: True
        materialized: table

      bi_rollup:
        enabled: True
        materialized: table
        
      internal_conflicts:
        enabled: True

      test_dev_process:
        enabled: True
        materialized: table

      base:
        materialized: view
        vars: 
          test_labels: "6971,7584,9808,15063,21989,22572"


seeds:
  dbt_dev:
        phonofile_profit_centers:
            enabled: false

        apple_activity_months:
            enabled: false