version: 2 sources: - name: intelligence_prod database: intelligence schema: prod tables: - name: accounting_aggregates - name: accounting_aggregates_blendtag - name: accounting_analyitcs_blend - name: accounting_analytics_blend - name: accounting_analytics_blend_v2 - name: adv_artist_join - name: adv_artist_revenue_metrics - name: adv_artist_revenue_metrics_blanco - name: adv_artist_top_country - name: adv_chartmetric_socials - name: adv_joined_table - name: adv_joined_table_blanco - name: analytics - name: analytics_alone - name: analytics_estimated_revenue_results - name: analytics_report_full - name: analytics_report_weekly_apple_ex_us - name: analytics_report_weekly_apple_us - name: analytics_report_weekly_spotify_ex_us - name: analytics_report_weekly_spotify_us - name: apg_apple_id - name: apg_apple_pitch_grid - name: apg_base - name: apg_bit_rate - name: apg_global_mktg_highlights - name: apg_local_mktg_highlights - name: apg_mkt_priority - name: apg_mktg_blurb - name: apple_544 - name: apple_544_mapping - name: apple_music_ingestion_time - name: artist_level_by_source_user_discovery - name: artist_level_user_discovery - name: avg_comments - name: avg_likes - name: avg_units_1st_rls_week_by_genre_daily - name: avg_units_by_genre_store_country_daily - name: avg_views - name: base_fact_analytics - name: bits_per_sample - name: blend_range_v2 - name: chart_ranking_heuristic - name: compilation_takedowns - name: current_week - name: current_week_apple_ex_us - name: current_week_apple_us - name: current_week_spotify_ex_us - name: current_week_spotify_us - name: daily_rollup - name: daily_spikes_uk - name: daily_spikes_us - name: daily_top_content - name: dim_editorial_playlist - name: dim_editorial_playlist_top_non_editorial_playlist - name: dim_publishing_income_type - name: distribution_format_proper_mapping - name: estimated_revenue_per_play_rate - name: estimated_revenue_results - name: estimated_revenue_results_apr19_label_ppr - name: estimated_revenue_results_aug19 - name: estimated_revenue_results_aug19_activity_ppr - name: estimated_revenue_results_aug19_label_ppr - name: estimated_revenue_results_aug19_label_ppr_historic_labels - name: estimated_revenue_results_jul19_label_ppr - name: estimated_revenue_results_jun19_label_ppr - name: estimated_revenue_results_may19_label_ppr - name: estimated_revenue_results_oct19_label_ppr - name: estimated_revenue_results_sep19_label_ppr - name: fa - name: fa_apple_ex_us - name: fa_apple_us - name: fa_spotify_ex_us - name: fa_spotify_us - name: fact_analytics_aggregated_err - name: fact_analytics_daily_rollup - name: fact_analytics_err - name: fact_analytics_monthly_rollup - name: fact_analytics_remaps_err - name: fact_analytics_tt_convert_err - name: fact_analytics_v2 - name: fact_analytics_v2__dbt_tmp - name: fact_analytics_weekly_rollup - name: fact_analytics_yearly_rollup - name: fact_conflict_snapshot - name: fact_sales_blend_v2 - name: fact_sales_err - name: featuring_artists_track_release - name: followers - name: genre_label_level_by_source_user_discovery - name: genre_label_level_user_discovery - name: genre_mapping_apple_pitch_grid - name: genre_streaming_by_day - name: genre_subaccount_level_by_source_user_discovery - name: genre_subaccount_level_user_discovery - name: gia_dim_artist - name: gia_dim_licensor - name: gia_fact_analytics - name: gia_global_impact_analytics - name: gracenote_album_edition - name: gracenote_album_edition_track - name: gracenote_album_master - name: gracenote_artist - name: gracenote_artist_alternate_name - name: gracenote_artist_name_variant - name: gracenote_descriptor_artist_type - name: gracenote_descriptor_era - name: gracenote_descriptor_genre - name: gracenote_descriptor_language - name: gracenote_descriptor_mood - name: gracenote_descriptor_origin - name: gracenote_descriptor_script - name: gracenote_descriptor_style - name: gracenote_descriptor_tempo - name: gracenote_recording - name: gracenote_recording_product_code - name: gracenote_song - name: has_accounting - name: historic_fact_sales - name: historic_fact_sales__dbt_tmp - name: ifpi_report_2018 - name: imprint_level_by_source_user_discovery - name: imprint_level_user_discovery - name: ingestion_time - name: instagram_followers - name: instagram_spike_stats - name: intelligence_spotify_source_of_stream - name: internal_conflicts - name: itunes_ingestion_time - name: itunes_language_validation - name: itunes_ticket_severity_mapping - name: knr_label_exclusions - name: label_level_by_source_user_discovery - name: label_level_user_discovery - name: label_listeners - name: label_listeners_by_artist - name: label_manager_territories - name: last_12_months_apple_ex_us - name: last_12_months_apple_us - name: last_12_months_spotify_ex_us - name: last_12_months_spotify_us - name: last_12months - name: last_full_week - name: last_full_week_apple_ex_us - name: last_full_week_apple_us - name: last_full_week_spotify_ex_us - name: last_full_week_spotify_us - name: last_week - name: last_week_apple_ex_us - name: last_week_apple_us - name: last_week_spotify_ex_us - name: last_week_spotify_us - name: listener_behavior_by_release_stray_kids - name: looker_1091_shared_access_labels - name: main_market_share - name: management_accounting_table - name: management_accounting_view - name: market_share - name: market_share_accounting_by_release_view - name: market_share_slas - name: median_units_by_genre_store_country_daily - name: metadata_simplified - name: most_recent_day - name: most_recent_day_apple_ex_us - name: most_recent_day_apple_us - name: most_recent_day_spotify_ex_us - name: most_recent_day_spotify_us - name: multiple_activity_dates_ingestion_time - name: orchard_pricing_by_release - name: performance_rights_historic_accounting - name: physical_accounting_all_sales - name: playlist_blacklist - name: playlist_completion_rate - name: playlistname_exclusions - name: pre_c_intelligence_spotify_source_of_stream - name: pre_d_intelligence_spotify_source_of_stream - name: product_physical_packaging_proper_mapping - name: project_level_by_source_user_discovery - name: project_level_user_discovery - name: rcl_deletions_changes - name: rcl_preorder_date_changes - name: rcl_release_change_log - name: rcl_sale_start_date_changes - name: rcl_track_ig_changes - name: rcl_track_ig_date_changes - name: release_2_1_artist_primary_all_tracks_not_listed_album_level - name: release_5_1_artist_listed_primary_and_featuring - name: release_5_1_featuring_in_primary_artist_field - name: release_5_2_artist_featuring_all_tracks_not_featuring_album - name: release_5_2_featuring_album_level_not_featuring_all_tracks - name: release_5_4_jazz_featuring_in_title_featured_artist - name: release_6_1_classical_main_performers_not_listed_primary - name: release_artists - name: release_compound_artist - name: release_content_validation_agg - name: release_delivery_history - name: release_level_by_source_user_discovery - name: release_level_user_discovery - name: restrictions_label_store - name: restrictions_label_substore - name: restrictions_label_territory - name: restrictions_release_store - name: restrictions_release_substore - name: restrictions_release_supply_chains - name: restrictions_release_territory - name: restrictions_subaccount_store - name: restrictions_subaccount_substore - name: restrictions_subaccount_territory - name: rf_aggregated_first_week_streams_data - name: rf_digital_forecast - name: rf_first_week_album_streams_by_store - name: rf_first_week_album_streams_total - name: rf_first_week_streams - name: rf_forecast - name: rf_input - name: rf_latest_release_info - name: rf_latest_release_streams - name: rf_physical_forecast - name: rf_releases_pre_forecasting - name: rf_releases_pre_forecasting_metadata - name: rf_releases_to_forecast - name: rf_spotify_singles - name: rf_store_tt_forecast - name: rf_streams_pivot - name: rsd_digital_marketing_projections_by_country - name: rsd_digital_store_highlights - name: rsd_distribution_format - name: rsd_global_mktg_highlights - name: rsd_mktg_blurb - name: rsd_mktg_driver - name: rsd_promo_link - name: rsd_release_schedule_dashboard - name: rsd_releases - name: rsd_subgenre - name: rsd_sync_highlights - name: social_spike_stats - name: som_livre_similar_listeners - name: spotify_followers - name: stg_dim_editorial_playlist_top_non_editorial_playlist - name: store_genre_subgenre_mappings - name: store_ppr - name: store_ppr_test - name: store_ppr_v2 - name: store_pricing_by_release - name: store_slas - name: storefront_links - name: streaming_totals_last_sales_week - name: streaming_totals_last_sales_week_isrc_level - name: streaming_totals_last_sales_week_release_level - name: streams_by_date - name: streams_by_date_country - name: subaccount_level_by_source_user_discovery - name: subaccount_level_user_discovery - name: summar_market_share - name: summary_market_share - name: territory_grouping - name: territory_grouping_v2 - name: test_pipenv - name: test_tag_exclude - name: top_artists - name: top_artists_for_listeners_of_21786 - name: top_artists_for_listeners_of_artist_1001889 - name: top_artists_for_listeners_of_artist_1347337 - name: top_artists_for_listeners_of_artist_1593256 - name: top_artists_for_listeners_of_artist_557298 - name: top_artists_for_listeners_of_artist_877436 - name: top_genres - name: top_genres_for_listeners_of_21786 - name: top_non_editorial_playlists - name: top_playlist_rankings - name: top_subgenres - name: top_subgenres_for_listeners_of_21786 - name: track_5_1_artist_listed_primary_and_featuring - name: track_5_1_artist_primary_track_level_featuring_release_level - name: track_5_1_featuring_artist_track_level_primary_release_level - name: track_5_1_featuring_in_primary_artist_field - name: track_5_4_jazz_featuring_in_title_featured_artist - name: track_artists - name: track_compound_artist - name: track_content_validation_agg - name: track_explicit_content - name: track_level_by_source_user_discovery - name: track_level_user_discovery - name: transaction_type_group - name: twitter_followers - name: us_states - name: vw_active_vendor_contract - name: vw_artist_identifer - name: vw_country_region_flatten - name: vw_deleted_labels - name: vw_deleted_releases - name: vw_performance_rights_delivery_history - name: vw_video_product_builder_qc - name: weekly_spikes_uk - name: weekly_spikes_us - name: youtube_claim_report - name: youtube_followers - name: yt_sound_recording_pv - name: yt_us_revenue_by_upc - name: yt_video_report_orchard_metadata