dbt_project.yml

name: 'youtube_analytics_integration_tests'
version: '0.5.0'
profile: 'integration_tests'
config-version: 2
vars:
  youtube_analytics_source:
    youtube_analytics_channel_basic_a_2_identifier: "youtube_channel_basic_data"
    youtube_analytics_channel_demographics_a_1_identifier: "youtube_channel_demographics_data"
    youtube_analytics_video_identifier: "youtube_video_data"
  youtube_analytics_schema: youtube_analytics_integration_tests_4

models: 
  +schema: "youtube_analytics_{{ var('directed_schema','dev') }}"

seeds:
  youtube_analytics_integration_tests:
    +quote_columns: "{{ true if target.type in ('redshift', 'postgres') else false }}"
    youtube_channel_basic_data:
      +column_types:
        annotation_click_through_rate: "{{ 'float64' if target.name == 'bigquery' else 'float' }}"
        annotation_close_rate: "{{ 'float64' if target.name == 'bigquery' else 'float' }}"
        average_view_duration_percentage: "{{ 'float64' if target.name == 'bigquery' else 'float' }}"
        average_view_duration_seconds: "{{ 'float64' if target.name == 'bigquery' else 'float' }}"
        card_click_rate: "{{ 'float64' if target.name == 'bigquery' else 'float' }}"
        card_teaser_click_rate: "{{ 'float64' if target.name == 'bigquery' else 'float' }}"
        red_watch_time_minutes: "{{ 'float64' if target.name == 'bigquery' else 'float' }}"
        watch_time_minutes: "{{ 'float64' if target.name == 'bigquery' else 'float' }}"
    youtube_video_data:
      +column_types:
        snippet_thumbnails: "{{ 'string' if target.type in ('bigquery','spark','databricks') else 'varchar' }}"


dispatch:
  - macro_namespace: dbt_utils
    search_order: ['spark_utils', 'dbt_utils']