# Package name name: 'metrics' version: '1.2' config-version: 2 # DB connection profile profile: 'snowflake' test-paths: ["tests"] # Models to run models: metrics: # models by_account_28_days_feed: +enabled: true by_account_country_feed: +enabled: true by_channel_country_feed: +enabled: true by_channel_feed: +enabled: true by_track_country_feed: +enabled: true by_isrc_country_feed: +enabled: true by_track_feed: +enabled: true by_track_participant_country_feed: +enabled: true by_track_participant_feed: +enabled: true by_video_country_feed: +enabled: true by_video_feed: +enabled: true ugc_by_video_asset_feed: +enabled: true by_product_country_feed: +enabled: true by_product_feed: +enabled: true by_participant_track_28_days_rollup: +enabled: true by_participant_product_country_feed: +enabled: true by_product_participant_country_feed: +enabled: true by_product_participant_feed: +enabled: true by_multi_product_country_feed: +enabled: true by_multi_product_feed: +enabled: true operations: upgrade: +enabled: true # Grant permissions to all tables +post-hook: - '{{ utils.grant_permissions() }}' vars: metrics: # Production view names global_participant_by_product_id_by_isrc: "GLOBAL_PARTICIPANT_BY_PRODUCT_ID_BY_ISRC" metrics_by_account_28_days_rollup: "METRICS_BY_ACCOUNT_28_DAYS_ROLLUP" metrics_by_account_country_feed_distributor_rollup: "METRICS_BY_ACCOUNT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP" metrics_by_account_track_country_feed_distributor_rollup: "METRICS_BY_ACCOUNT_TRACK_COUNTRY_FEED_DISTRIBUTOR_ROLLUP" metrics_by_channel_country_feed_distributor_rollup: "METRICS_BY_CHANNEL_COUNTRY_FEED_DISTRIBUTOR_ROLLUP" metrics_by_channel_feed_distributor_rollup: "METRICS_BY_CHANNEL_FEED_DISTRIBUTOR_ROLLUP" metrics_by_isrc_country_feed_distributor_rollup: "METRICS_BY_ISRC_COUNTRY_FEED_DISTRIBUTOR_ROLLUP" metrics_by_multi_product_country_feed_distributor_rollup: "METRICS_BY_MULTI_PRODUCT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP" metrics_by_multi_product_feed_distributor_rollup: "METRICS_BY_MULTI_PRODUCT_FEED_DISTRIBUTOR_ROLLUP" metrics_by_participant_product_country_feed_distributor_rollup: "METRICS_BY_PARTICIPANT_PRODUCT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP" metrics_by_participant_track_28_days_rollup: "METRICS_BY_PARTICIPANT_TRACK_28_DAYS_ROLLUP" metrics_by_product_country_feed_distributor_rollup: "METRICS_BY_PRODUCT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP" metrics_by_product_feed_distributor_rollup: "METRICS_BY_PRODUCT_FEED_DISTRIBUTOR_ROLLUP" metrics_by_product_participant_country_feed_distributor_rollup: "METRICS_BY_PRODUCT_PARTICIPANT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP" metrics_by_product_participant_feed_distributor_rollup: "METRICS_BY_PRODUCT_PARTICIPANT_FEED_DISTRIBUTOR_ROLLUP" metrics_by_track_feed_distributor_rollup: "METRICS_BY_TRACK_FEED_DISTRIBUTOR_ROLLUP" metrics_by_track_participant_feed_distributor_rollup: "METRICS_BY_TRACK_PARTICIPANT_FEED_DISTRIBUTOR_ROLLUP" metrics_by_video_country_feed_distributor_rollup: "METRICS_BY_VIDEO_COUNTRY_FEED_DISTRIBUTOR_ROLLUP" metrics_by_video_feed_distributor_rollup: "METRICS_BY_VIDEO_FEED_DISTRIBUTOR_ROLLUP" metrics_ugc_by_video_asset_feed_distributor_rollup_recent: "METRICS_UGC_BY_VIDEO_ASSET_FEED_DISTRIBUTOR_ROLLUP_RECENT" metrics_ugc_by_video_asset_feed_distributor_rollup_history: "METRICS_UGC_BY_VIDEO_ASSET_FEED_DISTRIBUTOR_ROLLUP_HISTORY" metrics_tadas: "METRICS_TADAS" primary_products: "PRIMARY_PRODUCTS" tiktok: "TIKTOK" tiktok_top_videos: "TIKTOK_TOP_VIDEOS" tiktok_top_videos_stat: "TIKTOK_TOP_VIDEOS_STAT" metrics_by_track_region_feed_distributor_rollup_recent: "METRICS_BY_TRACK_REGION_FEED_DISTRIBUTOR_ROLLUP_RECENT" metrics_by_track_region_feed_distributor_rollup_history: "METRICS_BY_TRACK_REGION_FEED_DISTRIBUTOR_ROLLUP_HISTORY" regions: - name: EX_US countries: ["AF","AX","AL","DZ","AS","AD","AO","AI","AQ","AG","AR","AM","AW","AU","AT","AZ","BS","BH","BD","BB","BY","BE","BZ","BJ","BM","BT","BO","BQ","BA","BW","BV","BR","IO","BN","BG","BF","BI","KH","CM","CA","CV","KY","CF","TD","CL","CX","CC","CO","KM","CK","CR","CI","HR","CU","CW","CY","CZ","CD","DK","DJ","DM","DO","EC","EG","SV","GQ","ER","EE","SZ","ET","FK","FO","FJ","FI","FR","GF","PF","TF","GA","GE","DE","GH","GI","GR","GL","GD","GP","GU","GT","GG","GN","GW","GY","HT","HM","VA","HN","HK","HU","IS","IN","ID","IQ","IE","IR","IM","IL","IT","JM","JP","JE","JO","KZ","KE","KI","XK","KW","KG","LA","LV","LB","LS","LR","LY","LI","LT","LU","MO","MG","MW","MY","MV","ML","MT","MH","MQ","MR","MU","YT","MX","FM","MD","MC","MN","ME","MS","MA","MZ","MM","NA","NR","NP","NL","NC","NZ","NI","NE","NG","NU","NF","KP","MP","NO","OM","PK","PW","PA","PG","PY","CN","PE","PH","PN","PL","PT","PR","QA","CG","GM","RE","RO","RU","RW","BL","SH","KN","LC","MF","PM","VC","WS","SM","ST","SA","SN","RS","SC","SL","SG","SX","SK","SI","SB","SO","ZA","GS","KR","SS","ES","LK","PS","SD","SR","SJ","SE","CH","SY","TW","TJ","TH","MK","TL","TG","TK","TO","TT","TN","TR","TM","TC","TV","UG","UA","AE","GB","TZ","UM","UY","UZ","VU","VE","VN","VG","VI","WF","EH","YE","ZM","ZW"] - name: AFRICA countries: ["DZ","AO","BJ","BW","IO","BF","BI","CM","CV","CF","TD","KM","CI","CD","DJ","EG","GQ","ER","SZ","ET","GA","GH","GN","GW","KE","LS","LR","LY","MG","MW","ML","MR","MU","YT","MA","MZ","NA","NE","NG","CG","GM","RE","RW","SH","ST","SN","SC","SL","SO","ZA","SS","SD","TG","TN","UG","TZ","EH","ZM","ZW" ] - name: ASIA countries: ["AF","AM","AZ","BH","BD","BT","BN","KH","CY","GE","HK","IN","ID","IQ","IR","IL","JP","JO","KZ","KW","KG","LA","LB","MO","MY","MV","MN","MM","NP","KP","OM","PK","CN","PH","QA","SA","SG","KR","LK","PS","SY","TW","TJ","TH","TL","TR","TM","AE","UZ","VN","YE"] - name: CIS countries: ["AM", "AZ", "BY", "KZ", "KG", "MD", "MN", "RU", "TJ", "TM", "UA", "UZ"] - name: EUROPE countries: ["AX","AL","AD","AT","BY","BE","BA","BG","HR","CZ","DK","EE","FO","FI","FR","DE","GI","GR","GG","VA","HU","IS","IE","IM","IT","JE","XK","LV","LI","LT","LU","MT","MD","MC","ME","NL","NO","PL","PT","RO","RU","BL","MF","SM","RS","SX","SK","SI","ES","SJ","SE","CH","MK","UA","GB"] - name: DACH countries: ["AT", "DE", "CH"] - name: LATIN_IBERIA countries: ["AI","AG","AR","BB","BZ","BM","BO","BR","VG","KY","CL","CO","CR","DM","DO","EC","SV","GD","GT","HN","MX","NI","PA","PY","PE","PT","KN","ES","TT","UY","VE"] - name: MIDDLE_EAST countries: ["AF","BH","EG","IQ","JO","KW","LB","OM","PS","QA","SA","SD","SY","AE","YE"] - name: NORDICS countries: ["DK", "FI", "IS", "NO", "SE"] - name: NORTH_AMERICA countries: ["AI","AG","AW","BS","BB","BZ","BM","CA","KY","CR","CU","DM","DO","SV","GL","GD","GP","GT","HT","HN","JM","MQ","MX","MS","NI","PA","PR","KN","LC","PM","VC","TT","TC","US","VG","VI"] - name: OCEANIA countries: ["AS","AU","CX","CC","CK","FJ","PF","GU","KI","MH","FM","NR","NC","NZ","NU","NF","MP","PW","PG","PN","WS","SB","TK","TO","TV","UM","VU","WF"] - name: SOUTH_AMERICA countries: ["AR","BO","BQ","BR","CL","CO","CW","EC","FK","GF","GY","PY","PE","SR","UY","VE"]