# Package name
name: 'views'
version: '1.2'

config-version: 2

# DB connection profile
profile: 'snowflake'

test-paths: ["tests"]

# Models to run
models:
    views:
        # models
        by_account:
            +enabled: true

        by_account_country:
            +enabled: true

        by_channel_country_feed:
            +enabled: true

        by_channel_country_source_feed:
            +enabled: true

        by_channel_feed:
            +enabled: true

        by_channel_source_feed:
            +enabled: true

        by_account_video:
            +enabled: true

        by_account_video_country:
            +enabled: true

        by_video_base:
            +enabled: true

        by_video_country_feed:
            +enabled: true

        by_video_feed:
            +enabled: true

        by_video_source_base:
            +enabled: true

        by_video_source_country_feed:
            +enabled: true

        by_video_source_feed:
            +enabled: true

        operations:
            upgrade:
                +enabled: true

        # Grant permissions to all tables
        +post-hook:
          - '{{ utils.grant_permissions() }}'

vars:
    views:
        # Production view names
        views_by_channel_country_feed_distributor_daily: "VIEWS_BY_CHANNEL_COUNTRY_FEED_DISTRIBUTOR_DAILY"
        views_by_channel_country_feed_distributor_rollup: "VIEWS_BY_CHANNEL_COUNTRY_FEED_DISTRIBUTOR_ROLLUP"
        views_by_channel_feed_distributor_daily: "VIEWS_BY_CHANNEL_FEED_DISTRIBUTOR_DAILY"
        views_by_channel_feed_distributor_rollup: "VIEWS_BY_CHANNEL_FEED_DISTRIBUTOR_ROLLUP"

        views_by_channel_source_country_feed_distributor_daily: "VIEWS_BY_CHANNEL_SOURCE_COUNTRY_FEED_DISTRIBUTOR_DAILY"
        views_by_channel_source_feed_distributor_daily: "VIEWS_BY_CHANNEL_SOURCE_FEED_DISTRIBUTOR_DAILY"

        views_by_video_country_feed_distributor_daily: "VIEWS_BY_VIDEO_COUNTRY_FEED_DISTRIBUTOR_DAILY"
        views_by_video_country_feed_distributor_daily_recent: "VIEWS_BY_VIDEO_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT"
        views_by_video_country_feed_distributor_daily_history: "VIEWS_BY_VIDEO_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY"
        views_by_video_feed_distributor_daily: "VIEWS_BY_VIDEO_FEED_DISTRIBUTOR_DAILY"
        views_by_video_feed_distributor_rollup: "VIEWS_BY_VIDEO_FEED_DISTRIBUTOR_ROLLUP"
        views_by_video_source_country_feed_distributor_daily_recent: "VIEWS_BY_VIDEO_SOURCE_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT"
        views_by_video_source_country_feed_distributor_daily_history: "VIEWS_BY_VIDEO_SOURCE_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY"
        views_by_video_source_feed_distributor_daily_recent: "VIEWS_BY_VIDEO_SOURCE_FEED_DISTRIBUTOR_DAILY_RECENT"
        views_by_video_source_feed_distributor_daily_history: "VIEWS_BY_VIDEO_SOURCE_FEED_DISTRIBUTOR_DAILY_HISTORY"
        views_by_video_source_feed_distributor_rollup: "VIEWS_BY_VIDEO_SOURCE_FEED_DISTRIBUTOR_ROLLUP"

        views_by_account_distributor_daily: "VIEWS_BY_ACCOUNT_DISTRIBUTOR_DAILY"
        views_by_account_country_distributor_daily_recent: "VIEWS_BY_ACCOUNT_COUNTRY_DISTRIBUTOR_DAILY_RECENT"
        views_by_account_country_distributor_daily_history: "VIEWS_BY_ACCOUNT_COUNTRY_DISTRIBUTOR_DAILY_HISTORY"