version: 2 # deduplicated list of all source and seeded tables used in this project sources: #snowflake tables # From https://docs.getdbt.com/docs/build/sources#declaring-a-source: By default, schema will be the same as name. - name: "{% if target.name == 'test' %}{{ env_var('SNOWFLAKE_SCHEMA') }}{% else %}{{ env_var('SOURCE_SNOWFLAKE_SCHEMA', env_var('SNOWFLAKE_SCHEMA')) }}{% endif %}" database: "{% if target.name == 'test' %}{{ env_var('SNOWFLAKE_DATABASE') }}{% else %}{{ env_var('SOURCE_SNOWFLAKE_DATABASE', env_var('SNOWFLAKE_DATABASE', '')) }}{% endif %}" tables: # split tables - name: METRICS_BY_TRACK_PARTICIPANT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_RECENT - name: METRICS_BY_TRACK_PARTICIPANT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_HISTORY - name: METRICS_BY_TRACK_REGION_FEED_DISTRIBUTOR_ROLLUP_RECENT - name: METRICS_BY_TRACK_REGION_FEED_DISTRIBUTOR_ROLLUP_HISTORY - name: METRICS_BY_MULTI_PRODUCT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_RECENT - name: METRICS_BY_MULTI_PRODUCT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_HISTORY - name: METRICS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_RECENT - name: METRICS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_HISTORY - name: METRICS_UGC_BY_VIDEO_ASSET_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_RECENT - name: METRICS_UGC_BY_VIDEO_ASSET_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_HISTORY - name: METRICS_UGC_BY_VIDEO_ASSET_FEED_DISTRIBUTOR_ROLLUP_RECENT - name: METRICS_UGC_BY_VIDEO_ASSET_FEED_DISTRIBUTOR_ROLLUP_HISTORY - name: STREAMS_BY_ACCOUNT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_ACCOUNT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_BY_ACCOUNT_TRACK_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_ACCOUNT_TRACK_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_BY_PARTICIPANT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_PARTICIPANT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_BY_PARTICIPANT_TRACK_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_PARTICIPANT_TRACK_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_BY_PRODUCT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_PRODUCT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_BY_PRODUCT_TRACK_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_PRODUCT_TRACK_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: YOUTUBE_STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: YOUTUBE_STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: YOUTUBE_STREAMS_BY_TRACK_FEED_DISTRIBUTOR_DAILY_RECENT - name: YOUTUBE_STREAMS_BY_TRACK_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_RECENT - name: STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_HISTORY - name: STREAMS_BY_TRACK_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_TRACK_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_RECENT - name: STREAMS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_HISTORY - name: STREAMS_BY_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_BY_PARTICIPANT_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_BY_PARTICIPANT_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_COMPLETIONS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_COMPLETIONS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_COMPLETIONS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_RECENT - name: STREAMS_COMPLETIONS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_HISTORY - name: STREAMS_DEMOGRAPHICS_BY_PARTICIPANT_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_DEMOGRAPHICS_BY_PARTICIPANT_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_DEMOGRAPHICS_BY_PARTICIPANT_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_DEMOGRAPHICS_BY_PARTICIPANT_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_DEMOGRAPHICS_BY_PRODUCT_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_DEMOGRAPHICS_BY_PRODUCT_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_DEMOGRAPHICS_BY_PRODUCT_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_DEMOGRAPHICS_BY_PRODUCT_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_DEMOGRAPHICS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_DEMOGRAPHICS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_DEMOGRAPHICS_BY_TRACK_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_DEMOGRAPHICS_BY_TRACK_FEED_DISTRIBUTOR_DAILY_HISTORY - name: STREAMS_ENRICHED_WITH_TIKTOK_BY_TRACK_COUNTRY_DISTRIBUTOR_ROLLUP_RECENT - name: STREAMS_ENRICHED_WITH_TIKTOK_BY_TRACK_COUNTRY_DISTRIBUTOR_ROLLUP_HISTORY - name: STREAMS_ENRICHED_WITH_TIKTOK_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: STREAMS_ENRICHED_WITH_TIKTOK_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: SUMMARY_DEMOGRAPHICS_BY_ARTIST_FEED_DISTRIBUTOR_RECENT - name: SUMMARY_DEMOGRAPHICS_BY_ARTIST_FEED_DISTRIBUTOR_HISTORY - name: SUMMARY_DEMOGRAPHICS_BY_ISRC_FEED_DISTRIBUTOR_RECENT - name: SUMMARY_DEMOGRAPHICS_BY_ISRC_FEED_DISTRIBUTOR_HISTORY - name: SUMMARY_GEOGRAPHICS_BY_ARTIST_FEED_DISTRIBUTOR_RECENT - name: SUMMARY_GEOGRAPHICS_BY_ARTIST_FEED_DISTRIBUTOR_HISTORY - name: SUMMARY_GEOGRAPHICS_BY_ISRC_FEED_DISTRIBUTOR_RECENT - name: SUMMARY_GEOGRAPHICS_BY_ISRC_FEED_DISTRIBUTOR_HISTORY - name: SUMMARY_SOS_BY_FEED_DISTRIBUTOR_RECENT - name: SUMMARY_SOS_BY_FEED_DISTRIBUTOR_HISTORY - name: VIEWS_BY_ACCOUNT_COUNTRY_DISTRIBUTOR_DAILY_RECENT - name: VIEWS_BY_ACCOUNT_COUNTRY_DISTRIBUTOR_DAILY_HISTORY - name: VIEWS_BY_ACCOUNT_VIDEO_DISTRIBUTOR_DAILY_RECENT - name: VIEWS_BY_ACCOUNT_VIDEO_DISTRIBUTOR_DAILY_HISTORY - name: VIEWS_BY_ACCOUNT_VIDEO_COUNTRY_DISTRIBUTOR_DAILY_RECENT - name: VIEWS_BY_ACCOUNT_VIDEO_COUNTRY_DISTRIBUTOR_DAILY_HISTORY - name: VIEWS_BY_VIDEO_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: VIEWS_BY_VIDEO_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: VIEWS_BY_VIDEO_SOURCE_COUNTRY_FEED_DISTRIBUTOR_DAILY_RECENT - name: VIEWS_BY_VIDEO_SOURCE_COUNTRY_FEED_DISTRIBUTOR_DAILY_HISTORY - name: VIEWS_BY_VIDEO_SOURCE_FEED_DISTRIBUTOR_DAILY_RECENT - name: VIEWS_BY_VIDEO_SOURCE_FEED_DISTRIBUTOR_DAILY_HISTORY # base tables - name: fact_analytics - name: fact_point_of_sale - name: fact_youtube_asset_analytics - name: fact_youtube_video_analytics - name: fact_youtube_video_demographics - name: fact_socials # data_availability module - name: expected_data_availability_by_store_daily - name: expected_data_availability_by_store_distributor_daily - name: expected_data_availability_skips_saves_by_feed_rollup - name: expected_data_availability_skips_saves_by_feed_summary - name: streams_by_track_country_feed_daily_mock - name: streams_by_track_country_feed_distributor_daily_mock # streams module - name: priority_playlists - name: hourly_playlists columns: - name: source - name: playlist_filter_override - name: TIKTOK_BY_ISRC_COUNTRY_DAILY_HISTORY - name: TIKTOK_BY_ISRC_COUNTRY_DAILY_RECENT - name: TIKTOK_BY_ISRC_PRODUCT_COUNTRY_DAILY_HISTORY - name: TIKTOK_BY_ISRC_PRODUCT_COUNTRY_DAILY_RECENT - name: mappings_product_to_global_participant_mock - name: mapping_isrc_to_global_participant_dbt_mock - name: product_ownership_access_mock - name: v_streams_by_product_track_feed_distributor_daily - name: v_streams_by_product_track_country_feed_distributor_daily - name: v_streams_by_track_country_feed_distributor_daily - name: v_streams_by_track_feed_distributor_daily - name: v_streams_by_track_playlist_country_feed_distributor_daily - name: v_streams_by_playlist_country_feed_distributor_daily - name: v_streams_demographics_by_participant_country_feed_distributor_daily - name: v_streams_demographics_by_participant_feed_distributor_daily - name: SPOTIFY_DEMOGRAPHICS_BY_PLAYLIST_COUNTRY_RECENT - name: SPOTIFY_DEMOGRAPHICS_BY_PLAYLIST_COUNTRY_HISTORY - name: expected_streams_by_account_track_country_feed_distributor_daily_recent - name: expected_streams_by_account_track_country_feed_distributor_daily_history - name: expected_streams_by_account_track_feed_distributor_daily_recent - name: expected_streams_by_account_track_feed_distributor_daily_history - name: expected_metrics_by_participant_product_country_feed_distributor_rollup - name: expected_streams_by_participant_track_country_feed_distributor_daily_history - name: expected_streams_by_participant_track_country_feed_distributor_daily_recent - name: expected_streams_by_participant_track_feed_distributor_daily_history - name: expected_streams_by_participant_track_feed_distributor_daily_recent - name: expected_streams_by_participant_track_playlist_country_feed_distributor_daily_recent - name: expected_streams_by_participant_track_playlist_country_feed_distributor_daily_history - name: expected_streams_by_product_track_country_feed_distributor_daily_recent - name: expected_streams_by_product_track_country_feed_distributor_daily_history - name: expected_streams_by_product_track_feed_distributor_daily_recent - name: expected_streams_by_product_track_feed_distributor_daily_history - name: expected_streams_by_track_country_feed_distributor_daily_recent - name: expected_streams_by_track_country_feed_distributor_daily_history - name: expected_streams_by_track_country_feed_distributor_rollup_recent - name: expected_streams_by_track_country_feed_distributor_rollup_history - name: expected_streams_by_track_country_region_feed_distributor_rollup - name: expected_streams_by_track_feed_distributor_daily_history - name: expected_streams_by_track_feed_distributor_daily_recent - name: expected_streams_by_track_feed_distributor_rollup - name: expected_streams_by_playlist_country_feed_rollup - name: expected_streams_by_playlist_feed_rollup - name: expected_streams_by_track_playlist_country_feed_distributor_rollup_recent - name: expected_streams_by_track_playlist_country_feed_distributor_rollup_history - name: expected_streams_by_track_playlist_country_feed_distributor_daily_history - name: expected_streams_by_track_playlist_country_feed_distributor_daily_recent - name: expected_streams_by_playlist_country_feed_distributor_daily_history - name: expected_streams_by_playlist_country_feed_distributor_daily_recent - name: expected_streams_completions_by_track_playlist_country_feed_distributor_daily_recent - name: expected_streams_completions_by_track_playlist_country_feed_distributor_daily_history - name: expected_streams_completions_by_track_playlist_country_feed_distributor_rollup_recent - name: expected_streams_completions_by_track_playlist_country_feed_distributor_rollup_history - name: expected_streams_demographics_by_track_country_feed_distributor_daily_history - name: expected_streams_demographics_by_track_country_feed_distributor_daily_recent - name: expected_streams_demographics_by_participant_country_feed_distributor_rollup - name: expected_streams_demographics_by_participant_feed_distributor_daily - name: expected_streams_demographics_by_participant_feed_distributor_daily_history - name: expected_streams_demographics_by_participant_feed_distributor_daily_recent - name: expected_streams_demographics_by_product_feed_distributor_daily - name: expected_streams_demographics_by_participant_country_feed_distributor_daily - name: expected_streams_demographics_by_participant_country_feed_distributor_daily_history - name: expected_streams_demographics_by_participant_country_feed_distributor_daily_recent - name: expected_streams_demographics_by_product_country_feed_distributor_daily - name: expected_streams_demographics_by_track_feed_distributor_daily - name: expected_streams_demographics_by_product_country_feed_distributor_rollup - name: expected_spotify_demographics_by_playlist_country_recent - name: expected_spotify_demographics_by_playlist_country_history - name: expected_mappings_product_to_global_participant - name: expected_mappings_product_to_primary_global_participant - name: expected_market_size_by_store_country - name: expected_youtube_streams_by_track_country_feed_distributor_daily_recent # downloads module - name: expected_downloads_by_participant_product_country_feed_distributor_daily - name: expected_downloads_by_participant_product_feed_distributor_daily - name: expected_downloads_by_track_country_feed_daily - name: expected_downloads_by_track_feed_daily - name: expected_downloads_by_track_country_feed_distributor_daily - name: expected_downloads_by_track_feed_distributor_daily - name: expected_downloads_by_participant_track_country_feed_distributor_daily - name: expected_downloads_by_participant_track_feed_distributor_daily - name: expected_downloads_by_product_country_feed_distributor_daily - name: expected_downloads_by_product_feed_distributor_daily - name: expected_downloads_by_product_track_country_feed_distributor_daily - name: expected_downloads_by_product_track_feed_distributor_daily - name: mappings_product_to_global_participant_dbt_mock - name: mappings_product_to_primary_global_participant_dbt_mock # mappings module - name: expected_mappings_track_to_videos - name: expected_mappings_dim_playlist_to_followers - name: expected_mappings_video_to_assets - name: expected_mappings_video_to_participants - name: expected_mappings_video_to_tracks_v3 - name: expected_mappings_video_to_channels - name: expected_mappings_financial_label_id_to_product_ids - name: expected_mappings_financial_label_parent_name_to_label_ids - name: expected_mappings_upper_profit_center_to_product_ids - name: expected_mappings_product_family_to_isrcs - name: expected_mappings_video_to_participants_by_account - name: expected_soundrecording_to_related_videos_primary_audio_product_v2 - name: youtube_channel_mock - name: youtube_channel_upc_mock - name: views_by_video_source_feed_distributor_rollup_mock - name: metrics_by_track_feed_distributor_rollup_mock - name: dbt_fact_youtube_asset_analytics_combined_mock - name: metrics_by_track_feed_distributor_rollup # metrics module - name: tiktok_by_isrc_country_rollup_dbt_mock - name: tadas_global_daily_predictions - name: tadas_daily_predictions - name: expected_metrics_tadas - name: expected_metrics_by_channel_country_feed_distributor_rollup - name: v_streams_by_account_track_country_feed_distributor_daily_mock - name: v_streams_by_participant_track_feed_distributor_daily_mock - name: v_streams_by_track_country_feed_distributor_daily_mock - name: downloads_by_participant_track_feed_distributor_daily_mock - name: downloads_by_participant_product_feed_distributor_daily_mock - name: downloads_by_product_country_feed_distributor_daily_mock - name: downloads_by_track_country_feed_distributor_daily_mock - name: expected_last_4_months_dates_util_dbt - name: expected_metrics_by_account_28_days_rollup - name: expected_metrics_by_account_country_feed_distributor_rollup - name: expected_metrics_by_account_track_country_feed_distributor_rollup - name: expected_metrics_by_channel_feed_distributor_rollup - name: expected_metrics_by_isrc_country_feed_distributor_rollup - name: expected_metrics_by_multi_product_country_feed_distributor_rollup - name: expected_metrics_by_multi_product_feed_distributor_rollup - name: expected_metrics_by_multi_product_participant_country_feed_distributor_rollup - name: expected_metrics_by_multi_product_participant_feed_distributor_rollup - name: expected_metrics_by_participant_track_28_days_rollup - name: expected_metrics_by_product_country_feed_distributor_rollup - name: expected_metrics_by_product_feed_distributor_rollup - name: expected_metrics_by_product_participant_country_feed_distributor_rollup - name: expected_metrics_by_product_participant_feed_distributor_rollup - name: expected_metrics_by_track_country_feed_distributor_rollup - name: expected_metrics_by_track_country_feed_rollup - name: expected_metrics_by_track_feed_distributor_rollup - name: expected_metrics_by_track_region_feed_distributor_rollup - name: expected_metrics_by_track_feed_rollup - name: expected_metrics_by_track_participant_country_feed_distributor_rollup - name: expected_metrics_by_track_participant_feed_distributor_rollup - name: expected_metrics_by_video_country_feed_distributor_rollup - name: expected_metrics_by_video_feed_distributor_rollup - name: expected_metrics_ugc_by_video_asset_feed_distributor_rollup_recent - name: expected_metrics_ugc_by_video_asset_feed_distributor_rollup_history - name: mappings_video_to_tracks_mock - name: placements_adds_by_isrc_country_dbt_mock - name: streams_by_track_country_feed_distributor_rollup_mock - name: streams_by_track_country_feed_distributor_rollup_history_mock - name: streams_by_track_country_feed_distributor_rollup_history_product_transfer_mock - name: streams_by_track_country_feed_distributor_rollup_recent_mock - name: streams_by_track_country_feed_distributor_rollup_recent_product_transfer_mock - name: streams_by_track_country_feed_rollup_mock - name: mappings_product_family_to_isrcs_dbt_mock - name: mappings_isrc_to_min_release_date_dbt_mock - name: views_by_channel_country_feed_distributor_daily_mock - name: views_by_channel_country_feed_distributor_rollup_mock - name: views_by_channel_feed_distributor_daily_mock - name: views_by_channel_feed_distributor_rollup_mock - name: views_by_video_country_feed_distributor_daily_mock - name: views_by_video_feed_distributor_daily_mock # views module - name: expected_views_by_channel_country_feed_distributor_daily - name: expected_views_by_channel_country_feed_distributor_rollup - name: expected_views_by_channel_feed_distributor_daily - name: expected_views_by_channel_feed_distributor_rollup - name: expected_views_by_channel_source_country_feed_distributor_daily - name: expected_views_by_channel_source_country_feed_distributor_rollup - name: expected_views_by_channel_source_feed_distributor_daily - name: expected_views_by_channel_source_feed_distributor_rollup - name: expected_views_by_video_base_dbt - name: expected_views_by_video_country_feed_daily - name: expected_views_by_video_country_feed_rollup - name: expected_views_by_video_feed_daily - name: expected_views_by_video_feed_rollup - name: expected_views_by_video_country_feed_distributor_daily - name: expected_views_by_video_country_feed_distributor_daily_recent - name: expected_views_by_video_country_feed_distributor_daily_history - name: expected_views_by_video_country_feed_distributor_rollup - name: expected_views_by_video_feed_distributor_daily - name: expected_views_by_video_feed_distributor_rollup - name: expected_views_by_video_source_base_dbt - name: expected_views_by_video_source_country_feed_distributor_daily - name: expected_views_by_video_source_country_feed_distributor_daily_recent - name: expected_views_by_video_source_country_feed_distributor_daily_history - name: expected_views_by_video_source_country_feed_distributor_rollup - name: expected_views_by_video_source_feed_distributor_daily_recent - name: expected_views_by_video_source_feed_distributor_daily_history - name: expected_views_by_video_source_feed_distributor_rollup - name: expected_views_by_track_country_feed_distributor_rollup - name: expected_views_by_track_feed_distributor_rollup - name: expected_views_by_account_video_country_distributor_daily_history - name: expected_views_by_account_video_country_distributor_daily_recent - name: expected_views_by_account_video_distributor_daily_history - name: expected_views_by_account_video_distributor_daily_recent # point_of_sale module - name: expected_eu_point_of_sale_by_country - name: expected_eu_point_of_sale_by_product - name: expected_eu_point_of_sale_by_product_country # summary_demographics module - name: expected_summary_demographics_by_isrc_feed - name: expected_summary_demographics_by_artist_feed - name: expected_summary_demographics_by_artist_feed_recent - name: expected_summary_demographics_by_label_feed - name: expected_summary_demographics_by_isrc_feed_distributor - name: expected_summary_demographics_by_isrc_feed_distributor_recent - name: expected_summary_demographics_by_isrc_feed_distributor_history - name: expected_summary_demographics_by_artist_feed_distributor - name: expected_summary_demographics_by_label_feed_distributor # summary_geographics_v2 module - name: expected_summary_geographics_by_isrc_feed_distributor_history - name: expected_summary_geographics_by_isrc_feed_distributor_recent - name: expected_summary_geographics_by_isrc_feed_distributor - name: expected_summary_geographics_by_artist_feed_distributor_recent - name: expected_summary_geographics_by_artist_feed_distributor - name: expected_summary_geographics_by_label_feed_distributor # summary_streams module - name: SUMMARY_METRICS_BY_ISRC_FEED_DISTRIBUTOR_RECENT - name: SUMMARY_METRICS_BY_ISRC_FEED_DISTRIBUTOR_HISTORY - name: expected_summary_metrics_by_isrc_feed_distributor_history - name: expected_summary_metrics_by_isrc_feed_distributor_recent - name: expected_summary_sos_by_feed_distributor - name: expected_summary_sos_by_feed_distributor_recent - name: expected_playlist_metadata_by_feed_distributor - name: expected_placement_by_feed_distributor - name: expected_summary_metrics_by_isrc_feed_distributor - name: expected_summary_streams_by_playlist_feed_distributor # placements module - name: amazon - name: amazon_playlist - name: cm_tag - name: cm_track - name: data_availability_by_store_daily_mock - name: deezer - name: deezer_playlist - name: deezer_playlist_stat - name: deezer_user - name: expected_placements_by_isrc_playlist_amazon - name: expected_placements_by_isrc_playlist_apple - name: expected_placements_by_isrc_playlist_deezer - name: expected_placements_by_isrc_playlist_spotify - name: expected_placements_by_isrc_playlist_youtube - name: expected_placements_by_isrc_playlist_rollup - name: expected_placements_by_participant_isrc_playlist_rollup - name: expected_placements_by_track_country_feed_rollup - name: expected_placements_by_track_country_rollup - name: expected_placements_playlists_by_playlist - name: expected_recent_placements_by_track_playlist_country_feed_rollup - name: expected_placements_state - name: itunes - name: itunes_album - name: itunes_playlist - name: itunes_playlist_owner - name: itunes_playlist_storefront - name: l_amazon_playlist - name: l_amazon_playlist_history - name: l_amazon_playlist_stat - name: l_cm_track_cm_artist - name: l_deezer_playlist - name: l_deezer_playlist_history - name: l_deezer_playlist_stat - name: l_deezer_playlist_tag - name: l_itunes_playlist - name: l_itunes_playlist_history - name: l_itunes_playlist_stat - name: l_itunes_playlist_tag - name: l_spotify_playlist - name: l_spotify_playlist_history - name: l_spotify_playlist_stat - name: l_spotify_playlist_tag - name: l_youtube_playlist - name: l_youtube_playlist_history - name: l_youtube_playlist_stat - name: orchtblspotifyplaylisttracklisthistory - name: placements_by_track_playlist_country_rollup_mock - name: placements_positions_by_playlist_isrc_timestamp_hourly - name: playlist_curator_mappings - name: playlist_mappings - name: spotify - name: spotify_album - name: spotify_playlist - name: spotify_playlist_curators - name: spotify_playlist_owner - name: spotify_playlist_stat - name: streams_completions_by_track_playlist_country_feed_distributor_rollup_mock - name: streams_by_track_playlist_country_feed_distributor_daily_mock - name: streams_by_track_playlist_country_feed_distributor_rollup_mock - name: streams_by_playlist_country_feed_rollup_mock - name: streams_by_playlist_country_feed_rollup_product_transfer_mock - name: streams_by_playlist_rollup_mock - name: streams_by_playlist_rollup_product_transfer_mock - name: streams_by_playlist_country_rollup_mock - name: youtube - name: youtube_playlist - name: youtube_playlist_stat # playlists module - name: clean_dim_playlist_dbt_mock - name: expected_playlists_by_playlist - name: expected_playlists_placement_events_by_isrc_playlist - name: expected_playlists_placements_by_isrc_playlist_country_private - name: expected_playlists_placements_by_isrc_playlist_private - name: expected_playlists_placements_by_isrc_playlist_private_clean - name: expected_playlists_placements_by_isrc_playlist_public - name: expected_playlists_placements_by_participant_isrc_playlist_country_private - name: expected_playlists_placements_by_participant_isrc_playlist_private - name: expected_playlists_placements_by_participant_isrc_playlist_private_clean - name: expected_playlists_placements_by_participant_isrc_playlist_public - name: expected_playlists_placements_by_track_playlist_distributor_public - name: expected_playlists_state - name: expected_playlist_merged_to_playlist - name: historical_playlist_tracklists_by_market_dbt_seed - name: historical_playlist_tracklists_aggregated_dbt_seed - name: historical_playlist_tracklists_apple_by_market_dbt_seed - name: expected_historical_playlist_tracklists_by_market_dbt - name: expected_historical_playlist_tracklists_aggregated_dbt # v_view integration tests - name: expected_v_playlists_by_playlist - name: expected_v_historical_playlist_tracklists_aggregated - name: expected_v_historical_playlist_tracklists_by_market - name: expected_v_playlist_track_company_brand - name: expected_v_playlists_by_playlist_current_tracklist - name: expected_v_playlists_placements_by_playlist_private - name: expected_v_playlists_placements_by_playlist_public - name: expected_v_playlists_placements_by_playlist_country_private - name: expected_v_playlists_followers_by_playlist_date_spotify - name: expected_v_playlists_placements_by_isrc_playlist_public - name: expected_v_playlists_placements_by_isrc_playlist_private - name: expected_v_playlists_placements_by_isrc_playlist_private_clean - name: expected_v_playlists_placements_by_isrc_playlist_country_private - name: expected_v_playlists_placements_by_participant_isrc_playlist_public - name: expected_v_playlists_placements_by_participant_isrc_playlist_private - name: expected_v_playlists_placements_by_participant_isrc_playlist_private_clean - name: expected_v_playlists_placements_by_participant_isrc_playlist_country_private - name: expected_v_playlists_placements_by_track_playlist_distributor_public - name: expected_v_playlists_placements_by_track_playlist_distributor_public_only_freshest - name: expected_v_recent_playlists_placements_by_track_playlist_distributor - name: expected_v_recent_playlists_placements_by_track_playlist_distributor_only_freshest - name: expected_v_gsr_and_chartmetric_metadata - name: expected_v_playlist_metadata - name: expected_v_playlists_placement_events_by_isrc_playlist - name: expected_v_dim_editorial_playlist_top_non_editorial_playlist - name: primary_playlist_type_by_playlist - name: active_playlists_dbt_mock - name: playlist_curator_owner_overrides - name: l_spotify_playlist_sony - name: playlists_priority_placements_by_isrc_playlist_public - name: playlists_priority_placements_by_participant_isrc_playlist_public - name: playlists_non_priority_placements_by_participant_isrc_playlist_public - name: playlists_non_priority_placements_by_isrc_playlist_public - name: playlists_priority_placements_by_track_playlist_distributor_public - name: playlists_non_priority_placements_by_track_playlist_distributor_public - name: playlists_priority_placements_by_track_playlist_distributor_public_only_freshest - name: playlists_non_priority_placements_by_track_playlist_distributor_public_only_freshest - name: recent_playlists_priority_placements_by_track_playlist_distributor - name: recent_playlists_non_priority_placements_by_track_playlist_distributor - name: recent_playlists_priority_placements_by_track_playlist_distributor_only_freshest - name: recent_playlists_non_priority_placements_by_track_playlist_distributor_only_freshest # hourly placements - name: playlists_hourly_placements_by_isrc_playlist_public - name: playlists_hourly_placements_by_playlist_public - name: playlists_hourly_placements_by_playlist_private - name: playlists_hourly_placements_by_playlist_country_private - name: playlists_hourly_placements_by_participant_isrc_playlist_public - name: playlists_hourly_placements_by_participant_isrc_playlist_private - name: playlists_hourly_placements_by_participant_isrc_playlist_country_private - name: playlists_hourly_placements_by_track_playlist_distributor_public - name: playlists_hourly_placements_by_track_playlist_distributor_public_only_freshest - name: recent_playlists_hourly_placements_by_track_playlist_distributor - name: recent_playlists_hourly_placements_by_track_playlist_distributor_only_freshest - name: hourly_playlist_metadata - name: expected_hourly_playlist_metadata # priority placements by_playlist - name: playlists_priority_placements_by_playlist_private - name: playlists_priority_placements_by_playlist_country_private - name: expected_streams_by_playlist_country_feed_rollup_product_transfer - name: expected_streams_by_playlist_country_rollup_product_transfer - name: expected_streams_by_playlist_feed_rollup_product_transfer - name: expected_streams_by_playlist_rollup_product_transfer - name: expected_streams_by_track_country_feed_distributor_rollup_history_product_transfer - name: expected_streams_by_track_country_feed_distributor_rollup_recent_product_transfer - name: expected_streams_by_track_country_region_feed_distributor_rollup_product_transfer - name: expected_streams_by_track_feed_distributor_rollup_product_transfer - name: expected_streams_by_track_playlist_country_feed_distributor_rollup_history_product_transfer - name: expected_streams_by_track_playlist_country_feed_distributor_rollup_recent_product_transfer - name: expected_streams_completions_by_track_playlist_country_feed_distributor_rollup_history_product_transfer - name: expected_streams_completions_by_track_playlist_country_feed_distributor_rollup_recent_product_transfer - name: expected_streams_demographics_by_participant_feed_distributor_rollup_product_transfer - name: expected_streams_demographics_by_product_country_feed_distributor_rollup_product_transfer - name: expected_streams_demographics_by_product_feed_distributor_rollup_product_transfer - name: expected_streams_demographics_by_track_feed_distributor_rollup_product_transfer - name: expected_tiktok_by_isrc_product_country_rollup_product_transfer - name: expected_metrics_by_account_28_days_rollup_product_transfer - name: expected_metrics_by_account_country_feed_distributor_rollup_product_transfer - name: expected_metrics_by_account_track_country_feed_distributor_rollup_product_transfer - name: expected_metrics_by_isrc_country_feed_distributor_rollup_product_transfer - name: expected_metrics_by_multi_product_country_feed_distributor_rollup_history_product_transfer - name: expected_metrics_by_multi_product_country_feed_distributor_rollup_recent_product_transfer - name: expected_metrics_by_multi_product_feed_distributor_rollup_product_transfer - name: expected_metrics_by_participant_product_country_feed_distributor_rollup_product_transfer - name: expected_metrics_by_participant_track_28_days_rollup_product_transfer - name: expected_metrics_by_product_country_feed_distributor_rollup_product_transfer - name: expected_metrics_by_product_feed_distributor_rollup_product_transfer - name: expected_metrics_by_product_participant_country_feed_distributor_rollup_product_transfer - name: expected_metrics_by_product_participant_feed_distributor_rollup_product_transfer - name: expected_market_size_by_store_country_product_transfer - name: expected_metrics_by_track_country_creations_threshold_rollup_product_transfer - name: expected_metrics_by_track_country_feed_distributor_rollup_history_product_transfer - name: expected_metrics_by_track_country_feed_distributor_rollup_recent_product_transfer - name: expected_metrics_by_track_creations_threshold_rollup_product_transfer - name: expected_metrics_by_track_feed_distributor_rollup_product_transfer - name: expected_metrics_by_track_participant_country_feed_distributor_rollup_history_product_transfer - name: expected_metrics_by_track_participant_country_feed_distributor_rollup_recent_product_transfer - name: expected_metrics_by_track_participant_feed_distributor_rollup_product_transfer - name: expected_metrics_by_track_region_feed_distributor_rollup_history_product_transfer - name: expected_metrics_by_track_region_feed_distributor_rollup_recent_product_transfer - name: expected_metrics_ugc_by_video_asset_country_feed_distributor_rollup_history_product_transfer - name: expected_metrics_ugc_by_video_asset_country_feed_distributor_rollup_recent_product_transfer - name: expected_metrics_ugc_by_video_asset_feed_distributor_rollup_history_product_transfer - name: expected_metrics_ugc_by_video_asset_feed_distributor_rollup_recent_product_transfer # common source tables - name: apple_id_mapping - name: demographics_region_mapping_v2 - name: dim_algorithmic_playlists - name: dim_artist - name: dim_claim - name: dim_containertype - name: dim_country - name: dim_day - name: dim_feed - name: dim_genre - name: dim_label - name: dim_licensor - name: dim_playlist - name: dim_release - name: dim_release_history - name: dim_sourcetype - name: dim_subaccount - name: dim_track_clean_mv - name: dim_upper_profit_center - name: dim_user - name: dim_youtube_channel_names - name: dim_trafficsource - name: youtube_video_asset_type_mapping - name: sony_apple_id_mapping - name: awal_apple_id_mapping - name: staging_raw_apple_music_demographics - name: staging_raw_apple_music_container - name: staging_raw_apple_music_summary_streams - name: staging_raw_apple_music_streams - name: staging_raw_line_sex_age - name: staging_raw_spotify_aggregated_streams - name: staging_raw_spotify_v2 - name: aggregated_skips_and_saves - name: staging_raw_uma - name: staging_raw_youtube_asset_report - name: staging_raw_youtube_video_report - name: staging_raw_youtube_claim - name: staging_raw_youtube_claim_sme - name: staging_raw_soundcloud_streamlevelreport - name: staging_raw_soundcloud_trackinformation - name: staging_raw_soundcloud_customerdata - name: staging_raw_tiktok - name: staging_raw_vevo - name: orchard_track - name: orchard_product - name: global_participant - name: label_participant - name: public_participant - name: public_track - name: spotify_tracks - name: release_artist - name: release_artist_created_from_label_participant - name: product_has_source_artist_release_artist - name: product_includes_orchard_track - name: label_participant_participated_in_orchard_track - name: label_participant_participated_in_orchard_product - name: global_participant_merged_to_global_participant - name: global_participant_represents_label_participant - name: label_sound_recording - name: orchard_track_is_placement_of_label_sound_recording - name: global_sound_recording_represents_label_sound_recording - name: global_sound_recording - name: public_sound_recording - name: global_sound_recording_represents_public_sound_recording - name: global_participant_represents_public_participant - name: public_participant_participated_in_public_sound_recording - name: public_track_is_placement_of_public_sound_recording - name: vendor - name: subaccount - name: company_brand_belongs_to_parent_company - name: company_brand_has_label_vendor - name: company_brand - name: vendor_company_brand_parent_company - name: sme_germany_product_upper_profit_mapping - name: sony_product_master - name: vendor_company_brand_parent_company_service_tier_view - name: youtube_video # further db connections, used by point_of_sale and mappings - name: orchard_app_reporting_art_relations database: orchard_app_reporting_v2 schema: art_relations_prod_art_relations tables: - name: artist_info - name: distribution_format - name: distribution_format_media - name: distribution_format_media_format - name: genre - name: orchadmin_users - name: product_physical - name: releases - name: release_subgenre - name: subaccount - name: subgenre - name: track - name: vendor - name: youtube_channel - name: youtube_channel_upc - name: orchard_app_reporting_pricing database: orchard_app_reporting_v2 schema: prod_ows_pricing_pricing tables: - name: product_store_effective_price_code # chart metric tables # amazon - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: amazon - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: amazon_playlist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_amazon_playlist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_amazon_playlist_stat - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_amazon_playlist_history # deezer - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: deezer - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: deezer_playlist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_deezer_playlist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_deezer_playlist_stat - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_deezer_playlist_history # itunes - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: itunes - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: itunes_playlist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_itunes_playlist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_itunes_playlist_stat - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_itunes_playlist_history # spotify - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: spotify - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: spotify_playlist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_spotify_playlist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_spotify_playlist_stat - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_spotify_playlist_history # youtube - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: youtube - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: youtube_playlist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_youtube_playlist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_youtube_playlist_stat - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_youtube_playlist_history # chartmetric - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: cm_track - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: l_cm_track_cm_artist - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: tiktok - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: tiktok_video - name: chartmetric_raw_data database: DS_CHARTMETRIC schema: raw_data tables: - name: tiktok_top_videos_stat - name: chartmetric_shares database: CHARTMETRIC schema: shares tables: - name: l_spotify_playlist_sony