# Package name
name: 'base'
version: '1.1'

config-version: 2

# DB connection profile
profile: 'snowflake'

test-paths: ["tests"]

# Models to run
models:
    base:
        +materialized: view
        # Grant permissions to all tables
        +post-hook:
          - '{{ utils.grant_permissions() }}'

vars:
    base:
        amazon: "DS_CHARTMETRIC.RAW_DATA.AMAZON"
        amazon_playlist: "DS_CHARTMETRIC.RAW_DATA.AMAZON_PLAYLIST"
        cm_tag: "DS_CHARTMETRIC.RAW_DATA.CM_TAG"
        deezer: "DS_CHARTMETRIC.RAW_DATA.DEEZER"
        deezer_user: "DS_CHARTMETRIC.RAW_DATA.DEEZER_USER"
        deezer_playlist: "DS_CHARTMETRIC.RAW_DATA.DEEZER_PLAYLIST"
        deezer_playlist_stat: "DS_CHARTMETRIC.RAW_DATA.DEEZER_PLAYLIST_STAT"
        itunes: "DS_CHARTMETRIC.RAW_DATA.ITUNES"
        itunes_album: "DS_CHARTMETRIC.RAW_DATA.ITUNES_ALBUM"
        itunes_playlist: "DS_CHARTMETRIC.RAW_DATA.ITUNES_PLAYLIST"
        itunes_playlist_owner: "DS_CHARTMETRIC.RAW_DATA.ITUNES_PLAYLIST_OWNER"
        itunes_playlist_storefront: "DS_CHARTMETRIC.RAW_DATA.ITUNES_PLAYLIST_STOREFRONT"
        l_amazon_playlist: "DS_CHARTMETRIC.RAW_DATA.L_AMAZON_PLAYLIST"
        l_amazon_playlist_history: "DS_CHARTMETRIC.RAW_DATA.L_AMAZON_PLAYLIST_HISTORY"
        l_amazon_playlist_stat: "DS_CHARTMETRIC.RAW_DATA.L_AMAZON_PLAYLIST_STAT"
        l_deezer_playlist: "DS_CHARTMETRIC.RAW_DATA.L_DEEZER_PLAYLIST"
        l_deezer_playlist_history: "DS_CHARTMETRIC.RAW_DATA.L_DEEZER_PLAYLIST_HISTORY"
        l_deezer_playlist_tag: "DS_CHARTMETRIC.RAW_DATA.L_DEEZER_PLAYLIST_TAG"
        l_deezer_playlist_stat: "DS_CHARTMETRIC.RAW_DATA.L_DEEZER_PLAYLIST_STAT"
        l_itunes_playlist: "DS_CHARTMETRIC.RAW_DATA.L_ITUNES_PLAYLIST"
        l_itunes_playlist_history: "DS_CHARTMETRIC.RAW_DATA.L_ITUNES_PLAYLIST_HISTORY"
        l_itunes_playlist_stat: "DS_CHARTMETRIC.RAW_DATA.L_ITUNES_PLAYLIST_STAT"
        l_itunes_playlist_tag: "DS_CHARTMETRIC.RAW_DATA.L_ITUNES_PLAYLIST_TAG"
        l_spotify_playlist: "DS_CHARTMETRIC.RAW_DATA.L_SPOTIFY_PLAYLIST"
        l_spotify_playlist_history: "DS_CHARTMETRIC.RAW_DATA.L_SPOTIFY_PLAYLIST_HISTORY"
        l_spotify_playlist_stat: "DS_CHARTMETRIC.RAW_DATA.L_SPOTIFY_PLAYLIST_STAT"
        l_spotify_playlist_tag: "DS_CHARTMETRIC.RAW_DATA.L_SPOTIFY_PLAYLIST_TAG"
        l_youtube_playlist: "DS_CHARTMETRIC.RAW_DATA.L_YOUTUBE_PLAYLIST"
        l_youtube_playlist_history: "DS_CHARTMETRIC.RAW_DATA.L_YOUTUBE_PLAYLIST_HISTORY"
        l_youtube_playlist_stat: "DS_CHARTMETRIC.RAW_DATA.L_YOUTUBE_PLAYLIST_STAT"
        l_spotify_playlist_sony: "CHARTMETRIC.SHARES.L_SPOTIFY_PLAYLIST_SONY"
        spotify: "DS_CHARTMETRIC.RAW_DATA.SPOTIFY"
        spotify_album: "DS_CHARTMETRIC.RAW_DATA.SPOTIFY_ALBUM"
        spotify_playlist: "DS_CHARTMETRIC.RAW_DATA.SPOTIFY_PLAYLIST"
        spotify_playlist_owner: "DS_CHARTMETRIC.RAW_DATA.SPOTIFY_PLAYLIST_OWNER"
        spotify_playlist_stat:  "DS_CHARTMETRIC.RAW_DATA.SPOTIFY_PLAYLIST_STAT"
        youtube: "DS_CHARTMETRIC.RAW_DATA.YOUTUBE"
        youtube_playlist: "DS_CHARTMETRIC.RAW_DATA.YOUTUBE_PLAYLIST"
        youtube_playlist_stat: "DS_CHARTMETRIC.RAW_DATA.YOUTUBE_PLAYLIST_STAT"
        sony_product_master: "SONY_INTERNAL.DEV.PRODUCT_MASTER"