# Data Lineage & Dependencies Generated on: 2026-07-01 15:37:55 This document shows the relationships and dependencies between models, views, and data sources. ## Overview - **Total Models:** 219 - **Total Views:** 1013 - **Derived Views:** 280 - **Direct Table Views:** 733 ## Model Dependencies ### Models and Their Views #### Analytics_AWA - **Includes:** 10 views - **Views:** - `int_dbt_prod_agg_awa_model` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `facts_prod_dim_track` - `facts_prod_dim_artist` - `orch_app_ar_releases` - `orch_app_ar_country` - `orch_app_ar_genre` - `int_dbt_prod_awal_tier_groups` #### Analytics_Amazon - **Includes:** 9 views - **Views:** - `int_dbt_prod_agg_amazon_model` - `int_dbt_prod_stg_dim_playlist_amazon` - `orch_app_ar_releases` - `facts_prod_dim_track` - `orch_app_ar_genre` - `facts_prod_dim_label` - `orch_app_ar_country` - `facts_prod_dim_country` - `int_dbt_prod_awal_tier_groups` #### Analytics_Amazon_Rollup - **Includes:** 12 views - **Views:** - `int_dbt_prod_agg_amazon_monthly_rollup_user_aggregation` - `int_dbt_prod_agg_amazon_monthly_rollup` - `int_dbt_prod_agg_amazon_weekly_rollup` - `int_dbt_prod_agg_amazon_aggregated_18months` - `int_dbt_prod_stg_dim_playlist_amazon` - `orch_app_ar_releases` - `facts_prod_dim_track` - `orch_app_ar_genre` - `facts_prod_dim_label` - `orch_app_ar_country` - `facts_prod_dim_country` - `int_dbt_prod_awal_tier_groups` #### Analytics_Apple - **Includes:** 14 views - **Views:** - `int_dbt_prod_agg_apple_model` - `int_dbt_prod_stg_dim_playlist_apple` - `orch_app_ar_releases` - `facts_prod_dim_track` - `orch_app_ar_genre` - `facts_prod_dim_label` - `orch_app_ar_country` - `facts_prod_dim_country` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_subaccount` - `orch_app_ar_orchadmin_users` - `int_dbt_prod_summary_streams` - `orch_app_ar_vendor` - `orch_app_ar_vendor` #### Analytics_Apple_Rollup - **Includes:** 16 views - **Views:** - `int_dbt_prod_agg_apple_summary_18months` - `int_dbt_prod_agg_weekly_apple_summary` - `int_dbt_prod_agg_monthly_apple_summary` - `int_dbt_prod_stg_dim_playlist_apple` - `orch_app_ar_releases` - `facts_prod_dim_track` - `orch_app_ar_genre` - `facts_prod_dim_label` - `orch_app_ar_country` - `facts_prod_dim_country` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_subaccount` - `orch_app_ar_orchadmin_users` - `int_dbt_prod_summary_streams` - `orch_app_ar_vendor` - `orch_app_ar_vendor` #### Analytics_Deezer - **Includes:** 10 views - **Views:** - `int_dbt_prod_agg_deezer_model` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `facts_prod_dim_track` - `facts_prod_dim_artist` - `orch_app_ar_releases` - `orch_app_ar_country` - `orch_app_ar_genre` - `int_dbt_prod_awal_tier_groups` #### Analytics_Line - **Includes:** 10 views - **Views:** - `int_dbt_prod_agg_line_model` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `facts_prod_dim_track` - `facts_prod_dim_artist` - `orch_app_ar_releases` - `orch_app_ar_country` - `orch_app_ar_genre` #### Analytics_Netease - **Includes:** 9 views - **Views:** - `int_dbt_prod_agg_netease_model` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_vendor` - `orch_app_ar_orchadmin_users` - `orch_app_ar_releases` - `orch_app_ar_genre` - `orch_app_ar_release_subgenre` - `orch_app_ar_subgenre` - `orch_app_ar_country` #### Analytics_Pandora - **Includes:** 10 views - **Views:** - `int_dbt_prod_agg_pandora_model` - `facts_prod_dim_playlist` - `orch_app_ar_releases` - `facts_prod_dim_track` - `orch_app_ar_genre` - `facts_prod_dim_label` - `orch_app_ar_country` - `facts_prod_dim_country` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_subaccount` #### Analytics_Snapchat - **Includes:** 2 views - **Views:** - `int_dbt_prod_agg_snapchat_model` - `int_dbt_prod_awal_tier_groups` #### Analytics_Soundcloud - **Includes:** 10 views - **Views:** - `int_dbt_prod_agg_soundcloud_model` - `facts_prod_dim_playlist` - `orch_app_ar_releases` - `facts_prod_dim_track` - `orch_app_ar_genre` - `facts_prod_dim_label` - `orch_app_ar_country` - `facts_prod_dim_country` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_subaccount` #### Analytics_Spotify - **Includes:** 21 views - **Views:** - `int_dbt_prod_agg_spotify_model` - `int_dbt_prod_stg_dim_playlist_spotify` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `facts_prod_dim_track` - `facts_prod_dim_artist` - `orch_app_ar_releases` - `orch_app_ar_country` - `orch_app_ar_genre` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_vendor` - `orch_app_ar_owner` - `orch_app_prod_ddex_ingester_upc_remap` - `orch_app_ar_orchadmin_users` - `orch_app_ar_subaccount` - `int_dbt_prod_spotify_track_audio_features` - `int_dbt_prod_playlist_return_rate_last_6_month_avg` - `int_dbt_prod_spotify_playlist_downstream_impact_6_month_avg` - `int_dbt_prod_spotify_playlist_post_discovery_streaming_6_month_avg` - `playlist_metrics/spotify_playlist_lean_fwd_lean_back_categorization` #### Analytics_Spotify_Rollup - **Includes:** 23 views - **Views:** - `int_dbt_prod_agg_spotify_model_18months` - `int_dbt_prod_agg_weekly_rollup_spotify_model` - `int_dbt_prod_agg_monthly_spotify_model` - `int_dbt_prod_stg_dim_playlist_spotify` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `facts_prod_dim_track` - `facts_prod_dim_artist` - `orch_app_ar_releases` - `orch_app_ar_country` - `orch_app_ar_genre` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_vendor` - `orch_app_ar_owner` - `orch_app_prod_ddex_ingester_upc_remap` - `orch_app_ar_orchadmin_users` - `orch_app_ar_subaccount` - `int_dbt_prod_spotify_track_audio_features` - `int_dbt_prod_playlist_return_rate_last_6_month_avg` - `int_dbt_prod_spotify_playlist_downstream_impact_6_month_avg` - `int_dbt_prod_spotify_playlist_post_discovery_streaming_6_month_avg` - `playlist_metrics/spotify_playlist_lean_fwd_lean_back_categorization` #### Analytics_Tencent - **Includes:** 9 views - **Views:** - `int_dbt_prod_agg_tencent_model` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_vendor` - `orch_app_ar_orchadmin_users` - `orch_app_ar_releases` - `orch_app_ar_genre` - `orch_app_ar_release_subgenre` - `orch_app_ar_subgenre` - `orch_app_ar_country` #### Analytics_Top_Cities_dataset - **Includes:** 1 views - **Views:** - `int_dbt_prod_top_cities_dataset` #### Analytics_UMA - **Includes:** 8 views - **Views:** - `int_dbt_prod_agg_uma_model` - `facts_prod_dim_country` - `orch_app_ar_releases` - `facts_prod_dim_track` - `orch_app_ar_genre` - `facts_prod_dim_label` - `orch_app_ar_country` - `int_dbt_prod_awal_tier_groups` #### Analytics_Use_Case_Models - **Includes:** 25 views - **Views:** - `int_dbt_prod_summary_streams` - `facts_prod_dim_playlist` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `facts_prod_dim_track` - `facts_prod_dim_artist` - `orch_app_ar_releases` - `orch_app_ar_country` - `orch_app_ar_genre` - `metadata_simplified` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_vendor` - `orch_app_ar_subaccount` - `orch_app_ar_orchadmin_users` - `orch_app_ar_release_subgenre` - `orch_app_ar_subgenre` - `orch_app_ar_product_type` - `orch_app_ar_mkt_priority` - `dt_flatten_marketing_info` - `dt_flatten_country_region` - `orch_app_ar_track` - `orch_app_ar_language` - `int_dbt_prod_product_manager_mapping_union` - `int_prod_vw_deleted_releases.view` #### Analytics_Wnyk - **Includes:** 14 views - **Views:** - `int_dbt_prod_agg_wynk_model` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `facts_prod_dim_track` - `facts_prod_dim_artist` - `orch_app_ar_releases` - `orch_app_ar_country` - `orch_app_ar_genre` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_release_subgenre` - `orch_app_ar_subgenre` - `orch_app_ar_language` - `orch_app_ar_artist_info` #### Analytics_Youtube - **Includes:** 4 views - **Views:** - `int_dbt_prod_agg_daily_youtube_model` - `facts_prod_dim_transactiontype` - `int_prod_transaction_type_group` - `orch_app_ar_artist_info` #### Apple_Fraudulent_Streaming - **Includes:** 11 views - **Views:** - `int_dbt_prod_apple_in_review` - `orch_app_ar_releases` - `facts_prod_dim_release` - `facts_prod_dim_label` - `orch_app_ar_country` - `facts_prod_dim_country` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_track` - `facts_prod_dim_artist` - `int_dbt_prod_apple_excluded_streams` - `orch_app_ar_subaccount` #### Apple_Podcasting - **Includes:** 1 views - **Views:** - `apple_podcasts/*` #### Approved_Products_Revenue - **Includes:** 1 views - **Views:** - `int_dbt_prod_approved_products_revenue` #### Discovery_mode - **Includes:** 6 views - **Views:** - `int_dev_nsuzara_awal_discovery` - `int_dev_nsuzara_awaldata` - `int_dev_awalspotify` - `int_dev_awalspotify_awaldiscovery_v04ebba` - `facts_prod_dim_playlist` - `int_dev_awalspotify_vwbelieve` #### Download_Stores_Models - **Includes:** 4 views - **Views:** - `int_dbt_prod_agg_daily_beatport_download_model` - `int_dbt_prod_agg_daily_amazon_download_model` - `int_dbt_prod_agg_daily_apple_download_model` - `int_dbt_prod_daily_summary_downloads` #### FCT_ORCHARD_INSIGHTS_TOP_STREAMS_METRICS_TIKTOK_BY_LABEL - **Includes:** 6 views - **Views:** - `int_dbt_prod_fct_orchard_insights_top_streams_metrics_tiktok_by_label` - `facts_prod_dim_label` - `facts_prod_dim_track` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_release` - `facts_prod_dim_artist` #### Insta_Reels - **Includes:** 12 views - **Views:** - `facts_prod_staging_raw_insta_reels_views` - `facts_prod_staging_raw_insta_reels_creations` - `orch_app_ar_track` - `orch_app_ar_releases` - `facts_prod_dim_track` - `orch_app_ar_artist_info` - `orch_app_ar_vendor` - `orch_app_ar_orchadmin_users` - `facts_prod_dim_country` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_subaccount` - `dt_mising_upc_track_mapping` #### Jorga_Smith_Analysis - **Includes:** 1 views - **Views:** - `*` #### Label_Review_Spreadsheet - **Includes:** 3 views - **Views:** - `int_dbt_prod_label_performance_spreadsheet` - `facts_prod_dim_label` - `orch_app_ar_country` #### Last_7_days_streaming - **Includes:** 1 views - **Views:** - `*` #### MD5_Changes - **Includes:** 5 views - **Views:** - `orch_app_dd_asset` - `orch_app_dd_asset_location` - `orch_app_dd_asset_location_detail` - `orch_app_ar_track` - `orch_app_ar_releases` #### MRC - **Includes:** 4 views - **Views:** - `facts_prod_staging_raw_mrc` - `facts_prod_staging_raw_mrc_artist_mapping` - `cm_social_current` - `cm_spotify_change` #### Riaa_Certification_Model - **Includes:** 2 views - **Views:** - `int_dbt_prod_riaa_certification` - `int_dbt_prod_awal_tier_groups` #### Sales_Performance_Metrics_Spotify - **Includes:** 2 views - **Views:** - `int_dbt_prod_sales_performance_metrics` - `dt_local_non_local_labels` #### Snowflake_Monitoring - **Includes:** 1 views - **Views:** - `*` #### Spotify_Charts - **Includes:** 26 views - **Views:** - `facts_prod_spotify_chart` - `facts_prod_spotify_track_artist` - `facts_prod_spotify_track` - `facts_prod_spotify_artist` - `facts_prod_spotify_label` - `cm_raw_data_spotify` - `cm_store_carveouts` - `cm_territory_carevouts` - `facts_prod_dim_country` - `facts_prod_orchard_track` - `facts_prod_orchard_product` - `int_prod_vw_restrictions_release_store` - `int_prod_vw_restrictions_release_territory` - `orch_app_ar_track` - `orch_app_ar_releases` - `facts_prod_dim_isrc` - `facts_prod_dim_label` - `facts_prod_dim_brand` - `orch_app_ar_artist_info` - `orch_app_ar_distribution_format_media` - `orch_app_ar_distribution_format` - `facts_prod_streams_by_country_feed_distributor_rollup_dbt` - `orch_app_ar_orchadmin_users` - `orch_app_ar_vendor` - `cm_raw_data_spotify_album` - `facts_prod_dim_release` #### Spotify_Monthly_Fraudulent_Streaming - **Includes:** 14 views - **Views:** - `int_dbt_prod_spotify_monthly_fraudulent_streaming` - `orch_app_ar_releases` - `facts_prod_dim_release` - `facts_prod_dim_label` - `orch_app_ar_country` - `facts_prod_dim_country` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_track` - `facts_prod_dim_artist` - `int_dbt_prod_apple_excluded_streams` - `int_dbt_prod_spotify_fraudulent_fact_sales_combined` - `orch_app_ar_vendor_contract` - `orch_app_ar_orchadmin_users` - `orch_app_ar_artist_info` #### Spotify_Weekly_Market_Share - **Includes:** 4 views - **Views:** - `spotify_market_share_week_ending` - `facts_prod_dim_country` - `/**/*` - `my_dashboard.dashboard.lookml` #### Tier_3_Label_Analysis - **Includes:** 2 views - **Views:** - `int_dbt_prod_tier_3_label_analysis` - `dev_engineering_ccapalbo_label_manager_territory_map` #### TikTok_Fraudulent_Streaming - **Includes:** 11 views - **Views:** - `int_dbt_prod_tiktok_fraud_model` - `facts_prod_dim_country` - `facts_prod_dim_label` - `orch_app_ar_country` - `orch_app_ar_vendor` - `orch_app_ar_releases` - `orch_app_ar_track` - `orch_app_ar_genre` - `orch_app_ar_orchadmin_users.view` - `int_dbt_prod_product_manager_mapping_union.view` - `int_dbt_prod_awal_tier_groups` #### US_ARTIST_RANKING - **Includes:** 3 views - **Views:** - `US_ARTIST_RANKING` - `/**/*` - `my_dashboard.dashboard.lookml` #### Weekly_Streaming_Overall_Performance - **Includes:** 6 views - **Views:** - `int_dbt_prod_WoW_Streams_by_DSP` - `int_dbt_prod_Tier_Breakdown` - `int_dbt_prod_Source_Breakdown` - `int_dbt_prod_ENGAGEDVSLEANBACKBREAKDOWN` - `int_dbt_prod_Weekly_no_of_New_Releases` - `int_dbt_prod_Sub_Genres` #### YouTube_Analytics_API - **Includes:** 3 views - **Views:** - `int_dbt_prod_youtube_summary_streams_daily` - `facts_prod_youtube_video` - `facts_prod_dim_youtube_channel_names` #### abacus - **Includes:** 1 views - **Views:** - `*` #### accounting_analytics_blend - **Includes:** 1 views - **Views:** - `*` #### accounting_reports - **Includes:** 1 views - **Views:** - `*` #### ad_spend - **Includes:** 1 views - **Views:** - `*` #### advertising_campaigns - **Includes:** 1 views - **Views:** - `advertising_campaigns` #### advertising_monthly_activity - **Includes:** 1 views - **Views:** - `advertising_monthly_activity` #### advertising_requests - **Includes:** 1 views - **Views:** - `advertising_requests` #### all_signed_labels - **Includes:** 2 views - **Views:** - `all_signed_labels/*` - `/int_prod_vw_restrictions_label_store` #### amazon_sos - **Includes:** 1 views - **Views:** - `facts_prod_staging_raw_amazon_unlimited` #### amprofon_certification - **Includes:** 2 views - **Views:** - `dt_amprofon_certification` - `dt_amprofon_certification_v2` #### anomaly_testing - **Includes:** 7 views - **Views:** - `market_share_test` - `market_share_fact_sales_test` - `amazon_anomaly_testing` - `apple_anomaly_testing` - `spotify_anomaly_testing` - `deezer_anomaly_testing` - `line_anomaly_testing` #### apple_container_report - **Includes:** 1 views - **Views:** - `*` #### apple_music_demographic - **Includes:** 5 views - **Views:** - `int_dbt_prod_apple_music_demographic` - `int_dbt_prod_agg_apple_model` - `facts_prod_dim_label` - `/**/*` - `my_dashboard.dashboard.lookml` #### apple_music_pitch_grid - **Includes:** 10 views - **Views:** - `dt_apple_music_pitch_grid` - `dt_deliverable_from_release` - `dt_marketing_change_log` - `int_prod_vw_restrictions_release_substore` - `int_prod_vw_restrictions_release_territory` - `int_prod_apg_apple_pitch_grid` - `dt_flatten_marketing_info` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_focus_track` - `int_dbt_prod_apple_music_pitch_grid_specialist_genres` #### aria_streaming_score - **Includes:** 1 views - **Views:** - `*` #### artist_marketshare - **Includes:** 1 views - **Views:** - `int_dbt_prod_artist_marketshare` #### artist_similarity - **Includes:** 1 views - **Views:** - `*` #### artist_store_identifier - **Includes:** 3 views - **Views:** - `int_prod_vw_artist_identifier` - `orch_app_ar_artist_identifier` - `orch_app_ar_releases` #### artist_trends_and_demographics - **Includes:** 3 views - **Views:** - `int_dbt_prod_artist_demographics` - `int_dbt_prod_artist_streaming_trends` - `int_dbt_prod_youtube_partnered_channels` #### audience_segmentation - **Includes:** 3 views - **Views:** - `listener_segmentation/spotify_engagement_groups_combined_with_user_info` - `listener_segmentation/amazon_engagement_groups_combined` - `/facts_prod_dim_country` #### audio_features - **Includes:** 27 views - **Views:** - `int_dbt_prod_spotify_track_audio_features` - `facts_prod_dim_track` - `facts_prod_dim_release` - `facts_prod_dim_label` - `facts_prod_dim_artist` - `facts_prod_dim_genre` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_releases` - `dt_audio_features_track_similarity` - `dt_track_audio_feature_comparison` - `int_dbt_prod_spotify_editorial_playlist_position_log` - `dt_track_playlist_audio_feature_comparison` - `dt_audio_features_playlist_similarity` - `dt_playlist_track_fit` - `dt_playlist_audio_features_upper_x_lower_bounds` - `int_dbt_prod_spotify_playlist_country` - `facts_prod_dim_country` - `int_dbt_prod_spotify_playlist_followers` - `int_dbt_prod_spotify_playlist_type` - `int_dbt_prod_spotify_playlist_top_streaming_country` - `dt_track_playlist_audio_feature_comparison_2stddev` - `dt_playlist_track_fit_v2_2stddev` - `dt_playlist_genre` - `int_dbt_prod_playlist_model_spotify_rollup_1_year_editrorial_orchard` - `int_dbt_prod_spotify_editorial_playlist_legacy_playlist_metric` - `int_dbt_prod_spotify_editorial_playlist_update_groups` - `int_dbt_prod_spotify_editorial_playlist_metric_rollup` #### awal_toggle - **Includes:** 1 views - **Views:** - `int_dbt_prod_awal_tier_groups` #### balance_models - **Includes:** 2 views - **Views:** - `dt_outstanding_balances_2` - `dt_advances_2` #### bi_tools - **Includes:** 1 views - **Views:** - `dt_new_signing_revenue_estimate_calculator` #### bits_per_sample - **Includes:** 1 views - **Views:** - `*` #### capif_certification - **Includes:** 2 views - **Views:** - `dt_capif_certification` - `int_dbt_prod_awal_tier_groups` #### certification_models - **Includes:** 12 views - **Views:** - `int_dbt_prod_promusicae_track_cert` - `int_dbt_prod_promusicae_album_cert` - `int_dbt_prod_promusicae_brazil_cert` - `int_dbt_prod_amprofon_track_cert` - `int_dbt_prod_amprofon_album_cert` - `int_dbt_prod_aria_album_cert` - `int_dbt_prod_aria_track_cert` - `int_dbt_prod_aria_album_cert_accounting` - `int_dbt_prod_aria_track_cert_accounting` - `int_dbt_prod_riaa_track_cert` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_riaa_album_cert` #### chart_metric_A&R - **Includes:** 2 views - **Views:** - `*` - `*` #### chart_metric_music - **Includes:** 1 views - **Views:** - `*` #### chart_metric_playlist - **Includes:** 1 views - **Views:** - `*` #### chart_metric_social - **Includes:** 1 views - **Views:** - `*` #### chartable_podcasts - **Includes:** 1 views - **Views:** - `*` #### chartmetric_charts - **Includes:** 1 views - **Views:** - `facts_prod_chartmetric_charts` #### chartmetric_socials - **Includes:** 1 views - **Views:** - `facts_prod_chartmetric_socials` #### chartmetric_socials_backfill - **Includes:** 1 views - **Views:** - `facts_prod_cm_url_backfill` #### cherry_pick_report - **Includes:** 4 views - **Views:** - `int_dbt_prod_cherry_pick_report` - `facts_prod_dim_store` - `orch_app_dd_customer_master_master` - `orch_app_ar_releases` #### compilation_takedowns - **Includes:** 1 views - **Views:** - `*` #### conflict_manager_statistics - **Includes:** 2 views - **Views:** - `facts_prod_fact_conflict` - `ows_conflict_manager_prod_action` #### contact_created_date - **Includes:** 2 views - **Views:** - `contact_created_date` - `int_prod_vw_active_vendor_contract` #### content_validation_itunes_apple - **Includes:** 1 views - **Views:** - `*` #### content_validation_itunes_apple_v2 - **Includes:** 1 views - **Views:** - `*` #### core_accounting - **Includes:** 2 views - **Views:** - `*` - `int_dbt_prod_youtube_partnered_channels` #### core_analytics - **Includes:** 1 views - **Views:** - `*` #### core_analytics_v2 - **Includes:** 1 views - **Views:** - `*` #### core_metadata - **Includes:** 7 views - **Views:** - `*` - `int_dbt_prod_youtube_partnered_channels` - `dt_subaccount_contact` - `cm_raw_data_spotify` - `spotify_artist_id_all_contributors` - `orch_app_ar_bulk_session` - `spotify_watchlist_contributors` #### daily_spiking - **Includes:** 1 views - **Views:** - `*` #### daily_top_content - **Includes:** 1 views - **Views:** - `*` #### dbt_custom_looker_datasets - **Includes:** 25 views - **Views:** - `int_dbt_prod_accounting_last_12_months_activity_date` - `int_prod_territory_grouping` - `int_dbt_prod_accounting_last_24_months_activity_date_track_level` - `int_dbt_prod_spatial_audio_delivery_history_search` - `int_dbt_prod_per_play_rate` - `int_dbt_prod_digital_bulk_template` - `tsz_custom` - `int_dbt_prod_completion_rate_track_level_monthly` - `int_dbt_prod_artist_by_territory_accounting` - `int_dbt_prod_track_level_accounting` - `facts_prod_dim_release` - `facts_prod_dim_artist` - `int_dbt_prod_full_track_metadata_report_delivery_history` - `orch_app_ar_track` - `int_dbt_prod_changes_by_country` - `int_dbt_prod_tracks_generating_1000_streams` - `int_dbt_prod_global_chart_tracking` - `int_dbt_prod_anuel_aa_toptracks_monthly` - `int_dbt_prod_top_artists_monthly` - `int_dbt_prod_top_tracks_monthly` - `int_dbt_prod_first_access_analytics_reporting` - `int_dbt_prod_youtube_spike_report` - `int_dbt_prod_changes_by_source` - `top_content_daily_editorial_streams` - `orch_app_ar_releases` #### dbt_ifpi_models - **Includes:** 1 views - **Views:** - `int_dbt_prod_ifpi_country_label_level_accounting` #### dbt_monitoring - **Includes:** 2 views - **Views:** - `*` - `elementary_model_job_monitoring_v1` #### dbt_playlists - **Includes:** 27 views - **Views:** - `int_dbt_prod_playlist_model_spotify` - `int_dbt_prod_playlist_model_amazon` - `int_dbt_prod_playlist_model_soundcloud` - `int_dbt_prod_playlist_model_apple` - `int_dbt_prod_playlist_model_pandora` - `int_dbt_prod_playlist_model_joint` - `orch_app_ar_vendor` - `orch_app_ar_releases` - `orch_app_ar_genre` - `orch_app_ar_country` - `orch_app_ar_subgenre` - `orch_app_ar_release_subgenre` - `facts_prod_dim_release` - `facts_prod_dim_track` - `facts_prod_dim_artist` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_playlist` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_product_manager_mapping_union` - `orch_app_ar_subaccount` - `int_dbt_prod_spotify_track_audio_features` - `orch_app_ar_artist_info` - `int_dbt_prod_playlist_return_rate_last_6_month_avg` - `int_dbt_prod_spotify_playlist_downstream_impact_6_month_avg` - `int_dbt_prod_spotify_playlist_post_discovery_streaming_6_month_avg` - `playlist_metrics/spotify_playlist_lean_fwd_lean_back_categorization` #### dbt_release_schedule_dashboard_v2 - **Includes:** 17 views - **Views:** - `int_dbt_prod_rsd_v2` - `orch_app_ar_artist_info` - `cm_orchard_join` - `cm_raw_data_spotify_artist` - `int_dbt_prod_cm_spotify_artist_stat_clean` - `int_dbt_prod_awal_tier_groups` - `dt_agg_restrictions_release_territory` - `dt_agg_restrictions_release_store` - `orch_app_ar_orchadmin_users` - `dbt_prod_pitch_info_extraction` - `int_dbt_prod_stg_cm_social_followers_clean` - `orch_app_ar_focus_track` - `orch_app_ar_track` - `dt_bits_per_sample` - `int_dbt_prod_chartmetric_social_stats` - `orch_app_ar_track_instant_grat` - `int_prod_rcl_track_ig_changes` #### dbt_trending_tiktok - **Includes:** 15 views - **Views:** - `int_dbt_prod_rolling_weekly_tiktok_trending_creations` - `int_dbt_prod_tiktok_trending_tracks` - `int_dbt_prod_rolling_weekly_tiktok_trending_creations_3_weeks` - `int_dbt_prod_rolling_weekly_tiktok_trending_creations_5_weeks` - `int_dbt_prod_rolling_weekly_tiktok_trending_video_views` - `int_dbt_prod_rolling_weekly_tiktok_trending_video_views_3_weeks` - `int_dbt_prod_rolling_weekly_tiktok_trending_video_views_5_weeks` - `facts_prod_dim_country` - `orch_app_ar_vendor` - `orch_app_ar_releases` - `orch_app_ar_genre` - `orch_app_ar_orchadmin_users.view` - `int_dbt_prod_product_manager_mapping_union.view` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_weekly_trending_genres_tiktok` #### dbt_trending_tracks - **Includes:** 37 views - **Views:** - `int_dbt_prod_weekly_trending_tracks_uk_spotify` - `int_dbt_prod_weekly_trending_tracks_uk_spotify_collection` - `int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist` - `int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd` - `int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail` - `int_dbt_prod_spotify_3rd_party_playlist_spt_last_week` - `int_dbt_prod_weekly_trending_tracks_amazon` - `int_dbt_prod_weekly_trending_tracks_amazon_collection` - `orch_app_ar_vendor` - `orch_app_ar_releases` - `orch_app_ar_genre` - `orch_app_ar_country` - `int_dbt_prod_weekly_trending_tracks_amazon_lean_fwd` - `int_dbt_prod_weekly_trending_tracks_amazon_user_playlist` - `int_dbt_prod_weekly_trending_tracks_amazon_long_tail` - `int_dbt_prod_weekly_trending_tracks_apple` - `int_dbt_prod_weekly_trending_tracks_apple_library_streams` - `int_dbt_prod_weekly_trending_tracks_apple_long_tail` - `int_dbt_prod_weekly_trending_tracks_apple_search_streams` - `int_dbt_prod_weekly_trending_tracks_apple_voice_streams` - `int_dbt_prod_weekly_trending_tracks_apple_discovery_streams` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_weekly_trending_tracks_spotify_continent` - `int_dbt_prod_weekly_trending_tracks_combined_tiktok` - `facts_prod_dim_track` - `facts_prod_dim_release` - `facts_prod_dim_artist` - `int_dbt_prod_weekly_trending_genres_spotify` - `int_dbt_prod_weekly_trending_tracks_awa` - `int_dbt_prod_weekly_trending_tracks_deezer` - `int_dbt_prod_weekly_trending_tracks_line` - `int_dbt_prod_weekly_trending_tracks_pandora` - `int_dbt_prod_weekly_trending_tracks_soundcloud` - `orch_app_ar_release_subgenre` - `orch_app_ar_subgenre` - `orch_app_ar_track` - `orch_app_ar_orchadmin_users` #### deezer_fraud - **Includes:** 1 views - **Views:** - `int_dbt_deezer_fraud_report` #### dim_lookups - **Includes:** 1 views - **Views:** - `*` #### direct_delivery - **Includes:** 1 views - **Views:** - `*` #### dt_awa_units_by_day - **Includes:** 1 views - **Views:** - `*` #### dt_blacklist_words - **Includes:** 1 views - **Views:** - `*` #### dt_chargeback_reconciliation - **Includes:** 1 views - **Views:** - `*` #### dt_fact_sales_market_share_brazil - **Includes:** 1 views - **Views:** - `dt_fact_sales_market_share_brazil` #### dt_label_balances - **Includes:** 14 views - **Views:** - `facts_prod_vw_workstation_summary` - `facts_prod_dim_period` - `dt_label_balances` - `orch_app_ar_vendor` - `orch_app_ar_owner` - `orch_app_ar_orchadmin_users` - `currency_exchange_rates` - `orch_app_ar_currencies` - `orch_app_ar_country` - `dt_finance_advance_recouped_balances` - `vendor_contract_snowflake_original` - `dt_outstanding_bal_opening_bal` - `orch_app_ar_vendor_closers` - `int_dbt_prod_awal_tier_groups` #### dt_playlisting_by_track - **Includes:** 5 views - **Views:** - `dt_playlisting_by_track` - `facts_prod_dim_isrc` - `orch_app_ar_vendor` - `orch_app_ar_artist_info` - `facts_prod_dim_track` #### dt_soundcloud_units_by_day - **Includes:** 1 views - **Views:** - `*` #### etl_monitor_accounting - **Includes:** 1 views - **Views:** - `*` #### facebook_urls - **Includes:** 1 views - **Views:** - `*` #### feature_controls - **Includes:** 1 views - **Views:** - `*` #### finance_export_uk - **Includes:** 2 views - **Views:** - `dt_finance_export_uk` - `*` #### finance_label_advances_balances - **Includes:** 3 views - **Views:** - `*` - `.*view.lkml` - `my_dashboard.dashboard.lookml` #### financial_reports - **Includes:** 2 views - **Views:** - `apple_financial_reports/*` - `youtube_financial_reports/*` #### genre_benchmarking - **Includes:** 1 views - **Views:** - `*` #### genre_mappings - **Includes:** 1 views - **Views:** - `*` #### global_certification - **Includes:** 4 views - **Views:** - `dt_global_certification` - `dt_global_certifications_by_country` - `dt_global_track_certifications_by_country` - `facts_prod_dim_transactiontype` #### holiday_trending_report - **Includes:** 2 views - **Views:** - `holiday_trending_report` - `orch_app_ar_releases` #### instagram_spike_stats - **Includes:** 1 views - **Views:** - `*` #### instagram_statistics - **Includes:** 1 views - **Views:** - `*` #### invalid_references - **Includes:** 1 views - **Views:** - `*` #### invalid_track_writer - **Includes:** 2 views - **Views:** - `dt_invalid_track_writer` - `dt_deliverable_from_release` #### itunes_hides - **Includes:** 2 views - **Views:** - `*` - `int_prod_vw_active_vendor_contract` #### itunes_tickets - **Includes:** 2 views - **Views:** - `*` - `/dt_first_approver` #### kemado_weekly_reports - **Includes:** 2 views - **Views:** - `int_dbt_prod_kemado_streams_last_18_months_releases` - `int_dbt_prod_kemado_all_time_streams` #### label_contracts - **Includes:** 1 views - **Views:** - `*` #### label_level_contribution_to_change - **Includes:** 11 views - **Views:** - `label_contribution_to_change/label_level_contribution_to_change` - `label_contribution_to_change/label_country_level_contribution_to_change` - `label_contribution_to_change/label_artist_level_contribution_to_change` - `label_contribution_to_change/label_store_level_contribution_to_change` - `label_contribution_to_change/label_source_level_contribution_to_change` - `label_contribution_to_change/label_release_level_contribution_to_change` - `label_contribution_to_change/label_track_level_contribution_to_change` - `/facts_prod_dim_release` - `/facts_prod_dim_artist` - `/orch_app_ar_vendor` - `/orch_app_ar_orchadmin_users` #### label_manager_control_panel - **Includes:** 12 views - **Views:** - `int_dbt_prod_lmcp_upcoming_new_releases` - `int_dbt_prod_lmcp_fact_analytics_last_3_weeks` - `int_dbt_prod_lmcp_lmcp_active_releases` - `int_dbt_prod_lmcp_assigned_labels` - `int_dbt_prod_lmcp_lm_name` - `int_dbt_prod_lmcp_new_releases_in_label_processing` - `int_dbt_prod_lmcp_shazam_activity` - `int_dbt_prod_lmcp_tiktok_top_tracks` - `int_dbt_prod_lmcp_top_labels` - `int_dbt_prod_lmcp_top_overall_tracks` - `int_dbt_prod_lmcp_top_playlists_radio` - `int_dbt_prod_lmcp_top_overall_releases` #### label_manager_insights - **Includes:** 1 views - **Views:** - `*` #### label_manager_insights_temp - **Includes:** 1 views - **Views:** - `dt_label_manager_insights_temp` #### label_manager_territory_map - **Includes:** 1 views - **Views:** - `dev_engineering_ccapalbo_label_manager_territory_map` #### label_offering - **Includes:** 1 views - **Views:** - `label_offering` #### label_streaming_anomalies - **Includes:** 6 views - **Views:** - `label_streaming_anomalies/*` - `/facts_prod_dim_release` - `/facts_prod_dim_track` - `/facts_prod_dim_artist` - `/orch_app_ar_vendor` - `/orch_app_ar_orchadmin_users` #### listeners_by_stream_count - **Includes:** 1 views - **Views:** - `dt_listeners_by_stream_count` #### looker_history_monitoring - **Includes:** 1 views - **Views:** - `looker_history_monitoring/*` #### luminate_global_reports - **Includes:** 3 views - **Views:** - `int_dbt_prod_luminate_global_artist` - `int_dbt_prod_luminate_global_song` - `int_dbt_prod_luminate_global_isrc` #### market_share_temp - **Includes:** 10 views - **Views:** - `*` - `dt_fact_sales_market_share` - `facts_prod_dim_store` - `facts_prod_dim_label` - `int_dbt_prod_awal_tier_groups` - `dt_fact_sales_market_share_artist_level` - `facts_prod_dim_store` - `facts_prod_dim_label` - `int_dbt_prod_awal_tier_groups` - `dt_market_share_change` #### marketing_change_log - **Includes:** 4 views - **Views:** - `dt_marketing_change_log` - `dt_deliverable_from_release` - `int_prod_vw_restrictions_release_store` - `*` #### master_calendar - **Includes:** 1 views - **Views:** - `*` #### master_calendar_sme - **Includes:** 1 views - **Views:** - `*` #### master_rights_audit - **Includes:** 1 views - **Views:** - `*` #### meta_analytics - **Includes:** 1 views - **Views:** - `meta_analytics/meta_analytics` #### meta_update - **Includes:** 22 views - **Views:** - `meta_update_queue` - `meta_update_dms_master` - `orch_app_ar_releases` - `orch_app_ar_country` - `orch_app_ar_track` - `facts_prod_dim_label` - `int_prod_vw_restrictions_release_store` - `orch_app_ar_product_type` - `orch_app_ar_distribution_format` - `orch_app_ar_distribution_format_media` - `int_prod_vw_restrictions_release_territory` - `orch_app_ar_customer_master_master` - `orch_app_ar_artist_info` - `orch_app_ar_orchadmin_users` - `orch_app_ar_vendor` - `int_prod_vw_restrictions_label_store` - `int_prod_vw_restrictions_label_substore` - `int_prod_vw_restrictions_release_substore` - `int_prod_vw_restrictions_label_territory` - `int_prod_vw_restrictions_subaccount_store` - `orch_app_ar_subaccount` - `dt_video_product_builder` #### metrics_by_channel_country - **Includes:** 8 views - **Views:** - `facts_prod_metrics_by_channel_country_feed_distributor_rollup` - `facts_prod_dim_country` - `facts_prod_dim_feed` - `orch_app_ar_youtube_channel` - `orch_app_ar_vendor` - `orch_app_ar_orchadmin_users` - `orch_app_ar_country` - `facts_prod_dim_youtube_channel_names` #### millward_brown_reporting - **Includes:** 3 views - **Views:** - `int_dbt_prod_millward_brown_upc_list` - `orch_app_ar_releases` - `dt_label_manager_insights` #### missing_track_duration - **Includes:** 1 views - **Views:** - `*` #### mobile_analytics - **Includes:** 3 views - **Views:** - `dt_mobile_app_opened` - `dt_label_size` - `dt_mobile_users` #### moments - **Includes:** 29 views - **Views:** - `dev_eng_eimpara_FOURIERTABLE_JUL_SEPT_22` - `dev_eng_eimpara_FOURIERTABLE_APR_SEPT_22` - `dev_eng_eimpara_FOURIERTABLE_FEB_SEPT_22` - `facts_prod_dim_track` - `facts_prod_dim_release` - `facts_prod_dim_artist` - `facts_prod_dim_label` - `orch_app_ar_artist_info` - `dt_project_moments_cluster_groups_140_days` - `dt_project_moments_pred_vs_actual_140_days` - `dt_project_moments_cluster_group_audio_upper_x_lower_bounds` - `dt_project_moments_cluster_groups_v2_fuzzy_logic` - `dt_project_moments_cluster_group_audio_upper_x_lower_bounds_v2_fuzzy_logic` - `dt_project_moments_som_cluster_groups` - `dt_project_moments_cluster_groups_audio_upper_x_lower_bounds_som_logic` - `dt_project_moments_fuzzy_cluster_v4` - `dt_project_moments_cluster_group_upper_x_lower_bounds_fuzzy_v4` - `int_dev_tallman_moments_performance_groups_v1` - `moments_140_days_k_proto_v3_copy` - `moments_track_name_isrc_list` - `facts_prod_dim_genre` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_project_moments_track_groupings_info` - `int_dbt_prod_moments_watchlist` - `project_moments_ma_calculation` - `project_moments_hedra_output_table` - `project_moments_hedra_output_140_days_table` - `uniti_recommends_refined` - `dt_project_moments_uniti_graphical_representation` #### one_pager - **Includes:** 1 views - **Views:** - `*` #### orca_a_and_lp - **Includes:** 3 views - **Views:** - `orca_a_and_lp/*` - `/**/*` - `my_dashboard.dashboard.lookml` #### pandora_sos - **Includes:** 1 views - **Views:** - `*` #### performance_rights_delivery_history - **Includes:** 1 views - **Views:** - `*` #### performance_rights_sales - **Includes:** 2 views - **Views:** - `prs_prod_sx_sales` - `prs_prod_ppl_sales` #### ph_audit_model - **Includes:** 1 views - **Views:** - `*` #### physical - **Includes:** 1 views - **Views:** - `*` #### physical_accounting_all_sales - **Includes:** 1 views - **Views:** - `int_prod_physical_accounting_all_sales` #### physical_eu - **Includes:** 1 views - **Views:** - `*` #### playlist_placements_analysis - **Includes:** 1 views - **Views:** - `*` #### podcast_analytics - **Includes:** 1 views - **Views:** - `*` #### pre_save_data - **Includes:** 1 views - **Views:** - `fact_prod_staging_raw_apple_music_totallibraryadds` #### prod_ows_monitoring - **Includes:** 1 views - **Views:** - `*` #### product_manager_control_panel - **Includes:** 13 views - **Views:** - `int_dbt_prod_pmcp_shazam_activity` - `int_dbt_prod_pmcp_tiktok_top_tracks` - `int_dbt_prod_pmcp_revenue_last_12_months` - `int_dbt_prod_pmcp_top_playlist_radio_station` - `int_dbt_prod_pmcp_top_10_labels_last_12_months` - `int_dbt_prod_pmcp_top_streamed_tracks_all_time` - `int_dbt_prod_pmcp_top_streamed_releases_all_time` - `int_dbt_prod_pmcp_top_10_countries_last_12_months` - `int_dbt_prod_pmcp_top_streamed_new_tracks_last_4_months` - `int_dbt_prod_pmcp_top_streamed_new_releases_last_4_months` - `orch_app_ar_artist_info` - `orch_app_ar_vendor` - `orch_app_ar_releases` #### product_territory_split - **Includes:** 1 views - **Views:** - `*` #### project_maze - **Includes:** 3 views - **Views:** - `project_maze/dbt_prod_spotify_top_200_predictions_weekly` - `/int_dbt_prod_orch_spotify_top_200_chart_appearances` - `/dt_spotify_top_200_aggregates` #### promusicae_certification - **Includes:** 1 views - **Views:** - `*` #### proper_changed_releases - **Includes:** 1 views - **Views:** - `*` #### publishing - **Includes:** 2 views - **Views:** - `*` - `views/publishing/publishing_app_compositions_changes` #### publishing_revenue - **Includes:** 5 views - **Views:** - `orch_app_ar_acct_period` - `orch_app_ar_vendor` - `royalty_accounting_prod_vw_abacus_fact_sales_publishing` - `dt_revenue_by_songwriter` - `publishing_revenue_analytics.dashboard` #### rank_tool - **Includes:** 1 views - **Views:** - `dt_rank_tool` #### red_bull_reports - **Includes:** 3 views - **Views:** - `int_dbt_prod_red_bull_records_streaming_report_all_time` - `int_dbt_prod_red_bull_records_streaming_report_last_60_days` - `dt_rolling_date_windows_analytics` #### release_compare - **Includes:** 1 views - **Views:** - `*` #### release_compare_datasets - **Includes:** 7 views - **Views:** - `int_dbt_prod_release_compare_model_spotify_store` - `int_dbt_prod_release_compare_model_amazon_store` - `int_dbt_prod_release_compare_model_apple_store` - `int_dbt_prod_release_compare_model_apple_playlist` - `facts_prod_dim_track` - `facts_prod_dim_country` - `orch_app_ar_track` #### release_schedule_dashboard - **Includes:** 1 views - **Views:** - `*` #### releases_ingested_top_labels - **Includes:** 3 views - **Views:** - `*` - `/**/view.lkml` - `my_dashboard.dashboard.lookml` #### rev_and_profit_last_12_months - **Includes:** 9 views - **Views:** - `int_prod_territory_grouping` - `int_dbt_prod_last_month_accounting_info` - `orch_app_ar_vendor` - `orch_app_ar_genre` - `facts_prod_dim_label` - `orch_app_ar_orchadmin_users` - `dt_has_local_carveout` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_rev_and_profit_last_12_months` #### revenue_ex_spatial_deliveries - **Includes:** 1 views - **Views:** - `int_dbt_prod_revenue_apple_amazon_ex_spatial_deliveries` #### riaa_certification - **Includes:** 2 views - **Views:** - `dt_riaa_certification` - `int_dbt_prod_awal_tier_groups` #### riaa_us_certification - **Includes:** 2 views - **Views:** - `int_dbt_prod_riaa_model_certification` - `int_dbt_prod_awal_tier_groups` #### rights_management - **Includes:** 1 views - **Views:** - `*` #### ritmogestion_top_10k_streaming_tracks_weekly - **Includes:** 1 views - **Views:** - `facts_prod_staging_raw_ritmogestion` #### round_hill_streaming_report_request - **Includes:** 1 views - **Views:** - `round_hill_streaming_report_request` #### shazam - **Includes:** 1 views - **Views:** - `*` #### shazam_daily_events - **Includes:** 1 views - **Views:** - `facts_prod_shazam_daily_events` #### skips_saves - **Includes:** 1 views - **Views:** - `*` #### sony_aggregate_revenue - **Includes:** 2 views - **Views:** - `sony_internal_prod_orchard_monthly_sap_aggregate_feed_history` - `facts_prod_dim_country` #### soundcloud-statistics - **Includes:** 1 views - **Views:** - `*` #### soundexchange_historic_accounting - **Includes:** 1 views - **Views:** - `*` #### spotify_daily_top_200_orchard_content - **Includes:** 5 views - **Views:** - `int_dbt_prod_spotify_daily_top_200` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_track` - `facts_prod_dim_release` - `facts_prod_dim_artist` #### spotify_statistics - **Includes:** 1 views - **Views:** - `*` #### spotify_top_200_distributed_content - **Includes:** 6 views - **Views:** - `int_dbt_prod_spotify_top_200_vs_orchard_distributed_content_streams` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_track` - `facts_prod_dim_release` - `facts_prod_dim_artist` - `orch_app_ar_releases` #### statement_db - **Includes:** 2 views - **Views:** - `stmt_db_*.view` - `dt_itunes_complete_month_by_service.view` #### store_availability - **Includes:** 1 views - **Views:** - `*` #### store_backfill_priority - **Includes:** 2 views - **Views:** - `dt_store_backfill_priority` - `dt_deliverable_from_release` #### store_qbr - **Includes:** 1 views - **Views:** - `dt_fact_sales_revenue_buckets` #### stream_share_spotify_weekly - **Includes:** 2 views - **Views:** - `stream_share_spotify_weekly` - `int_dbt_prod_awal_tier_groups` #### streaming_fraud - **Includes:** 10 views - **Views:** - `int_dbt_prod_weekly_fraudulent_streams_flags_spotify` - `int_dbt_prod_stg_sos_fraud_spike_over_500_pct` - `facts_prod_dim_country` - `facts_prod_dim_label` - `orch_app_ar_country` - `orch_app_ar_vendor` - `orch_app_ar_releases` - `orch_app_ar_genre` - `facts_prod_dim_release` - `orch_app_ar_subaccount` #### streaming_fraud_detection - **Includes:** 1 views - **Views:** - `dt_streaming_fraud_detection` #### subset_data - **Includes:** 4 views - **Views:** - `SUBSET_FOURIER_2023_DATA` - `SUBSET_ARIMA_2023_DATA` - `SUBSET_MANUALCLUSTERING_2023_DATA` - `SUBSET_PREDICTED_VALUES_2023_DATA` #### summary_sos - **Includes:** 1 views - **Views:** - `*` #### territory_kpis_2 - **Includes:** 1 views - **Views:** - `views/territory_kpis/*` #### tiktok_pitch_grid_us - **Includes:** 3 views - **Views:** - `tiktok_pitch_grid_us` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_track.view` #### tiktok_top_500_model - **Includes:** 1 views - **Views:** - `*` #### timed_release - **Includes:** 2 views - **Views:** - `*` - `orch_app_ar_vendor` #### top_playlist_by_country - **Includes:** 1 views - **Views:** - `dt_top_playlist_by_country` #### top_stores_by_artist - **Includes:** 1 views - **Views:** - `dt_top_stores_by_artist` #### top_tracks - **Includes:** 1 views - **Views:** - `*` #### top_tracks_by_artist - **Includes:** 2 views - **Views:** - `dt_top_tracks_by_artist` - `int_dbt_prod_awal_tier_groups` #### track_compare - **Includes:** 1 views - **Views:** - `*` #### track_playlist - **Includes:** 6 views - **Views:** - `track_level_playlisting` - `facts_prod_dim_isrc` - `orch_app_ar_vendor` - `orch_app_ar_artist_info` - `facts_prod_dim_track` - `int_dbt_prod_awal_tier_groups` #### trending_tracks_new - **Includes:** 1 views - **Views:** - `*` #### tsz_fa - **Includes:** 1 views - **Views:** - `*` #### vector_backlog - **Includes:** 1 views - **Views:** - `dt_vector_backlog` #### vendor_payment_hold - **Includes:** 1 views - **Views:** - `*` #### video_product_builder - **Includes:** 13 views - **Views:** - `dt_video_product_builder` - `dt_agg_restrictions_release_territory` - `facts_prod_dim_genre` - `orch_app_ar_releases` - `orch_app_ar_mkt_priority` - `orch_app_ar_track` - `orch_app_ar_track_video` - `int_dbt_prod_awal_tier_groups` - `orch_app_ar_product_video_approval` - `/dt_blocklist_artist_with_reason` - `int_dbt_prod_product_manager_mapping_union` - `/orch_app_ar_vendor` - `/orch_app_ar_orchadmin_users` #### weekly_hot_tracks - **Includes:** 2 views - **Views:** - `*` - `my_dashboard.dashboard.lookml` #### weekly_streaming_overview - **Includes:** 1 views - **Views:** - `*` #### weekly_trending_playlists_spotify - **Includes:** 2 views - **Views:** - `weekly_trending_playlists_spotify` - `facts_prod_dim_country` #### youtube_analytics_by_day - **Includes:** 1 views - **Views:** - `*` #### youtube_statistics - **Includes:** 1 views - **Views:** - `*` #### yt_video_assets - **Includes:** 1 views - **Views:** - `*` #### zzz_sync_test_pipenv - **Includes:** 1 views - **Views:** - `*` ## View Dependencies ### Views by Data Source #### Direct Database Tables Views that directly reference database tables: **"ART_RELATIONS_PROD_ART_RELATIONS"."ACCT_PERIOD"** - Used by 1 views: `orch_app_ar_acct_period` **"ART_RELATIONS_PROD_ART_RELATIONS"."ASSET"** - Used by 1 views: `orch_app_ar_asset` **"DBT_PROD"."ALL_SIGNED_LABELS_REVENUE_COLUMNS"** - Used by 1 views: `all_signed_labels_revenue_columns` **"DBT_PROD"."APPLE_MUSIC_DEMOGRAPHICS"** - Used by 1 views: `int_dbt_prod_apple_music_demographic` **"DBT_PROD"."APPLE_PODCASTING_MODEL"** - Used by 1 views: `daily_apple_podcasting_events_snapshots_joined` **"DBT_PROD"."APPROVED_PRODUCTS_REVENUE"** - Used by 1 views: `int_dbt_prod_approved_products_revenue` **"DBT_PROD"."AR_PRODUCT_PHYSICAL_CHANGE_HISTORY_LATEST_CHANGES_AND_DELETIONS"** - Used by 1 views: `ar_product_physical_change_history_latest_changes_and_deletions` **"DBT_PROD"."ENGAGEDVSLEANBACKBREAKDOWN"** - Used by 1 views: `int_dbt_prod_ENGAGEDVSLEANBACKBREAKDOWN` **"DBT_PROD"."GBP_TO_EUR_EXCHANGE_RATE_LATEST"** - Used by 1 views: `gbp_to_eur_exchange_rate_latest` **"DBT_PROD"."LABEL_OFFERING"** - Used by 1 views: `label_offering` **"DBT_PROD"."MONTHLY_SNOWFLAKE_STORAGE_COSTS"** - Used by 1 views: `monthly_snowflake_storage_costs` **"DBT_PROD"."ORCHARD_NEW_ADVERTISING_CAMPAIGNS"** - Used by 1 views: `advertising_campaigns` **"DBT_PROD"."ORCHARD_NEW_ADVERTISING_REQUESTS"** - Used by 1 views: `advertising_requests` **"DBT_PROD"."RELEASE_COMPARE_MODEL_AMAZON_STORE"** - Used by 1 views: `int_dbt_prod_release_compare_model_amazon_store` **"DBT_PROD"."RELEASE_COMPARE_MODEL_APPLE_PLAYLIST"** - Used by 1 views: `int_dbt_prod_release_compare_model_apple_playlist` **"DBT_PROD"."RELEASE_COMPARE_MODEL_APPLE_STORE"** - Used by 1 views: `int_dbt_prod_release_compare_model_apple_store` **"DBT_PROD"."RELEASE_COMPARE_MODEL_SPOTIFY_STORE"** - Used by 1 views: `int_dbt_prod_release_compare_model_spotify_store` **"DBT_PROD"."REVENUE_LAST_12_MONTHS"** - Used by 1 views: `int_dbt_prod_pmcp_revenue_last_12_months` **"DBT_PROD"."SHAZAM_ACITIVITY"** - Used by 1 views: `int_dbt_prod_pmcp_shazam_activity` **"DBT_PROD"."SNOWFLAKE_QUERY_HISTORY"** - Used by 1 views: `snowflake_query_history` **"DBT_PROD"."SNOWFLAKE_WAREHOUSE_METERING_XF"** - Used by 1 views: `snowflake_warehouse_metering_xf` **"DBT_PROD"."SOURCE_BREAKDOWN"** - Used by 1 views: `int_dbt_prod_Source_Breakdown` **"DBT_PROD"."SPOTIFY_PLAYLIST_LEAN_FWD_LEAN_BACK_CATEGORIZATION"** - Used by 1 views: `spotify_playlist_lean_fwd_lean_back_categorization` **"DBT_PROD"."SUB_GENRES"** - Used by 1 views: `int_dbt_prod_Sub_Genres` **"DBT_PROD"."TIER_BREAKDOWN"** - Used by 1 views: `int_dbt_prod_Tier_Breakdown` **"DBT_PROD"."TIKTOK_TOP_TRACKS"** - Used by 1 views: `int_dbt_prod_pmcp_tiktok_top_tracks` **"DBT_PROD"."TOP_10_COUNTRIES_LAST_12_MONTHS"** - Used by 1 views: `int_dbt_prod_pmcp_top_10_countries_last_12_months` **"DBT_PROD"."TOP_10_LABEL_LAST_12_MONTHS"** - Used by 1 views: `int_dbt_prod_pmcp_top_10_labels_last_12_months` **"DBT_PROD"."TOP_CITIES_DATASET"** - Used by 1 views: `int_dbt_prod_top_cities_dataset` **"DBT_PROD"."TOP_PLAYLIST_RADIO_STATION"** - Used by 1 views: `int_dbt_prod_pmcp_top_playlist_radio_station` **"DBT_PROD"."TOP_STREAMED_NEW_RELEASES_LAST_4_MONTHS"** - Used by 1 views: `int_dbt_prod_pmcp_top_streamed_new_releases_last_4_months` **"DBT_PROD"."TOP_STREAMED_NEW_TRACKS_LAST_4_MONTHS"** - Used by 1 views: `int_dbt_prod_pmcp_top_streamed_new_tracks_last_4_months` **"DBT_PROD"."TOP_STREAMED_RELEASES_ALL_TIME"** - Used by 1 views: `int_dbt_prod_pmcp_top_streamed_releases_all_time` **"DBT_PROD"."TOP_STREAMED_TRACKS_ALL_TIME"** - Used by 1 views: `int_dbt_prod_pmcp_top_streamed_tracks_all_time` **"DBT_PROD"."WEEKLY_NO_OF_NEW_RELEASES"** - Used by 1 views: `int_dbt_prod_Weekly_no_of_New_Releases` **"DBT_PROD"."WOW_STREAMS_BY_DSP"** - Used by 1 views: `int_dbt_prod_WoW_Streams_by_DSP` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."FACT_ANALYTICS_LAST_3_WEEKS"** - Used by 1 views: `int_dbt_prod_lmcp_fact_analytics_last_3_weeks` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_ACTIVE_RELEASES"** - Used by 1 views: `int_dbt_prod_lmcp_lmcp_active_releases` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_ASSIGNED_LABELS"** - Used by 1 views: `int_dbt_prod_lmcp_assigned_labels` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_LM_NAME"** - Used by 1 views: `int_dbt_prod_lmcp_lm_name` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_NEW_RELEASES_IN_LABEL_PROCESSING"** - Used by 1 views: `int_dbt_prod_lmcp_new_releases_in_label_processing` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_SHAZAM_ACTIVITY"** - Used by 1 views: `int_dbt_prod_lmcp_shazam_activity` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TIKTOK_TOP_TRACKS"** - Used by 1 views: `int_dbt_prod_lmcp_tiktok_top_tracks` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TOP_LABELS"** - Used by 1 views: `int_dbt_prod_lmcp_top_labels` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TOP_OVERALL_RELEASES"** - Used by 1 views: `int_dbt_prod_lmcp_top_overall_releases` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TOP_OVERALL_TRACKS"** - Used by 1 views: `int_dbt_prod_lmcp_top_overall_tracks` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TOP_PLAYLISTS_RADIO"** - Used by 1 views: `int_dbt_prod_lmcp_top_playlists_radio` **"DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_UPCOMING_NEW_RELEASES"** - Used by 1 views: `int_dbt_prod_lmcp_upcoming_new_releases` **"DBT_PROD_PROJECT_MOMENTS".uniti_recommends_v3** - Used by 1 views: `uniti_recommends_refined` **"DEV_AWALSPOTIFY"."VW_BELIEVE"** - Used by 1 views: `int_dev_awalspotify_vwbelieve` **"PROD"."STAGING_RAW_APPLE_MUSIC_TOTALLIBRARYADDS"** - Used by 1 views: `fact_prod_staging_raw_apple_music_totallibraryadds` **"PROD_LOOKER_HISTORY"."PROD_LOOKER_CONNECTION_QUERY_HISTORY"** - Used by 1 views: `prod_looker_connection_query_history` **"PROD_LOOKER_HISTORY"."PROD_LOOKER_TOTAL_QUERY_HISTORY"** - Used by 1 views: `prod_looker_total_query_history` **"PROD_LOOKER_HISTORY"."PROD_LOOKER_USER_HISTORY"** - Used by 1 views: `prod_looker_user_history` **"PROD_LOOKER_HISTORY"."PROD_PERF_BY_USER_GROUP"** - Used by 1 views: `prod_perf_by_user_group` **ART_RELATIONS_PROD_ART_RELATIONS.CONCIERGE_PRODUCT** - Used by 1 views: `orch_app_ar_concierge_product` **ART_RELATIONS_PROD_ART_RELATIONS.CUSTOMER_MASTER_MASTER** - Used by 1 views: `orch_app_ar_customer_master_master` **ART_RELATIONS_PROD_ART_RELATIONS.DISTRIBUTION_FORMAT_MEDIA_FORMAT** - Used by 1 views: `orch_app_ar_distribution_format_media_format` **ART_RELATIONS_PROD_ART_RELATIONS.FOCUS_TRACK** - Used by 1 views: `focus_track` **ART_RELATIONS_PROD_ART_RELATIONS.META_UPDATE_DMS_MASTER** - Used by 1 views: `meta_update_dms_master` **ART_RELATIONS_PROD_ART_RELATIONS.META_UPDATE_QUEUE** - Used by 1 views: `meta_update_queue` **ART_RELATIONS_PROD_ART_RELATIONS.PRODUCT_PHYSICAL_SUPPLY_CHAIN_METADATA** - Used by 1 views: `orch_app_ar_product_physical_supply_chain_metadata` **ART_RELATIONS_PROD_ART_RELATIONS.PRODUCT_SPLIT** - Used by 1 views: `orch_app_ar_product_split` **ART_RELATIONS_PROD_ART_RELATIONS.PRODUCT_TERRITORY_SPLIT** - Used by 1 views: `orch_app_ar_product_territory_split` **ART_RELATIONS_PROD_ART_RELATIONS.TRACK_ARTIST** - Used by 1 views: `ORCHARD_APP_REPORTING_V2_ART_RELATIONS_PROD_ART_RELATIONS_TRACK_ARTIST` **ART_RELATIONS_PROD_ART_RELATIONS.TRACK_SPLIT** - Used by 1 views: `orch_app_ar_track_split` **ART_RELATIONS_PROD_ART_RELATIONS.TRACK_VIDEO** - Used by 1 views: `orch_app_ar_track_video` **ART_RELATIONS_PROD_ART_RELATIONS.VENDOR_CLOSERS** - Used by 1 views: `orch_app_ar_vendor_closers` **ART_RELATIONS_PROD_ART_RELATIONS.VENDOR_DMS_MASTER_CONTRACT** - Used by 1 views: `orch_app_ar_vendor_dms_master_contract` **ART_RELATIONS_PROD_ART_RELATIONS.VENDOR_PHYSICAL_SUPPLYCHAIN_DEFAULT_SELECTION** - Used by 1 views: `orch_app_ar_vendor_physical_supply_chain_default_selection` **ART_RELATIONS_PROD_ART_RELATIONS.VENDOR_TERRITORY_CONTRACT** - Used by 1 views: `orch_app_ar_vendor_territory_contract` **CCAPALBO.LABEL_MANAGER_TERRITORY_MAP** - Used by 1 views: `dev_engineering_ccapalbo_label_manager_territory_map` **DBT_PROD.ABACUS_FACT_SALES** - Used by 1 views: `int_dbt_prod_abacus_fact_sales` **DBT_PROD.ACCOUNTING_LAST_12_MONTHS_ACTIVITY_DATE** - Used by 1 views: `int_dbt_prod_accounting_last_12_months_activity_date` **DBT_PROD.ACCOUNTING_LAST_24_MONTHS_ACTIVITY_DATE_TRACK_LEVEL** - Used by 1 views: `int_dbt_prod_accounting_last_24_months_activity_date_track_level` **DBT_PROD.AGGREGATED_NETEASE_MODEL** - Used by 1 views: `int_dbt_prod_agg_netease_model` **DBT_PROD.AGGREGATED_TENCENT_STOREFRONT_MODEL** - Used by 1 views: `int_dbt_prod_agg_tencent_model` **DBT_PROD.AGG_AMAZON_AGGREGATED** - Used by 1 views: `int_dbt_prod_agg_amazon_model` **DBT_PROD.AGG_APPLE_SUMMARY** - Used by 1 views: `int_dbt_prod_agg_apple_model` **DBT_PROD.AGG_APPLE_SUMMARY_18MONTHS** - Used by 1 views: `int_dbt_prod_agg_apple_summary_18months` **DBT_PROD.AGG_ARTIST_STORE_LINKS** - Used by 1 views: `dbt_artist_store_links` **DBT_PROD.AGG_AWA_MODEL** - Used by 1 views: `int_dbt_prod_agg_awa_model` **DBT_PROD.AGG_DEEZER_MODEL** - Used by 1 views: `int_dbt_prod_agg_deezer_model` **DBT_PROD.AGG_LINE_MODEL** - Used by 1 views: `int_dbt_prod_agg_line_model` **DBT_PROD.AGG_MONTHLY_APPLE_SUMMARY** - Used by 1 views: `int_dbt_prod_agg_monthly_apple_summary` **DBT_PROD.AGG_PANDORA_MODEL** - Used by 1 views: `int_dbt_prod_agg_pandora_model` **DBT_PROD.AGG_SNAPCHAT_MODEL** - Used by 1 views: `int_dbt_prod_agg_snapchat_model` **DBT_PROD.AGG_SOUNDCLOUD_MODEL** - Used by 1 views: `int_dbt_prod_agg_soundcloud_model` **DBT_PROD.AGG_SPOTIFY_MODEL** - Used by 1 views: `int_dbt_prod_agg_spotify_model` **DBT_PROD.AGG_TIKTOK_MODEL** - Used by 1 views: `facts_prod_staging_raw_tiktok` **DBT_PROD.AGG_UMA_MODEL** - Used by 1 views: `int_dbt_prod_agg_uma_model` **DBT_PROD.AGG_WEEKLY_APPLE_SUMMARY** - Used by 1 views: `int_dbt_prod_agg_weekly_apple_summary` **DBT_PROD.AGG_WYNK_MODEL** - Used by 1 views: `int_dbt_prod_agg_wynk_model` **DBT_PROD.AMPROFON_ALBUM_CERTIFICATION** - Used by 1 views: `int_dbt_prod_amprofon_album_cert` **DBT_PROD.AMPROFON_TRACK_CERTIFICATION** - Used by 1 views: `int_dbt_prod_amprofon_track_cert` **DBT_PROD.ANUEL_AA_TOPTACKS_MONTHLY** - Used by 1 views: `int_dbt_prod_anuel_aa_toptracks_monthly` **DBT_PROD.APG_APPLE_PITCH_GRID** - Used by 1 views: `dt_apple_music_pitch_grid` **DBT_PROD.APPLE_EXCLUDED_STREAMS** - Used by 1 views: `int_dbt_prod_apple_excluded_streams` **DBT_PROD.APPLE_IN_REVIEW** - Used by 1 views: `int_dbt_prod_apple_in_review` **DBT_PROD.ARIA_ALBUM_CERTIFICATION** - Used by 1 views: `int_dbt_prod_aria_album_cert` **DBT_PROD.ARIA_ALBUM_CERTIFICATION_ACCOUNTING** - Used by 1 views: `int_dbt_prod_aria_album_cert_accounting` **DBT_PROD.ARIA_TRACK_CERTIFICATION** - Used by 1 views: `int_dbt_prod_aria_track_cert` **DBT_PROD.ARIA_TRACK_CERTIFICATION_ACCOUNTING** - Used by 1 views: `int_dbt_prod_aria_track_cert_accounting` **DBT_PROD.ARTISTS_BY_TERRITORY_ACCOUNTING** - Used by 1 views: `int_dbt_prod_artist_by_territory_accounting` **DBT_PROD.ARTIST_MARKETSHARE** - Used by 1 views: `int_dbt_prod_artist_marketshare` **DBT_PROD.AWAL_AGR_NR_MODEL** - Used by 1 views: `int_dbt_prod_awal_agr_nr_model` **DBT_PROD.AWAL_ALL_POS_MODEL** - Used by 1 views: `int_dbt_prod_awal_all_pos_model` **DBT_PROD.AWAL_APPLICATIONS_MODEL** - Used by 1 views: `int_dbt_prod_awal_applications_model` **DBT_PROD.AWAL_BASIC_TAKEDOWNS_MODEL** - Used by 1 views: `int_dbt_prod_awal_basic_takedowns_model` **DBT_PROD.AWAL_GROUP_AGR_RECORDINGS_MODEL** - Used by 1 views: `int_dbt_prod_awal_groups_agr_recordings_model` **DBT_PROD.AWAL_NEW_CLIENT_LIST_MODEL** - Used by 1 views: `int_dbt_prod_awal_new_client_list_model` **DBT_PROD.AWAL_PAID_AND_FUTURE_ADVANCES_MODEL** - Used by 1 views: `int_dbt_prod_awal_paid_and_future_advances_model` **DBT_PROD.AWAL_TIER_GROUPS** - Used by 1 views: `int_dbt_prod_awal_tier_groups` **DBT_PROD.CHANGES_BY_SOURCE** - Used by 1 views: `int_dbt_prod_changes_by_source` **DBT_PROD.CHARTMETRIC_SOCIAL_STATS** - Used by 1 views: `int_dbt_prod_chartmetric_social_stats` **DBT_PROD.COMPLETION_RATE_TRACK_LEVEL_MONTHLY** - Used by 1 views: `int_dbt_prod_completion_rate_track_level_monthly` **DBT_PROD.CONTENT_REVIEW_QUEUE_UNIONED** - Used by 1 views: `dt_release_approval_queue` **DBT_PROD.DEEZER_FRAUD_REPORT** - Used by 1 views: `int_dbt_deezer_fraud_report` **DBT_PROD.DIGITAL_BULK_TEMPLATE** - Used by 1 views: `int_dbt_prod_digital_bulk_template` **DBT_PROD.DT_ABOVE_BOARD_PHYSICAL_PRICE_CODE** - Used by 1 views: `dt_above_board_physical_price_code` **DBT_PROD.DT_ALTAFONTE_PHYSICAL_PRICE_CODE** - Used by 1 views: `dt_altafonte_physical_price_code` **DBT_PROD.DT_AMAZON_ASIN** - Used by 1 views: `dt_amazon_asin` **DBT_PROD.DT_ARTIST_SIMILARITY_ACCOUNTING** - Used by 1 views: `dt_artist_similarity_accounting` **DBT_PROD.DT_CHECKS** - Used by 1 views: `dt_checks` **DBT_PROD.DT_CONTENT_VALIDATION_FEATURING_ARTISTS** - Used by 1 views: `dt_content_validation_featuring_artists` **DBT_PROD.DT_CONTENT_VALIDATION_RELEASE_LEVEL** - Used by 1 views: `dt_content_validation_release_level` **DBT_PROD.DT_CONTENT_VALIDATION_TEMPLATE** - Used by 1 views: `dt_content_validation_template` **DBT_PROD.DT_CONTENT_VALIDATION_TRACK_LEVEL** - Used by 1 views: `dt_content_validation_track_level` **DBT_PROD.DT_DD_POSSIBLE_DUPLICATES** - Used by 1 views: `dt_dd_possible_duplicates` **DBT_PROD.DT_FACT_SALES_MARKET_SHARE_ARTIST_LEVEL** - Used by 1 views: `dt_fact_sales_market_share_artist_level` **DBT_PROD.DT_FINANCE_EXPORT_UK** - Used by 1 views: `dt_finance_export_uk` **DBT_PROD.DT_FLATTEN_COUNTRY_REGION** - Used by 1 views: `dt_flatten_country_region` **DBT_PROD.DT_FLATTEN_MARKETING_INFO** - Used by 1 views: `dt_flatten_marketing_info` **DBT_PROD.DT_HAS_LOCAL_CARVEOUT** - Used by 1 views: `dt_has_local_carveout` **DBT_PROD.DT_INVALID_REFERENCES_GAMEPLAY_WORDS** - Used by 1 views: `dt_invalid_references_gameplay_words` **DBT_PROD.DT_INVALID_REFERENCES_SAMPLE_PACK_WORDS** - Used by 1 views: `dt_invalid_references_sample_pack_words` **DBT_PROD.DT_INVALID_TRACK_WRITER** - Used by 1 views: `dt_invalid_track_writer` **DBT_PROD.DT_ISRC_REGISTRY** - Used by 1 views: `dt_isrc_registry` **DBT_PROD.DT_ITUNES_ALBUM_PREORDERS** - Used by 1 views: `dt_itunes_album_preorders` **DBT_PROD.DT_ITUNES_TICKET_MAX_DATE_FILTER** - Used by 1 views: `dt_itunes_ticket_max_date_filter` **DBT_PROD.DT_ITUNES_TICKET_WITHIN_WINDOW** - Used by 1 views: `dt_itunes_ticket_within_window` **DBT_PROD.DT_LABELCOPY_INGEST_ROWS_BY_DAY** - Used by 1 views: `dt_labelcopy_ingest_rows_by_day` **DBT_PROD.DT_LABEL_CONTRACT_TERRITORIES** - Used by 1 views: `dt_label_contract_territories` **DBT_PROD.DT_LABEL_IS_PHYSICAL** - Used by 1 views: `dt_label_is_physical` **DBT_PROD.DT_LABEL_MANAGER_INSIGHTS** - Used by 1 views: `dt_label_manager_insights` **DBT_PROD.DT_LABEL_MANAGER_INSIGHTS_TEMP** - Used by 1 views: `dt_label_manager_insights_temp` **DBT_PROD.DT_LABEL_SIZE** - Used by 1 views: `dt_label_size` **DBT_PROD.DT_MARKETING_CHANGE_LOG** - Used by 1 views: `dt_marketing_change_log` **DBT_PROD.DT_MASTER_RIGHTS_AUDIT** - Used by 1 views: `dt_master_rights_audit` **DBT_PROD.FIRST_ACCESS_7_DAYS_28_DAYS_ALL_TIME** - Used by 1 views: `int_dbt_prod_first_access_analytics_reporting` **DBT_PROD.FRAUDULENT_STREAMS_FLAGS_SPOTIFY** - Used by 1 views: `int_dbt_prod_weekly_fraudulent_streams_flags_spotify` **DBT_PROD.FULL_TRACK_METADATA_REPORT_DELIVERY_HISTORY** - Used by 1 views: `int_dbt_prod_full_track_metadata_report_delivery_history` **DBT_PROD.GLOBAL_CHART_TRACKING** - Used by 1 views: `int_dbt_prod_global_chart_tracking` **DBT_PROD.IFPI_COUNTRY_LABEL_LEVEL_ACCOUNTING** - Used by 1 views: `int_dbt_prod_ifpi_country_label_level_accounting` **DBT_PROD.ITUNES_LANGUAGE_VALIDATION** - Used by 1 views: `int_prod_itunes_language_validation` **DBT_PROD.LABEL_LOGINS_MODEL** - Used by 1 views: `int_dbt_prod_label_logins_model` **DBT_PROD.LABEL_PERFORMANCE_SPREADSHEET** - Used by 1 views: `int_dbt_prod_label_performance_spreadsheet` **DBT_PROD.LAST_MONTH_ACCOUNTING_INFO** - Used by 1 views: `int_dbt_prod_last_month_accounting_info` **DBT_PROD.MILLWARD_BROWN_UPC_LIST** - Used by 1 views: `int_dbt_prod_millward_brown_upc_list` **DBT_PROD.ORCA_A_AND_LP_DATASET** - Used by 1 views: `int_dbt_prod_orca_a_and_lp_dataset` **DBT_PROD.ORCHARD_NEW_ADVERTISING_MONTHLY_ACTIVITY** - Used by 1 views: `advertising_monthly_activity` **DBT_PROD.ORCHARD_PRICING_BY_RELEASE** - Used by 1 views: `int_prod_vw_orchard_pricing_by_release` **DBT_PROD.PER_PLAY_RATE_LAST_4_YEARS** - Used by 1 views: `int_dbt_prod_per_play_rate` **DBT_PROD.PLAYLIST_MODEL_JOINT** - Used by 1 views: `int_dbt_prod_playlist_model_joint` **DBT_PROD.PLAYLIST_MODEL_PANDORA** - Used by 1 views: `int_dbt_prod_playlist_model_pandora` **DBT_PROD.PLAYLIST_MODEL_SOUNDCLOUD** - Used by 1 views: `int_dbt_prod_playlist_model_soundcloud` **DBT_PROD.PLAYLIST_MODEL_SPOTIFY_ROLLUP_1_YEAR_EDITORIAL_ORCHARD** - Used by 1 views: `int_dbt_prod_playlist_model_spotify_rollup_1_year_editrorial_orchard` **DBT_PROD.PLAYLIST_RETURN_RATE_AVG_LAST_6_MONTHS** - Used by 1 views: `int_dbt_prod_playlist_return_rate_last_6_month_avg` **DBT_PROD.PROMUSICAE_ALBUM_CERTIFICATION** - Used by 1 views: `int_dbt_prod_promusicae_album_cert` **DBT_PROD.PROMUSICAE_BRAZIL_CERTIFICATION** - Used by 1 views: `int_dbt_prod_promusicae_brazil_cert` **DBT_PROD.PROMUSICAE_TRACK_CERTIFICATION** - Used by 1 views: `int_dbt_prod_promusicae_track_cert` **DBT_PROD.RCL_RELEASE_CHANGE_LOG** - Used by 1 views: `int_prod_rcl_release_change_log` **DBT_PROD.RCL_TRACK_IG_CHANGES** - Used by 1 views: `int_prod_rcl_track_ig_changes` **DBT_PROD.RED_BULL_RECORDS_STREAMING_REPORT_ALL_TIME** - Used by 1 views: `int_dbt_prod_red_bull_records_streaming_report_all_time` **DBT_PROD.RED_BULL_RECORDS_STREAMING_REPORT_LAST_60_DAYS** - Used by 1 views: `int_dbt_prod_red_bull_records_streaming_report_last_60_days` **DBT_PROD.RELEASE_ARTISTS** - Used by 1 views: `int_prod_vw_release_artists` **DBT_PROD.REV_AND_PROFIT_LAST_24_MONTHS** - Used by 1 views: `int_dbt_prod_rev_and_profit_last_12_months` **DBT_PROD.RIAA_ALBUM_CERTIFICATION** - Used by 1 views: `int_dbt_prod_riaa_album_cert` **DBT_PROD.RIAA_CERTIFICATION** - Used by 1 views: `int_dbt_prod_riaa_model_certification` **DBT_PROD.RIAA_CERTIFICATION_MODEL** - Used by 1 views: `int_dbt_prod_riaa_certification` **DBT_PROD.RIAA_TRACK_CERTIFICATION** - Used by 1 views: `int_dbt_prod_riaa_track_cert` **DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_CREATIONS** - Used by 1 views: `int_dbt_prod_rolling_weekly_tiktok_trending_creations` **DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_CREATIONS_3_WEEKS** - Used by 1 views: `int_dbt_prod_rolling_weekly_tiktok_trending_creations_3_weeks` **DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_CREATIONS_5_WEEKS** - Used by 1 views: `int_dbt_prod_rolling_weekly_tiktok_trending_creations_5_weeks` **DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_VIDEO_VIEWS** - Used by 1 views: `int_dbt_prod_rolling_weekly_tiktok_trending_video_views` **DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_VIDEO_VIEWS_3_WEEKS** - Used by 1 views: `int_dbt_prod_rolling_weekly_tiktok_trending_video_views_3_weeks` **DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_VIDEO_VIEWS_5_WEEKS** - Used by 1 views: `int_dbt_prod_rolling_weekly_tiktok_trending_video_views_5_weeks` **DBT_PROD.RSD_V2** - Used by 1 views: `int_dbt_prod_rsd_v2` **DBT_PROD.SALES_PERFORMANCE_METRICS_SPOTIFY** - Used by 1 views: `int_dbt_prod_sales_performance_metrics` **DBT_PROD.SPATIAL_AUDIO_DELIVERY_HISTORY_SEARCH** - Used by 1 views: `int_dbt_prod_spatial_audio_delivery_history_search` **DBT_PROD.SPOTIFY_DAILY_TOP_200** - Used by 1 views: `int_dbt_prod_spotify_daily_top_200` **DBT_PROD.SPOTIFY_EDITORIAL_PLAYLIST_POSITION_LOG** - Used by 1 views: `int_dbt_prod_spotify_editorial_playlist_position_log` **DBT_PROD.SPOTIFY_MONTHLY_FRAUDULENT_STREAMING** - Used by 1 views: `int_dbt_prod_spotify_monthly_fraudulent_streaming` **DBT_PROD.SPOTIFY_PLAYLIST_COUNTRY** - Used by 1 views: `int_dbt_prod_spotify_playlist_country` **DBT_PROD.SPOTIFY_PLAYLIST_FOLLOWERS_EDITORIAL** - Used by 1 views: `int_dbt_prod_spotify_playlist_followers` **DBT_PROD.SPOTIFY_PLAYLIST_GENRE** - Used by 1 views: `dt_playlist_genre` **DBT_PROD.SPOTIFY_PLAYLIST_TOP_STREAMING_COUNTRY_EDITORIAL** - Used by 1 views: `int_dbt_prod_spotify_playlist_top_streaming_country` **DBT_PROD.SPOTIFY_PLAYLIST_TYPE** - Used by 1 views: `int_dbt_prod_spotify_playlist_type` **DBT_PROD.SPOTIFY_TRACK_AUDIO_FEATURES** - Used by 1 views: `int_dbt_prod_spotify_track_audio_features` **DBT_PROD.STG_CM_SOCIAL_FOLLOWERS_CLEAN** - Used by 1 views: `int_dbt_prod_stg_cm_social_followers_clean` **DBT_PROD.STG_DIM_PLAYLIST_AMAZON** - Used by 1 views: `int_dbt_prod_stg_dim_playlist_amazon` **DBT_PROD.STG_DIM_PLAYLIST_APPLE** - Used by 1 views: `int_dbt_prod_stg_dim_playlist_apple` **DBT_PROD.STG_SOS_FRAUD_SPIKE_OVER_500_PCT** - Used by 1 views: `int_dbt_prod_stg_sos_fraud_spike_over_500_pct` **DBT_PROD.STOREFRONT_LINKS** - Used by 1 views: `int_prod_vw_storefront_links` **DBT_PROD.STORE_PRICING_BY_RELEASE** - Used by 1 views: `int_prod_vw_store_pricing_by_release` **DBT_PROD.SUMMARY_STREAMS** - Used by 1 views: `int_dbt_prod_summary_streams` **DBT_PROD.TIKTOK_FRAUD_STREAMS_MODEL** - Used by 1 views: `int_dbt_prod_tiktok_fraud_model` **DBT_PROD.TIKTOK_TRACK_LINKS** - Used by 1 views: `dbt_tiktok_track_links` **DBT_PROD.TIKTOK_TRENDING_TRACKS** - Used by 1 views: `int_dbt_prod_tiktok_trending_tracks` **DBT_PROD.TOP_ARTISTS_MONTHLY** - Used by 1 views: `int_dbt_prod_top_artists_monthly` **DBT_PROD.TOP_TRACKS_MONTHLY** - Used by 1 views: `int_dbt_prod_top_tracks_monthly` **DBT_PROD.TRACKS_GENERATING_1000_STREAMS** - Used by 1 views: `int_dbt_prod_tracks_generating_1000_streams` **DBT_PROD.TRACK_ARTISTS** - Used by 1 views: `int_prod_vw_track_artists` **DBT_PROD.TRACK_LEVEL_ACCOUNTING_V1** - Used by 1 views: `int_dbt_prod_track_level_accounting` **DBT_PROD.TRACK_LEVEL_PLAYLISTING** - Used by 1 views: `track_level_playlisting` **DBT_PROD.TSZ_FA** - Used by 1 views: `TSZ_FA` **DBT_PROD.VENDOR_CONTRACT_CHANGE_HISTORY_MISSING_ROYALTY_COUNTRY_CODES** - Used by 1 views: `int_dbt_prod_vendor_contract_changes_missing_royalty_country_codes` **DBT_PROD.WEEKLY_TRENDING_GENRES_TIKTOK** - Used by 1 views: `int_dbt_prod_weekly_trending_genres_tiktok` **DBT_PROD.WEEKLY_TRENDING_PLAYLISTS_SPOTIFY** - Used by 1 views: `weekly_trending_playlists_spotify` **DBT_PROD.WEEKLY_TRENDING_TRACKS_AWA** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_awa` **DBT_PROD.WEEKLY_TRENDING_TRACKS_DEEZER** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_deezer` **DBT_PROD.WEEKLY_TRENDING_TRACKS_LINE** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_line` **DBT_PROD.WEEKLY_TRENDING_TRACKS_PANDORA** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_pandora` **DBT_PROD.WEEKLY_TRENDING_TRACKS_SOUNDCLOUD** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_soundcloud` **DBT_PROD.WEEKLY_TRENDING_TRACKS_SPOTIFY_CONTINENT_LEVEL** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_spotify_continent` **DBT_PROD.YOUTUBE_SHORTS** - Used by 1 views: `int_dbt_prod_youtube_shorts` **DBT_PROD.YOUTUBE_SPIKE_REPORT** - Used by 1 views: `int_dbt_prod_youtube_spike_report` **DBT_PROD.YOUTUBE_SUMMARY_STREAMS_DAILY** - Used by 1 views: `int_dbt_prod_youtube_summary_streams_daily` **DBT_PROD.agg_amazon_aggregated_18months** - Used by 1 views: `int_dbt_prod_agg_amazon_aggregated_18months` **DBT_PROD.agg_amazon_monthly_rollup** - Used by 1 views: `int_dbt_prod_agg_amazon_monthly_rollup` **DBT_PROD.agg_amazon_monthly_rollup_user_aggregation** - Used by 1 views: `int_dbt_prod_agg_amazon_monthly_rollup_user_aggregation` **DBT_PROD.agg_amazon_weekly_rollup** - Used by 1 views: `int_dbt_prod_agg_amazon_weekly_rollup` **DBT_PROD.agg_monthly_spotify_model** - Used by 1 views: `int_dbt_prod_agg_monthly_spotify_model` **DBT_PROD.agg_spotify_model_18months** - Used by 1 views: `int_dbt_prod_agg_spotify_model_18months` **DBT_PROD.agg_weekly_rollup_spotify_model** - Used by 1 views: `int_dbt_prod_agg_weekly_rollup_spotify_model` **DBT_PROD.stg_dim_playlist_by_playlist_spotify** - Used by 1 views: `int_dbt_prod_stg_dim_playlist_spotify` **DBT_PROD.weekly_trending_tracks_combined_tiktok** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_combined_tiktok` **DBT_PROD_PROJECT_MOMENTS.PROJECT_MOMENTS_WATCHLIST_INFO** - Used by 1 views: `int_dbt_prod_moments_watchlist` **DBT_PROD_PROJECT_MOMENTS.project_moments_ma_calculation_key_identifier** - Used by 1 views: `project_moments_ma_calculation` **DEV_AWALSPOTIFY.AWALDATAUNIQUE** - Used by 1 views: `int_dev_awalspotify` **DEV_AWALSPOTIFY.AWALDISCOVERY04** - Used by 1 views: `int_dev_nsuzara_awal_discovery` **DEV_AWALSPOTIFY.AWALDISCOVERY_V04EBBA** - Used by 1 views: `int_dev_awalspotify_awaldiscovery_v04ebba` **DEV_AWALSPOTIFY.AWAL_MASTERISRC** - Used by 1 views: `int_dev_nsuzara_awaldata` **DEV_SKEELS.CM_DIM_COUNTRY** - Used by 1 views: `cm_dim_country` **DEV_TALLMAN.JORJA_SMITH_LOST_AND_FOUND_APPLE_PLAYLIST_AND_STORE_FIRST_7_DAYS** - Used by 1 views: `int_dev_tallman_JORJA_SMITH_LOST_AND_FOUND_APPLE_PLAYLIST_AND_STORE_FIRST_7_DAYS` **EIMPARA.FOURIERTABLE_FEB_SEPT_22** - Used by 1 views: `dev_eng_eimpara_FOURIERTABLE_FEB_SEPT_22` **EIMPARA.FOURIERTABLE_JUL_SEPT_22** - Used by 1 views: `dev_eng_eimpara_FOURIERTABLE_JUL_SEPT_22` **EIMPARA.MOMENTS_FOURIERTABLE_APR_SEPT_22_V2** - Used by 1 views: `dev_eng_eimpara_FOURIERTABLE_APR_SEPT_22` **PROD.ACTION** - Used by 1 views: `ows_conflict_manager_prod_action` **PROD.DIM_EDITORIAL_PLAYLIST_TOP_NON_EDITORIAL_PLAYLIST** - Used by 1 views: `int_prod_dim_editorial_playlist` **PROD.GLOBAL_PARTICIPANT_REPRESENTS_LABEL_PARTICIPANT** - Used by 1 views: `fact_prod_global_participant_represents_label_participant` **PROD.GLOBAL_SOUND_RECORDING** - Used by 1 views: `facts_prod_global_sound_recording` **PROD.LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_PRODUCT** - Used by 1 views: `fact_prod_label_participant_participated_in_orchard_product` **PROD.SPOTIFY_ARTIST** - Used by 1 views: `facts_prod_spotify_artist` **PROD.SPOTIFY_LABEL** - Used by 1 views: `facts_prod_spotify_label` **PROD.SPOTIFY_TRACK** - Used by 1 views: `facts_prod_spotify_track` **PROD.SPOTIFY_TRACK_ARTIST** - Used by 1 views: `facts_prod_spotify_track_artist` **PROD.STAGING_RAW_APPLE_MUSIC_FOOTER** - Used by 1 views: `facts_prod_staging_raw_apple_music_footer` **PROD.STAGING_RAW_APPLE_MUSIC_LINEAR_RADIO_SERVICE** - Used by 1 views: `facts_prod_staging_raw_apple_music_linear_radio_service` **PROD.STAGING_RAW_APPLE_MUSIC_ROYALTY_CALCULATION** - Used by 1 views: `facts_prod_staging_raw_apple_music_royalty_calculation` **PROD.STAGING_RAW_APPLE_MUSIC_SUMMARY** - Used by 1 views: `facts_prod_staging_raw_apple_music_summary` **PROD.STAGING_RAW_DEEZER_V3_FRAUD_REPORT** - Used by 1 views: `facts_prod_deezer_v3_fraud` **PROD.STAGING_RAW_INSTA_REELS_CREATIONS** - Used by 1 views: `facts_prod_staging_raw_insta_reels_creations` **PROD.STAGING_RAW_INSTA_REELS_VIEWS** - Used by 1 views: `facts_prod_staging_raw_insta_reels_views` **PROD.STAGING_RAW_MRC_ARTIST_METADATA** - Used by 1 views: `facts_prod_staging_raw_mrc_artist_mapping` **PROD.STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_SUMMARY_V1_1__MUSIC_SUMMARY** - Used by 1 views: `facts_prod_staging_raw_youtube_monthly_red_label_music_summary` **PROD.STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_SUMMARY_V1_1__NON_MUSIC_SUMMARY** - Used by 1 views: `facts_prod_staging_raw_youtube_monthly_red_label_non_music_summary` **PROD.STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_SUMMARY_V1_1__SUBSCRIBER_SUMMARY** - Used by 1 views: `facts_prod_staging_raw_youtube_monthly_red_label_subscriber_summary` **PROD.STAGING_RAW_YOUTUBE_MONTHLY_REPORT_V1_0__SUMMARY** - Used by 1 views: `facts_prod_staging_raw_youtube_monthly_report_v1_0_summary` **PROD.STAGING_RAW_YOUTUBE_MONTHLY_REPORT_V1_0__SUMMARY_BY_COUNTRY** - Used by 1 views: `facts_prod_staging_raw_youtube_monthly_report_v1_0_summary_by_country` **PROD.STAGING_RAW_YOUTUBE_MONTHLY_REPORT_V1_0__SUMMARY_BY_DAY** - Used by 1 views: `facts_prod_staging_raw_youtube_monthly_report_v1_0_summary_by_day` **PROD.TRACK_AUDIO_AND_RIGHTS_ATTRIBUTES** - Used by 1 views: `facts_prod_track_audio_and_rights_attributes` **PROD.VW_ABACUS_FACT_SALES_PUBLISHING** - Used by 1 views: `royalty_accounting_prod_vw_abacus_fact_sales_publishing` **PROD.VW_ABACUS_MANUAL_ADJUSTMENT** - Used by 1 views: `manual_adjustment` **PROD.VW_ABACUS_VENDOR_ACCOUNTING** - Used by 1 views: `orch_app_ar_vendor_accounting` **PROD.VW_DIM_ABACUS_AR_BOOKED_VENDOR_CONTRACT_SNAPSHOT** - Used by 1 views: `booked_vendor_contract_snapshot` **PROD.VW_WORKSTATION_SUMMARY_UNIFIED** - Used by 1 views: `facts_prod_vw_workstation_summary` **PROD.YOUTUBE_CLAIM_REPORT** - Used by 1 views: `facts_prod_staging_raw_youtube_claim` **PROD.fact_socials** - Used by 1 views: `facts_prod_fact_socials` **PROD_CONTENT_REVIEW_CONTENT_REVIEW.ACCOUNT_NOTE** - Used by 1 views: `orchard_app_reporting_v2_prod_content_review_content_review_account_note` **PROD_DDEX_INGESTER_DDEX_INGESTER.UPC_REMAP** - Used by 1 views: `orch_app_prod_ddex_ingester_upc_remap` **PROD_OWS_PODCAST_OWS_PODCAST.CATEGORY** - Used by 1 views: `orch_app_ar_dim_podcast_category` **PROD_OWS_PODCAST_OWS_PODCAST.PARTICIPANT** - Used by 1 views: `orch_app_ows_podcast_participant` **PROD_OWS_PRODUCT_STAGING_OWS_PRODUCT_STAGING.BULK_SESSIONS** - Used by 1 views: `orch_app_ar_bulk_session` **PROD_OWS_TIMED_RELEASE_OWS_TIMED_RELEASE_SCHEDULE.TIMED_RELEASES_STORE_LINKS** - Used by 1 views: `orch_app_ar_timed_releases_store_links` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.ACCOUNT_TAX_INFO** - Used by 1 views: `orch_app_royalty_account_tax_info` **PROD_SONY_METADATA_SONY_METADATA.FIELD_MANAGER** - Used by 1 views: `orch_app_sm_field_manager` **RAW_DATA.L_SPOTIFY_ARTIST** - Used by 1 views: `cm_raw_data_l_spotify_artist` **RAW_DATA.SPOTIFY_ARTIST_STAT** - Used by 1 views: `cm_raw_data_spotify_artist_stat` **SSAVVA.SPOTIFY_RELEASE_DATA** - Used by 1 views: `dev_eng_spotify_release_data` **analytics.instagram_audience_stat** - Used by 1 views: `cm_analytics_instagram_audience_stat` **analytics.tiktok_audience_stat** - Used by 1 views: `cm_analytics_tiktok_audience_stat` **analytics.youtube_audience_stat** - Used by 1 views: `cm_analytics_youtube_audience_stat` **art_relations_prod_art_relations.artist_info** - Used by 1 views: `orch_app_ar_artist_info` **art_relations_prod_art_relations.contact** - Used by 1 views: `orch_app_ar_contact` **art_relations_prod_art_relations.country** - Used by 1 views: `orch_app_ar_country` **art_relations_prod_art_relations.currencies** - Used by 1 views: `orch_app_ar_currencies` **art_relations_prod_art_relations.currency_exchange_rates** - Used by 1 views: `currency_exchange_rates` **art_relations_prod_art_relations.delivery_history** - Used by 1 views: `orch_app_ar_delivery_history` **art_relations_prod_art_relations.distribution_format** - Used by 1 views: `orch_app_ar_distribution_format` **art_relations_prod_art_relations.distribution_format_media** - Used by 1 views: `orch_app_ar_distribution_format_media` **art_relations_prod_art_relations.features** - Used by 1 views: `orch_app_ar_features` **art_relations_prod_art_relations.genre** - Used by 1 views: `orch_app_ar_genre` **art_relations_prod_art_relations.instrument** - Used by 1 views: `orch_app_ar_instrument` **art_relations_prod_art_relations.language** - Used by 1 views: `orch_app_ar_language` **art_relations_prod_art_relations.listening_notes_release** - Used by 1 views: `orch_app_ar_listening_notes_release` **art_relations_prod_art_relations.listening_notes_track** - Used by 1 views: `orch_app_ar_listening_notes_track` **art_relations_prod_art_relations.login_stat** - Used by 1 views: `orch_app_ar_login_stat` **art_relations_prod_art_relations.mfit_studio** - Used by 1 views: `orch_app_ar_mfit_studio` **art_relations_prod_art_relations.mkt_priority** - Used by 1 views: `orch_app_ar_mkt_priority` **art_relations_prod_art_relations.mood** - Used by 1 views: `orch_app_ar_mood` **art_relations_prod_art_relations.orchadmin_users** - Used by 1 views: `orch_app_ar_orchadmin_users` **art_relations_prod_art_relations.owner** - Used by 1 views: `orch_app_ar_owner` **art_relations_prod_art_relations.participant_external_link** - Used by 1 views: `orch_app_ar_participant_external_link` **art_relations_prod_art_relations.product_physical** - Used by 1 views: `orch_app_ar_product_physical` **art_relations_prod_art_relations.product_physical_change_history** - Used by 1 views: `orch_app_ar_product_physical_change_history` **art_relations_prod_art_relations.product_physical_packaging** - Used by 1 views: `orch_app_ar_product_physical_packaging` **art_relations_prod_art_relations.product_physical_supply_chain_info** - Used by 1 views: `orch_app_ar_product_physical_supply_chain_info` **art_relations_prod_art_relations.product_type** - Used by 1 views: `orch_app_ar_product_type` **art_relations_prod_art_relations.product_video** - Used by 1 views: `orch_app_ar_video_product` **art_relations_prod_art_relations.project** - Used by 1 views: `orch_app_ar_project` **art_relations_prod_art_relations.proper_stock_essn** - Used by 1 views: `orch_app_ar_proper_stock_essn` **art_relations_prod_art_relations.release_country_dates** - Used by 1 views: `orch_app_ar_release_country_dates` **art_relations_prod_art_relations.release_dms_master_restriction** - Used by 1 views: `release_dms_master_restriction` **art_relations_prod_art_relations.release_grid** - Used by 1 views: `orch_app_ar_release_grid` **art_relations_prod_art_relations.release_instrument** - Used by 1 views: `orch_app_ar_release_instrument` **art_relations_prod_art_relations.release_mfit_info** - Used by 1 views: `orch_app_ar_release_mfit_info` **art_relations_prod_art_relations.release_mood** - Used by 1 views: `orch_app_ar_release_mood` **art_relations_prod_art_relations.release_subgenre** - Used by 1 views: `orch_app_ar_release_subgenre` **art_relations_prod_art_relations.release_theme** - Used by 1 views: `orch_app_ar_release_theme` **art_relations_prod_art_relations.releases** - Used by 1 views: `orch_app_ar_releases` **art_relations_prod_art_relations.service_type** - Used by 1 views: `orch_app_ar_service_type` **art_relations_prod_art_relations.subaccount** - Used by 1 views: `orch_app_ar_subaccount` **art_relations_prod_art_relations.subgenre** - Used by 1 views: `orch_app_ar_subgenre` **art_relations_prod_art_relations.theme** - Used by 1 views: `orch_app_ar_theme` **art_relations_prod_art_relations.track_artist** - Used by 1 views: `orch_app_ar_track_artist` **art_relations_prod_art_relations.track_instant_grat** - Used by 1 views: `orch_app_ar_track_instant_grat` **art_relations_prod_art_relations.track_master_rights** - Used by 1 views: `orch_app_ar_track_master_rights` **art_relations_prod_art_relations.track_physical** - Used by 1 views: `orch_app_ar_track_physical` **art_relations_prod_art_relations.track_producer_nationality** - Used by 1 views: `orch_app_ar_track_producer_nationality` **art_relations_prod_art_relations.track_publisher** - Used by 1 views: `orch_app_ar_track_publisher` **art_relations_prod_art_relations.vend_contact** - Used by 1 views: `orch_app_ar_vend_contact` **art_relations_prod_art_relations.vend_contact_roles** - Used by 1 views: `orch_app_ar_vend_contact_roles` **art_relations_prod_art_relations.vendor_agreement** - Used by 1 views: `orch_app_ar_vendor_agreement` **art_relations_prod_art_relations.vendor_contract_change_history** - Used by 1 views: `orch_app_ar_vendor_contract_change_history` **art_relations_prod_art_relations.vendor_restricted_features** - Used by 1 views: `orch_app_ar_vendor_restricted_features` **art_relations_prod_art_relations.vendor_roles** - Used by 1 views: `orch_app_ar_vendor_roles` **art_relations_prod_art_relations.vendor_territory_restriction** - Used by 1 views: `orch_app_ar_vendor_territory_restriction` **art_relations_prod_art_relations.vendor_transaction_type_contract** - Used by 1 views: `orch_app_ar_vendor_transaction_type_contract` **art_relations_prod_art_relations.youtube_channel** - Used by 1 views: `orch_app_ar_youtube_channel` **art_relations_prod_art_relations.youtube_channel_video_status** - Used by 1 views: `orch_app_ar_youtube_channel_video_status` **artist_clustering.artist_geographic_recommendations** - Used by 1 views: `dev_eng_artist_clustering_artist_geo_rec` **artist_clustering.artist_similarity** - Used by 1 views: `dev_eng_artist_clustering_artist_similarity` **collections_sub_transactions** - Used by 1 views: `stmt_db_collections_sub_transactions` **collections_substores** - Used by 1 views: `stmt_db_collections_substores` **country** - Used by 1 views: `stmt_db_country` **customer_master_master** - Used by 1 views: `stmt_db_customer_master_master` **dbt_prod.abacus_adjustments** - Used by 1 views: `int_dbt_prod_abacus_adjustments` **dbt_prod.abacus_expenses** - Used by 1 views: `int_dbt_prod_abacus_expenses` **dbt_prod.accounting_analytics_blend_v2** - Used by 1 views: `int_prod_accounting_analytics_blend_v2` **dbt_prod.active_vendor_contracts** - Used by 1 views: `int_prod_vw_active_vendor_contract` **dbt_prod.agg_daily_amazon_download_model** - Used by 1 views: `int_dbt_prod_agg_daily_amazon_download_model` **dbt_prod.agg_daily_apple_download_model** - Used by 1 views: `int_dbt_prod_agg_daily_apple_download_model` **dbt_prod.agg_daily_beatport_download_model** - Used by 1 views: `int_dbt_prod_agg_daily_beatport_download_model` **dbt_prod.agg_daily_youtube_model** - Used by 1 views: `int_dbt_prod_agg_daily_youtube_model` **dbt_prod.all_signed_labels** - Used by 1 views: `all_signed_labels` **dbt_prod.amazon_engagement_groups_combined_with_user_info** - Used by 1 views: `amazon_engagement_groups_combined` **dbt_prod.apple_music_pitch_grid_specialist_genres** - Used by 1 views: `int_dbt_prod_apple_music_pitch_grid_specialist_genres` **dbt_prod.apple_spatial_audio_delivery_history** - Used by 1 views: `int_dbt_prod_apple_spatial_audio_deliveries` **dbt_prod.artist_services_pm_union** - Used by 1 views: `int_dbt_prod_product_manager_mapping_union` **dbt_prod.artist_socials_page_urls** - Used by 1 views: `int_dbt_prod_artist_socials_page_urls` **dbt_prod.artist_streaming_trends** - Used by 1 views: `int_dbt_prod_artist_streaming_trends` **dbt_prod.changes_by_country** - Used by 1 views: `int_dbt_prod_changes_by_country` **dbt_prod.cm_orchard_join** - Used by 1 views: `cm_orchard_join` **dbt_prod.daily_spikes_uk** - Used by 1 views: `int_prod_daily_spikes_uk` **dbt_prod.daily_spikes_us** - Used by 1 views: `int_prod_daily_spikes_us` **dbt_prod.daily_summary_downloads** - Used by 1 views: `int_dbt_prod_daily_summary_downloads` **dbt_prod.dt_access_filter_1091** - Used by 1 views: `dt_access_filter_1091` **dbt_prod.elementary_model_job_monitoring** - Used by 1 views: `elementary_model_job_monitoring_v1` **dbt_prod.fct_orchard_insights_top_streams_metrics_tiktok_by_label** - Used by 1 views: `int_dbt_prod_fct_orchard_insights_top_streams_metrics_tiktok_by_label` **dbt_prod.focus_track_pitch_grid** - Used by 1 views: `orch_app_ar_focus_track` **dbt_prod.kemado_all_time_streams** - Used by 1 views: `int_dbt_prod_kemado_all_time_streams` **dbt_prod.kemado_streams_last_18_months_releases** - Used by 1 views: `int_dbt_prod_kemado_streams_last_18_months_releases` **dbt_prod.label_anomalies_monthly** - Used by 1 views: `int_dbt_prod_label_anomalies_monthly` **dbt_prod.label_artist_monthly_ctc** - Used by 1 views: `int_dbt_prod_label_artist_monthly_ctc` **dbt_prod.label_country_monthly_ctc** - Used by 1 views: `int_dbt_prod_label_country_monthly_ctc` **dbt_prod.label_isrc_monthly_ctc** - Used by 1 views: `int_dbt_prod_label_isrc_monthly_ctc` **dbt_prod.label_source_monthly_ctc** - Used by 1 views: `int_dbt_prod_label_source_monthly_ctc` **dbt_prod.label_store_monthly_ctc** - Used by 1 views: `int_dbt_prod_label_store_monthly_ctc` **dbt_prod.label_upc_monthly_ctc** - Used by 1 views: `int_dbt_prod_label_upc_monthly_ctc` **dbt_prod.last_week_streamshare_model** - Used by 1 views: `stream_share_spotify_weekly` **dbt_prod.late_adds** - Used by 1 views: `int_dbt_prod_late_adds` **dbt_prod.latest_contracts** - Used by 1 views: `int_dbt_prod_latest_label_contracts` **dbt_prod.luminate_global_artist** - Used by 1 views: `int_dbt_prod_luminate_global_artist` **dbt_prod.luminate_global_isrc** - Used by 1 views: `int_dbt_prod_luminate_global_isrc` **dbt_prod.luminate_global_song** - Used by 1 views: `int_dbt_prod_luminate_global_song` **dbt_prod.orch_app_ar_track_track_physical_joined** - Used by 1 views: `orch_app_ar_track` **dbt_prod.orch_spotify_top_200_chart_appearances** - Used by 1 views: `int_dbt_prod_orch_spotify_top_200_chart_appearances` **dbt_prod.pitch_info_extraction** - Used by 1 views: `dbt_prod_pitch_info_extraction` **dbt_prod.playlist_model_amazon** - Used by 1 views: `int_dbt_prod_playlist_model_amazon` **dbt_prod.playlist_model_apple** - Used by 1 views: `int_dbt_prod_playlist_model_apple` **dbt_prod.playlist_model_spotify** - Used by 1 views: `int_dbt_prod_playlist_model_spotify` **dbt_prod.qa_abacus_adjustments** - Used by 1 views: `int_dbt_prod_qa_abacus_adjustments` **dbt_prod.qa_abacus_expenses** - Used by 1 views: `int_dbt_prod_qa_abacus_expenses` **dbt_prod.restrictions_label_substore** - Used by 1 views: `int_prod_vw_restrictions_label_substore` **dbt_prod.restrictions_label_territory** - Used by 1 views: `int_prod_vw_restrictions_label_territory` **dbt_prod.restrictions_release_substore** - Used by 1 views: `int_prod_vw_restrictions_release_substore` **dbt_prod.restrictions_release_territory** - Used by 1 views: `int_prod_vw_restrictions_release_territory` **dbt_prod.restrictions_subaccount_substore** - Used by 1 views: `int_prod_vw_restrictions_subaccount_substore` **dbt_prod.restrictions_subaccount_territory** - Used by 1 views: `int_prod_vw_restrictions_subaccount_territory` **dbt_prod.revenue_apple_amazon_ex_spatial_deliveries** - Used by 1 views: `int_dbt_prod_revenue_apple_amazon_ex_spatial_deliveries` **dbt_prod.ritmogestion_label_countries** - Used by 1 views: `facts_prod_staging_raw_ritmogestion` **dbt_prod.sme_latam_weekly_chart_orch_flag** - Used by 1 views: `facts_prod_staging_raw_sme_latam_weekly_unified_chart` **dbt_prod.spotify_3rd_party_playlist_spt_last_week** - Used by 1 views: `int_dbt_prod_spotify_3rd_party_playlist_spt_last_week` **dbt_prod.spotify_editorial_playlist_legacy_playlist_metric** - Used by 1 views: `int_dbt_prod_spotify_editorial_playlist_legacy_playlist_metric` **dbt_prod.spotify_editorial_playlist_metric_rollup** - Used by 1 views: `int_dbt_prod_spotify_editorial_playlist_metric_rollup` **dbt_prod.spotify_editorial_playlist_update_groups** - Used by 1 views: `int_dbt_prod_spotify_editorial_playlist_update_groups` **dbt_prod.spotify_engagement_groups_combined_with_user_info** - Used by 1 views: `spotify_engagement_groups_combined_with_user_info` **dbt_prod.spotify_fraudulent_fact_sales_combined** - Used by 1 views: `int_dbt_prod_spotify_fraudulent_fact_sales_combined` **dbt_prod.spotify_playlist_downstream_impact_6_month_avg** - Used by 1 views: `int_dbt_prod_spotify_playlist_downstream_impact_6_month_avg` **dbt_prod.spotify_playlist_post_discovery_streaming_6_month_avg** - Used by 1 views: `int_dbt_prod_spotify_playlist_post_discovery_streaming_6_month_avg` **dbt_prod.spotify_top_200_predictions_weekly** - Used by 1 views: `dbt_prod_spotify_top_200_predictions_weekly` **dbt_prod.spotify_top_200_vs_orchard_distributed_content_streams** - Used by 1 views: `int_dbt_prod_spotify_top_200_vs_orchard_distributed_content_streams` **dbt_prod.spotify_weekly_market_share_by_country** - Used by 1 views: `spotify_market_share_week_ending` **dbt_prod.stg_cm_spotify_artist_stat_clean** - Used by 1 views: `int_dbt_prod_cm_spotify_artist_stat_clean` **dbt_prod.stg_ifpi_transaction_country_report_filterable** - Used by 1 views: `int_dbt_prod_transaction_country_report_filterable` **dbt_prod.store_genre_subgenre_mappings** - Used by 1 views: `int_prod_store_genre_subgenre_mapping` **dbt_prod.tier_3_label_analysis** - Used by 1 views: `int_dbt_prod_tier_3_label_analysis` **dbt_prod.tiktok_pitch_grid** - Used by 1 views: `tiktok_pitch_grid_us` **dbt_prod.top_content_daily_editorial_streams_rollup** - Used by 1 views: `top_content_daily_editorial_streams` **dbt_prod.tsz_custom** - Used by 1 views: `tsz_custom` **dbt_prod.video_combined_intermediate** - Used by 1 views: `int_dbt_prod_video_combined_intermediate` **dbt_prod.weekly_spikes_africa** - Used by 1 views: `int_dbt_prod_weekly_spikes_africa` **dbt_prod.weekly_spikes_japan** - Used by 1 views: `int_dbt_prod_weekly_spikes_japan` **dbt_prod.weekly_spikes_uk** - Used by 1 views: `int_prod_weekly_spikes_uk` **dbt_prod.weekly_spikes_us** - Used by 1 views: `int_prod_weekly_spikes_us` **dbt_prod.weekly_trending_genres_spotify** - Used by 1 views: `int_dbt_prod_weekly_trending_genres_spotify` **dbt_prod.weekly_trending_tracks_amazon** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_amazon` **dbt_prod.weekly_trending_tracks_amazon_collection_streams** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_amazon_collection` **dbt_prod.weekly_trending_tracks_amazon_lean_fwd_streams** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_amazon_lean_fwd` **dbt_prod.weekly_trending_tracks_amazon_long_tail** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_amazon_long_tail` **dbt_prod.weekly_trending_tracks_amazon_user_playlist_streams** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_amazon_user_playlist` **dbt_prod.weekly_trending_tracks_apple** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_apple` **dbt_prod.weekly_trending_tracks_apple_discovery_streams** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_apple_discovery_streams` **dbt_prod.weekly_trending_tracks_apple_library_streams** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_apple_library_streams` **dbt_prod.weekly_trending_tracks_apple_long_tail** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_apple_long_tail` **dbt_prod.weekly_trending_tracks_apple_search_streams** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_apple_search_streams` **dbt_prod.weekly_trending_tracks_apple_voice_streams** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_apple_voice_streams` **dbt_prod.weekly_trending_tracks_spotify** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_uk_spotify` **dbt_prod.weekly_trending_tracks_spotify_3rdparty_and_user_playlists_streams** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist` **dbt_prod.weekly_trending_tracks_spotify_collection_streams** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_uk_spotify_collection` **dbt_prod.weekly_trending_tracks_spotify_lean_fwd_streams** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd` **dbt_prod.weekly_trending_tracks_spotify_long_tail** - Used by 1 views: `int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail` **dbt_prod.westcott_daily_schedules** - Used by 1 views: `int_dbt_prod_westcott_daily_schedules` **dbt_prod.westcott_schedules_cumulative_units** - Used by 1 views: `int_dbt_prod_westcott_schedules_cumulative_units` **dbt_prod.youtube_partnered_channels** - Used by 1 views: `int_dbt_prod_youtube_partnered_channels` **dbt_prod_project_moments.hedra_output** - Used by 1 views: `project_moments_hedra_output_table` **dbt_prod_project_moments.hedra_output_140_days** - Used by 1 views: `project_moments_hedra_output_140_days_table` **dbt_prod_project_moments.project_moments_track_groupings_info** - Used by 2 views: `int_dbt_prod_project_moments_track_groupings_info`, `int_dev_tallman_moments_performance_groups_v1` **dbt_prod_seed_data.apple_vendor_map** - Used by 1 views: `int_dbt_prod_seed_data_apple_vendor_map` **dbt_prod_seed_data.transaction_type_group** - Used by 1 views: `int_prod_transaction_type_group` **dbt_prod_strategy.spotify_charting_combined** - Used by 1 views: `facts_prod_spotify_chart` **dev.fact_youtube_estimated_revenue_by_asset** - Used by 1 views: `int_dev_fact_yt_estimated_revenue_by_asset` **dev.fact_youtube_traffic_source_by_asset** - Used by 1 views: `int_dev_fact_yt_traffic_source_by_asset` **dev.fact_youtube_user_activity_by_asset** - Used by 1 views: `int_dev_fact_yt_user_activity_by_asset` **dev.owned_and_operated_artist_royalty_rates** - Used by 1 views: `int_dev_smoore_o_o` **dev_jlafyatis.youtube_asset_mapping** - Used by 1 views: `int_dev_jlafyatis_youtube_asset_mapping` **dev_sgraig.sme_latam_distributor** - Used by 1 views: `int_dev_sgraig_sme_latam_distributor` **dev_skeels.yt_channel_mapping** - Used by 1 views: `int_dev_skeels_youtube_channel_mappings` **dev_smoore.spotify_owner_mappings** - Used by 1 views: `int_dev_smoore_spotify_owner_mappings` **dev_tallman.JORJA_SMITH_FALLING_OR_FLYING_AMAZON_FIRST_7_DAYS** - Used by 1 views: `int_dev_tallman_JORJA_SMITH_FALLING_OR_FLYING_AMAZON_FIRST_7_DAYS` **dev_tallman.JORJA_SMITH_FALLING_OR_FLYING_APPLE_PLAYLIST_FIRST_7_DAYS** - Used by 1 views: `int_dev_tallman_JORJA_SMITH_FALLING_OR_FLYING_APPLE_PLAYLIST_FIRST_7_DAYS` **dev_tallman.JORJA_SMITH_FALLING_OR_FLYING_APPLE_STORE_FIRST_7_DAYS** - Used by 1 views: `int_dev_tallman_JORJA_SMITH_FALLING_OR_FLYING_APPLE_STORE_FIRST_7_DAYS` **dev_tallman.JORJA_SMITH_FALLING_OR_FLYING_SPOTIFY_FIRST_7_DAYS** - Used by 1 views: `int_dev_tallman_JORJA_SMITH_FALLING_OR_FLYING_SPOTIFY_FIRST_7_DAYS` **dev_tallman.JORJA_SMITH_LOST_AND_FOUND_AMAZON_FIRST_7_DAYS** - Used by 1 views: `int_dev_tallman_JORJA_SMITH_LOST_AND_FOUND_AMAZON_FIRST_7_DAYS` **dev_tallman.JORJA_SMITH_LOST_AND_FOUND_SPOTIFY_FIRST_7_DAYS** - Used by 1 views: `int_dev_tallman_JORJA_SMITH_LOST_AND_FOUND_SPOTIFY_FIRST_7_DAYS` **dig_sales_analytics** - Used by 1 views: `stmt_db_dig_sales_analytics` **dig_sales_period_id** - Used by 1 views: `stmt_db_dig_sales_period_id` **eimpara.MOMENTS_140DAYS_K_PROTO_V4_COPY** - Used by 1 views: `moments_140_days_k_proto_v3_copy` **eimpara.SUBSET_ARIMA_2023_DATA** - Used by 1 views: `SUBSET_ARIMA_2023_DATA` **eimpara.SUBSET_FOURIER_2023_DATA** - Used by 1 views: `SUBSET_FOURIER_2023_DATA` **eimpara.SUBSET_MANUALCLUSTERING_2023_DATA** - Used by 1 views: `SUBSET_MANUALCLUSTERING_2023_DATA` **eimpara.SUBSET_PREDICTED_VALUES_2023_DATA** - Used by 1 views: `SUBSET_PREDICTED_VALUES_2023_DATA` **events_streams.listener_behavior_by_release** - Used by 1 views: `dev_eng_events_streams_listener_behavior_by_release` **mrc.data** - Used by 1 views: `orch_app_mrc_data` **my_schema_name.tester** - Used by 2 views: `int_prod_vw_internal_conflicts`, `orch_app_ar_product_distribution` **nsnyder.sme_lat_long_to_dma** - Used by 1 views: `dev_eng_nsnyder_sme_lat_long_to_dma` **period_id** - Used by 1 views: `stmt_db_period_id` **pl_categories** - Used by 1 views: `stmt_db_pl_categories` **pl_storelist** - Used by 1 views: `stmt_db_pl_storelist` **prod.CDSUS_BILLING_HISTORY** - Used by 1 views: `sony_internal_prod_cdsus_billing_history` **prod.RECENT_PLACEMENTS_BY_TRACK_PLAYLIST_COUNTRY_FEED_ROLLUP_DBT** - Used by 1 views: `facts_prod_recent_placements_by_track_playlist_country_feed_rollup` **prod.accounting_analytics_blend** - Used by 1 views: `int_prod_accounting_analytics_blend` **prod.aggregated_skips_and_saves** - Used by 1 views: `facts_prod_aggregated_skips_and_saves` **prod.analytics_report_full** - Used by 1 views: `int_prod_analytics_report_full` **prod.apg_apple_pitch_grid** - Used by 1 views: `int_prod_apg_apple_pitch_grid` **prod.apple_id_mapping** - Used by 1 views: `facts_prod_apple_id_mapping` **prod.apple_music_container_subtype_mapping** - Used by 1 views: `facts_prod_apple_music_container_subtype_mapping` **prod.apple_music_shazam_daily_events** - Used by 1 views: `facts_prod_apple_music_shazam_daily_events` **prod.avg_units_by_genre_store_country_daily** - Used by 1 views: `dt_genre_benchmarking` **prod.bits_per_sample** - Used by 1 views: `int_prod_vw_bits_per_sample` **prod.cdsus_product** - Used by 1 views: `sony_internal_prod_cdsus_product` **prod.chartable_podcast_ranking_peaks** - Used by 1 views: `facts_prod_chartable_podcast_ranking_peaks` **prod.chartable_podcast_rankings** - Used by 1 views: `facts_prod_chartable_podcast_rankings` **prod.chartmetric_charts_log** - Used by 1 views: `facts_prod_chartmetric_charts` **prod.chartmetric_socials_log** - Used by 1 views: `facts_prod_chartmetric_socials` **prod.cm_url_backfill** - Used by 1 views: `facts_prod_cm_url_backfill` **prod.compilation_takedowns** - Used by 1 views: `int_prod_compilation_takedowns` **prod.daily_top_content** - Used by 1 views: `int_prod_daily_top_content` **prod.date_definitions** - Used by 1 views: `int_prod_date_definitions` **prod.demographics_region_mapping_v2** - Used by 2 views: `facts.prod.demographics_region_mapping_v2`, `facts_prod_demographics_region_mapping_v2` **prod.dim_ad** - Used by 1 views: `facts_prod_dim_ad` **prod.dim_artist** - Used by 1 views: `facts_prod_dim_artist` **prod.dim_brand** - Used by 1 views: `facts_prod_dim_brand` **prod.dim_canonical_track_metadata** - Used by 1 views: `facts_prod_dim_canonical_track_metadata` **prod.dim_catalog** - Used by 1 views: `facts_prod_dim_catalog` **prod.dim_containertype** - Used by 1 views: `facts_prod_dim_containertype` **prod.dim_country** - Used by 1 views: `facts_prod_dim_country` **prod.dim_currency** - Used by 1 views: `facts_prod_dim_currency` **prod.dim_day** - Used by 1 views: `facts_prod_dim_day` **prod.dim_device** - Used by 1 views: `facts_prod_dim_device` **prod.dim_feed** - Used by 1 views: `facts_prod_dim_feed` **prod.dim_format** - Used by 1 views: `facts_prod_dim_format` **prod.dim_genre** - Used by 1 views: `facts_prod_dim_genre` **prod.dim_imprint** - Used by 1 views: `facts_prod_dim_imprint` **prod.dim_isrc** - Used by 1 views: `facts_prod_dim_isrc` **prod.dim_label** - Used by 1 views: `facts_prod_dim_label` **prod.dim_licensor** - Used by 1 views: `facts_prod_dim_licensor` **prod.dim_os** - Used by 1 views: `facts_prod_dim_os` **prod.dim_owner** - Used by 1 views: `facts_prod_dim_owner` **prod.dim_period** - Used by 1 views: `facts_prod_dim_period` **prod.dim_playback** - Used by 2 views: `facts_prod_dim_claim`, `facts_prod_dim_playback` **prod.dim_playlist** - Used by 1 views: `facts_prod_dim_playlist` **prod.dim_release** - Used by 1 views: `facts_prod_dim_release` **prod.dim_sharingservice** - Used by 1 views: `facts_prod_dim_sharingservice` **prod.dim_sourcetype** - Used by 1 views: `facts_prod_dim_sourcetype` **prod.dim_store** - Used by 2 views: `fact_prod_dim_store_timed_release`, `facts_prod_dim_store` **prod.dim_subaccount** - Used by 1 views: `facts_prod_dim_subaccount` **prod.dim_subscriptionpaytier** - Used by 1 views: `facts_prod_dim_subscriptionpaytier` **prod.dim_subscriptiontype** - Used by 1 views: `facts_prod_dim_subscriptiontype` **prod.dim_track** - Used by 1 views: `facts_prod_dim_track` **prod.dim_trafficsource** - Used by 1 views: `facts_prod_dim_trafficsource` **prod.dim_transactiontype** - Used by 1 views: `facts_prod_dim_transactiontype` **prod.dim_user** - Used by 1 views: `facts_prod_dim_user` **prod.dim_youtube_channel_names** - Used by 1 views: `facts_prod_dim_youtube_channel_names` **prod.distribution_format_proper_mapping** - Used by 1 views: `int_prod_distribution_format_proper_mapping` **prod.fact_analytics** - Used by 3 views: `facts_prod_fact_analytics_v2`, `facts_prod_fact_analytics`, `facts_prod_fact_analytics_for_master_calendar` **prod.fact_analytics_2020** - Used by 1 views: `int_prod_fact_analytics_2020` **prod.fact_conflict** - Used by 1 views: `facts_prod_fact_conflict` **prod.fact_market_share** - Used by 1 views: `facts_prod_fact_market_share` **prod.fact_youtube_asset_analytics** - Used by 1 views: `facts_prod_fact_youtube_asset_analytics` **prod.fact_youtube_asset_demographics** - Used by 1 views: `facts_prod_fact_youtube_asset_demographics` **prod.fact_youtube_video_analytics** - Used by 1 views: `facts_prod_fact_youtube_video_analytics` **prod.fact_youtube_video_demographics** - Used by 1 views: `facts_prod_fact_youtube_video_demographics` **prod.featuring_artists_track_release** - Used by 1 views: `int_prod_vw_featuring_artists_track_release` **prod.genre_streaming_by_day** - Used by 1 views: `dt_genre_benchmarking_streams_by_day` **prod.gracenote_album_edition** - Used by 1 views: `int_prod_gracenote_album_edition` **prod.gracenote_album_edition_track** - Used by 1 views: `int_prod_gracenote_album_edition_track` **prod.gracenote_album_master** - Used by 1 views: `int_prod_gracenote_album_master` **prod.gracenote_artist** - Used by 1 views: `int_prod_gracenote_artist` **prod.gracenote_artist_alternate_name** - Used by 1 views: `int_prod_gracenote_artist_alternate_name` **prod.gracenote_artist_name_variant** - Used by 1 views: `int_prod_gracenote_artist_name_variant` **prod.gracenote_descriptor_artist_type** - Used by 1 views: `int_prod_gracenote_descriptor_artist_type` **prod.gracenote_descriptor_era** - Used by 1 views: `int_prod_gracenote_descriptor_era` **prod.gracenote_descriptor_genre** - Used by 1 views: `int_prod_gracenote_descriptor_genre` **prod.gracenote_descriptor_language** - Used by 1 views: `int_prod_gracenote_descriptor_language` **prod.gracenote_descriptor_mood** - Used by 1 views: `int_prod_gracenote_descriptor_mood` **prod.gracenote_descriptor_origin** - Used by 1 views: `int_prod_gracenote_descriptor_origin` **prod.gracenote_descriptor_script** - Used by 1 views: `int_prod_gracenote_descriptor_script` **prod.gracenote_descriptor_style** - Used by 1 views: `int_prod_gracenote_descriptor_style` **prod.gracenote_descriptor_tempo** - Used by 1 views: `int_prod_gracenote_descriptor_tempo` **prod.gracenote_recording** - Used by 1 views: `int_prod_gracenote_recording` **prod.gracenote_recording_product_code** - Used by 1 views: `int_prod_gracenote_recording_product_code` **prod.gracenote_song** - Used by 1 views: `int_prod_gracenote_song` **prod.itunes_ticket_defect_codes** - Used by 1 views: `facts_prod_itunes_ticket_defect_codes` **prod.itunes_ticket_notes** - Used by 1 views: `facts_prod_itunes_ticket_notes` **prod.itunes_ticket_severity_mapping** - Used by 1 views: `int_prod_itunes_ticket_severity_mapping` **prod.itunes_tickets** - Used by 1 views: `facts_prod_itunes_tickets` **prod.l_global_participant_label_participant** - Used by 1 views: `facts_prod_l_global_participant_label_participant` **prod.median_units_by_genre_store_country_daily** - Used by 1 views: `dt_genre_benchmarking_median` **prod.metrics_by_channel_country_feed_distributor_rollup** - Used by 1 views: `facts_prod_metrics_by_channel_country_feed_distributor_rollup` **prod.orchard_monthly_sap_aggregate_feed_history** - Used by 1 views: `sony_internal_prod_orchard_monthly_sap_aggregate_feed_history` **prod.orchard_product** - Used by 1 views: `facts_prod_orchard_product` **prod.orchard_track** - Used by 1 views: `facts_prod_orchard_track` **prod.physical_accounting_all_sales** - Used by 1 views: `int_prod_physical_accounting_all_sales` **prod.playlist_completion_rate** - Used by 1 views: `int_prod_playlist_completion_rate` **prod.ppl_sales_stmt** - Used by 1 views: `prs_prod_ppl_sales` **prod.product_physical_packaging_proper_mapping** - Used by 1 views: `int_prod_product_physical_packaging_proper_mapping` **prod.profile** - Used by 1 views: `fact_prod_profile` **prod.publishing_agreement** - Used by 1 views: `facts_prod_publishing_agreement` **prod.publishing_composition** - Used by 1 views: `facts_prod_publishing_composition` **prod.publishing_has_agreement** - Used by 1 views: `facts_prod_publishing_has_agreement` **prod.publishing_has_composition** - Used by 1 views: `facts_prod_publishing_has_composition` **prod.publishing_has_pub_share** - Used by 1 views: `facts_prod_publishing_has_pub_share` **prod.publishing_has_signed_writer** - Used by 1 views: `facts_prod_publishing_has_signed_writer` **prod.publishing_has_sound_recording** - Used by 1 views: `facts_prod_publishing_has_sound_recording` **prod.publishing_has_writer_share** - Used by 1 views: `facts_prod_publishing_has_writer_share` **prod.publishing_publisher** - Used by 1 views: `facts_prod_publishing_publisher` **prod.publishing_song_writer** - Used by 1 views: `facts_prod_publishing_song_writer` **prod.registry_audit** - Used by 1 views: `facts_prod_registry_audit` **prod.registry_locked** - Used by 1 views: `facts_prod_registry_locked` **prod.release_content_validation_agg** - Used by 1 views: `int_prod_vw_release_content_validation_agg` **prod.release_delivery_history** - Used by 1 views: `int_prod_vw_release_delivery_history` **prod.rsd_release_schedule_dashboard** - Used by 1 views: `int_prod_rsd_release_schedule_dashboard` **prod.social_spike_stats** - Used by 1 views: `facts_prod_social_spike_stats` **prod.soundexchange_sales_stmt** - Used by 1 views: `prs_prod_sx_sales` **prod.spotify_tracks** - Used by 1 views: `facts_prod_spotify_tracks` **prod.staging_raw_amazon_unlimited** - Used by 1 views: `facts_prod_staging_raw_amazon_unlimited` **prod.staging_raw_apple_music_container** - Used by 1 views: `facts_prod_apple_music_container_summary` **prod.staging_raw_megaphone** - Used by 1 views: `facts_prod_staging_raw_megaphone` **prod.staging_raw_membran** - Used by 1 views: `facts_prod_staging_raw_membran` **prod.staging_raw_mrc** - Used by 1 views: `facts_prod_staging_raw_mrc` **prod.staging_raw_pandora** - Used by 1 views: `facts_prod_staging_raw_pandora` **prod.staging_raw_shazam** - Used by 1 views: `facts_prod_staging_raw_shazam` **prod.staging_raw_tiktok_trends_tophashtag** - Used by 1 views: `facts_prod_staging_raw_tiktok_trends_tophashtag` **prod.staging_raw_tiktok_trends_topsong** - Used by 1 views: `facts_prod_staging_raw_tiktok_trends_topsong` **prod.staging_raw_youtube_asset_report** - Used by 1 views: `facts_prod_staging_raw_youtube_asset_report` **prod.staging_raw_youtube_monthly_claim_raw_v1_1** - Used by 1 views: `facts_prod_staging_raw_youtube_monthly_claim` **prod.staging_raw_youtube_video_report** - Used by 1 views: `facts_prod_staging_raw_youtube_video_report` **prod.store_ppr_v2** - Used by 1 views: `int_prod_store_ppr` **prod.summary_sos** - Used by 1 views: `facts_prod_summary_sos` **prod.territory_grouping_v2** - Used by 1 views: `int_prod_territory_grouping` **prod.test_pipenv** - Used by 1 views: `zzz_sync_int_prod_test_pipenv` **prod.track_content_validation_agg** - Used by 1 views: `int_prod_vw_track_content_validation_agg` **prod.track_explicit_content** - Used by 1 views: `int_prod_vw_track_explicit_content` **prod.us_states** - Used by 1 views: `int_prod_us_states` **prod.vw_artist_identifer** - Used by 1 views: `int_prod_vw_artist_identifier` **prod.vw_deleted_labels** - Used by 1 views: `int_prod_vw_deleted_labels` **prod.vw_dim_abacus_ar_vendor** - Used by 2 views: `orch_app_ar_vendor`, `vendor` **prod.vw_dim_abacus_ar_vendor_contract** - Used by 2 views: `vendor_contract_snowflake_original`, `orch_app_ar_vendor_contract` **prod.vw_performance_rights_delivery_history** - Used by 1 views: `int_prod_vw_performance_rights_delivery_history` **prod.workstation_fact_sales_unified_dbt** - Used by 1 views: `facts_prod_fact_sales` **prod.youtube_video** - Used by 1 views: `facts_prod_youtube_video` **prod.yt_video_report_orchard_metadata** - Used by 1 views: `int_prod_vw_yt_video_report_orchard_metadata` **prod_ows_accounting_payment_holds.vendor_payment_hold** - Used by 1 views: `orch_app_ph_vendor_payment_hold` **prod_ows_podcast_ows_podcast.episode** - Used by 1 views: `orch_app_ows_pod_episode` **prod_ows_podcast_ows_podcast.episode_link** - Used by 1 views: `orch_app_ows_pod_episode_link` **prod_ows_podcast_ows_podcast.network** - Used by 1 views: `orch_app_ows_pod_network` **prod_ows_podcast_ows_podcast.podcast** - Used by 1 views: `orch_app_ows_pod_podcast` **prod_ows_podcast_ows_podcast.show_family** - Used by 1 views: `orch_app_ows_pod_show_family` **prod_ows_pricing_pricing.product_store_effective_price_code** - Used by 1 views: `orch_app_pricing_product_store_effective_price_code` **prod_ows_timed_release_ows_timed_release_schedule.TIMED_RELEASE** - Used by 1 views: `orchard_app_reporting_v2_prod_ows02_ows_timed_release_schedule_timed_release` **prod_physical_reporting.staging_raw_proper_stock** - Used by 1 views: `orchard_app_reporting_v2_prod_physical_reporting_staging_raw_proper_stock` **prod_physical_reporting.staging_raw_proper_stock_movements** - Used by 1 views: `orchard_app_reporting_v2_prod_physical_reporting_staging_raw_proper_stock_movements` **prod_promo_player_promo_player.promo_player** - Used by 1 views: `orch_app_promo_player` **prod_sales_goals_sales_goals.digital_marketing_projections** - Used by 1 views: `orch_app_sales_goals_digital_marketing_projections` **prod_sales_goals_sales_goals.digital_marketing_projections_by_country** - Used by 1 views: `orch_app_sales_goals_digital_marketing_projections_by_country` **prod_sales_goals_sales_goals.digital_marketing_projections_by_country_for_store** - Used by 1 views: `orch_app_sales_goals_digital_marketing_projections_by_country_for_store` **prod_sales_goals_sales_goals.digital_marketing_projections_for_store** - Used by 1 views: `orch_app_sales_goals_digital_marketing_projections_for_store` **prod_sales_goals_sales_goals.digital_stores** - Used by 1 views: `orch_app_sales_goals_digital_stores` **prod_sales_goals_sales_goals.sales_goal** - Used by 1 views: `orch_app_sales_goals_sales_goal` **prod_sales_goals_sales_goals.sales_goals_for_country** - Used by 1 views: `orch_app_sales_goals_sales_goals_for_country` **prod_sales_goals_sales_goals.store** - Used by 1 views: `orch_app_sales_goals_store` **prod_sales_goals_sales_goals.target_market_goal** - Used by 1 views: `orch_app_sg_target_market_goal` **raw_data.amazon** - Used by 1 views: `cm_raw_data_amazon` **raw_data.amazon_chart** - Used by 1 views: `cm_raw_data_amazon_chart` **raw_data.amazon_playlist** - Used by 1 views: `cm_raw_data_amazon_playlist` **raw_data.amazon_playlist_stat** - Used by 1 views: `cm_raw_data_amazon_playlist_stat` **raw_data.apple_music_daily_top_chart** - Used by 1 views: `cm_raw_data_apple_music_daily_top_chart` **raw_data.cm_artist** - Used by 1 views: `cm_raw_data_cm_artist` **raw_data.cm_track** - Used by 1 views: `cm_raw_data_cm_track` **raw_data.cm_url** - Used by 1 views: `cm_raw_data_cm_url` **raw_data.deezer** - Used by 1 views: `cm_raw_data_deezer` **raw_data.deezer_chart** - Used by 1 views: `cm_raw_data_deezer_daily_top_chart` **raw_data.deezer_playlist** - Used by 1 views: `cm_raw_data_deezer_playlist` **raw_data.deezer_playlist_stat** - Used by 1 views: `cm_raw_data_deezer_playlist_stat` **raw_data.facebook_stat** - Used by 1 views: `cm_raw_data_facebook_stat` **raw_data.instagram_stat** - Used by 1 views: `cm_raw_data_instagram_stat` **raw_data.itunes** - Used by 1 views: `cm_raw_data_itunes` **raw_data.itunes_chart** - Used by 1 views: `cm_raw_data_itunes_chart` **raw_data.itunes_playlist** - Used by 1 views: `cm_raw_data_itunes_playlist` **raw_data.itunes_playlist_stat** - Used by 1 views: `cm_raw_data_itunes_playlist_stat` **raw_data.l_amazon_playlist** - Used by 1 views: `cm_raw_data_l_amazon_playlist` **raw_data.l_amazon_playlist_history** - Used by 1 views: `cm_raw_data_l_amazon_playlist_history` **raw_data.l_amazon_playlist_stat** - Used by 1 views: `cm_raw_data_l_amazon_playlist_stat` **raw_data.l_cm_track_cm_album** - Used by 1 views: `cm_raw_data_l_cm_track_cm_album` **raw_data.l_cm_track_cm_artist** - Used by 1 views: `cm_raw_data_l_cm_track_cm_artist` **raw_data.l_deezer_playlist** - Used by 1 views: `cm_raw_data_l_deezer_playlist` **raw_data.l_deezer_playlist_history** - Used by 1 views: `cm_raw_data_l_deezer_playlist_history` **raw_data.l_deezer_playlist_stat** - Used by 1 views: `cm_raw_data_l_deezer_playlist_stat` **raw_data.l_itunes_playlist** - Used by 1 views: `cm_raw_data_l_itunes_playlist` **raw_data.l_itunes_playlist_history** - Used by 1 views: `cm_raw_data_l_itunes_playlist_history` **raw_data.l_itunes_playlist_stat** - Used by 1 views: `cm_raw_data_l_itunes_playlist_stat` **raw_data.l_spotify_playlist** - Used by 1 views: `cm_raw_data_l_spotify_playlist` **raw_data.l_spotify_playlist_history** - Used by 1 views: `cm_raw_data_l_spotify_playlist_history` **raw_data.l_spotify_playlist_stat** - Used by 1 views: `cm_raw_data_l_spotify_playlist_stat` **raw_data.l_youtube_playlist** - Used by 1 views: `cm_raw_data_l_youtube_playlist` **raw_data.l_youtube_playlist_history** - Used by 1 views: `cm_raw_data_l_youtube_playlist_history` **raw_data.l_youtube_playlist_stat** - Used by 1 views: `cm_raw_data_l_youtube_playlist_stat` **raw_data.shazam** - Used by 1 views: `cm_raw_data_shazam` **raw_data.shazam_chart** - Used by 1 views: `cm_raw_data_shazam_chart` **raw_data.spotify** - Used by 1 views: `cm_raw_data_spotify` **raw_data.spotify_album** - Used by 1 views: `cm_raw_data_spotify_album` **raw_data.spotify_chart** - Used by 1 views: `cm_raw_data_spotify_chart` **raw_data.spotify_playlist** - Used by 2 views: `cm_raw_data_spotify_playlist_stat`, `cm_raw_data_spotify_playlist` **raw_data.tiktok** - Used by 1 views: `cm_raw_data_tiktok` **raw_data.tiktok_stat** - Used by 1 views: `cm_raw_data_tiktok_stat` **raw_data.tiktok_user** - Used by 1 views: `cm_raw_data_tiktok_user` **raw_data.tiktok_user_stat** - Used by 1 views: `cm_raw_data_tiktok_user_stat` **raw_data.twitter_stat** - Used by 1 views: `cm_raw_data_twitter_stat` **raw_data.youtube** - Used by 1 views: `cm_raw_data_youtube` **raw_data.youtube_artist_chart** - Used by 1 views: `cm_raw_data_youtube_artist_chart` **raw_data.youtube_playlist** - Used by 1 views: `cm_raw_data_youtube_playlist` **raw_data.youtube_playlist_stat** - Used by 1 views: `cm_raw_data_youtube_playlist_stat` **raw_data.youtube_track_chart** - Used by 1 views: `cm_raw_data_youtube_track_chart` **reportsdd_direct_delivery.asset** - Used by 1 views: `orch_app_dd_asset` **reportsdd_direct_delivery.asset_location** - Used by 1 views: `orch_app_dd_asset_location` **reportsdd_direct_delivery.asset_location_detail** - Used by 1 views: `orch_app_dd_asset_location_detail` **reportsdd_direct_delivery.asset_type** - Used by 1 views: `orch_app_dd_asset_type` **reportsdd_direct_delivery.delivery_batch** - Used by 1 views: `orch_app_dd_delivery_batch` **reportsdd_direct_delivery.delivery_batch_detail** - Used by 1 views: `orch_app_dd_delivery_batch_detail` **reportsdd_direct_delivery.dms_delivery_spec** - Used by 1 views: `orch_app_dd_dms_delivery_spec` **reportsdd_direct_delivery.dms_encoding_profile** - Used by 1 views: `orch_app_dd_dms_encoding_profile` **reportsdd_direct_delivery.encoding_profile** - Used by 1 views: `orch_app_dd_encoding_profile` **reportsdd_direct_delivery.encoding_queue** - Used by 1 views: `orch_app_dd_encoding_queue_v2` **reportsdd_direct_delivery.encoding_queue_detail** - Used by 1 views: `orch_app_dd_encoding_queue_detail` **reportsdd_direct_delivery.job_priority** - Used by 1 views: `orch_app_dd_job_priority` **reportsdd_direct_delivery.storage** - Used by 1 views: `orch_app_dd_storage` **reportsdd_direct_delivery.storage_drive** - Used by 1 views: `orch_app_dd_storage_drive` **store_avail.availability** - Used by 1 views: `prod_store_avail_store_avail_availability` **trans_type** - Used by 1 views: `stmt_db_trans_type` **yt_reports_api.demographics_intermediate** - Used by 1 views: `int_dbt_prod_video_demographics_intermediate` #### Derived Tables Views with custom SQL (complex transformations): Total: 280 views | View | Lines of Code | Source Tables | |------|---------------|---------------| | `dt_playlist_track_fit_v2_2stddev` | 1106 | Dbt_Prod.Artist_Track_Metadata, Intelligence.Dbt_Prod | | `dt_track_playlist_audio_feature_comparison_2stddev` | 1012 | Dbt_Prod.Spotify_Editorial_Audio_Feature_Roll_... | | `nav` | 998 | Custom SQL | | `dt_playlist_audio_features_upper_x_lower_bounds` | 894 | Dbt_Prod.Spotify_Editorial_Audio_Feature_Roll_... | | `dt_playlisting_by_track` | 792 | Coalesced_Placements, Coalesced_Placements_Ama... | | `dt_project_moments_cluster_groups_audio_upper_x_lower_bounds_som_logic` | 752 | Audio_Feature_Cluster_Profile, Cluster_Groups,... | | `dt_project_moments_cluster_group_audio_upper_x_lower_bounds` | 748 | Audio_Feature_Cluster_Profile, Cluster_Groups,... | | `dt_project_moments_cluster_group_upper_x_lower_bounds_fuzzy_v4` | 743 | Audio_Feature_Cluster_Profile, Cluster_Groups,... | | `dt_project_moments_cluster_group_audio_upper_x_lower_bounds_v2_fuzzy_logic` | 741 | Audio_Feature_Cluster_Profile, Cluster_Groups,... | | `dt_playlist_track_fit` | 701 | Dbt_Prod.Spotify_Editorial_Audio_Feature_Roll_... | | `dt_track_playlist_audio_feature_comparison` | 700 | Dbt_Prod.Spotify_Editorial_Audio_Feature_Roll_... | | `dt_spotify_top_200_aggregates` | 627 | Dbt_Prod.Orch_Spotify_Top_200_Chart_Appearance... | | `dt_track_compare` | 627 | Prod.Dim_Release, Prod.Dim_Track | | `dt_wheels_physical_price_code` | 609 | Custom SQL | | `dt_membran_physical_price_code` | 609 | Custom SQL | | `dt_proper_physical_price_code` | 609 | Custom SQL | | `dt_mgm_physical_price_code` | 609 | Custom SQL | | `dt_directshot_physical_price_code` | 609 | Custom SQL | | `dt_release_compare` | 574 | Custom SQL | | `dt_global_certifications_by_country` | 556 | Prod.Dim_Isrc, Prod.Dim_Release | *Showing top 20 most complex derived views. Total: 280* ## Explore Relationships ### Explores and Their Dependencies #### Model: Analytics_AWA **int_dbt_prod_agg_awa_model** (AWA Model) - Base View: `int_dbt_prod_agg_awa_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_AWA_MODEL #### Model: Analytics_Amazon **int_dbt_prod_agg_amazon_model** (Amazon Store Model) - Base View: `int_dbt_prod_agg_amazon_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_AMAZON_AGGREGATED #### Model: Analytics_Amazon_Rollup **int_dbt_prod_agg_amazon_monthly_rollup_user_aggregation** (Amazon Store Model Monthly Data) - Base View: `int_dbt_prod_agg_amazon_monthly_rollup_user_aggregation` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.agg_amazon_monthly_rollup_user_aggregation **int_dbt_prod_agg_amazon_monthly_rollup** (Amazon Store Model Monthly Data) - Base View: `int_dbt_prod_agg_amazon_monthly_rollup` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.agg_amazon_monthly_rollup **int_dbt_prod_agg_amazon_weekly_rollup** (Amazon Store Model Weekly Data) - Base View: `int_dbt_prod_agg_amazon_weekly_rollup` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.agg_amazon_weekly_rollup **int_dbt_prod_agg_amazon_aggregated_18months** (Amazon Store Model Daily) - Base View: `int_dbt_prod_agg_amazon_aggregated_18months` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.agg_amazon_aggregated_18months #### Model: Analytics_Apple **int_dbt_prod_agg_apple_model** (Apple Store Model) - Base View: `int_dbt_prod_agg_apple_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_APPLE_SUMMARY #### Model: Analytics_Apple_Rollup **int_dbt_prod_agg_apple_summary_18months** (Apple Store Model Daily) - Base View: `int_dbt_prod_agg_apple_summary_18months` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_APPLE_SUMMARY_18MONTHS **int_dbt_prod_agg_weekly_apple_summary** (Apple Store Model Weekly Data) - Base View: `int_dbt_prod_agg_weekly_apple_summary` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_WEEKLY_APPLE_SUMMARY **int_dbt_prod_agg_monthly_apple_summary** (Apple Store Model Monthly Data) - Base View: `int_dbt_prod_agg_monthly_apple_summary` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_MONTHLY_APPLE_SUMMARY #### Model: Analytics_Deezer **int_dbt_prod_agg_deezer_model** (Deezer Model) - Base View: `int_dbt_prod_agg_deezer_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_DEEZER_MODEL #### Model: Analytics_Line **int_dbt_prod_agg_line_model** (Line Model) - Base View: `int_dbt_prod_agg_line_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_LINE_MODEL #### Model: Analytics_Netease **int_dbt_prod_agg_netease_model** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_agg_netease_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGGREGATED_NETEASE_MODEL #### Model: Analytics_Pandora **int_dbt_prod_agg_pandora_model** (Pandora Store Model) - Base View: `int_dbt_prod_agg_pandora_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_PANDORA_MODEL #### Model: Analytics_Snapchat **int_dbt_prod_agg_snapchat_model** (Snapchat Store Model) - Base View: `int_dbt_prod_agg_snapchat_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_SNAPCHAT_MODEL #### Model: Analytics_Soundcloud **int_dbt_prod_agg_soundcloud_model** (Soundcloud Model) - Base View: `int_dbt_prod_agg_soundcloud_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_SOUNDCLOUD_MODEL #### Model: Analytics_Spotify **int_dbt_prod_agg_spotify_model** (Spotify Store Model) - Base View: `int_dbt_prod_agg_spotify_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_SPOTIFY_MODEL #### Model: Analytics_Spotify_Rollup **int_dbt_prod_agg_spotify_model_18months** (Spotify Store Model Daily) - Base View: `int_dbt_prod_agg_spotify_model_18months` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.agg_spotify_model_18months **int_dbt_prod_agg_weekly_rollup_spotify_model** (Spotify Store Model Weekly Data) - Base View: `int_dbt_prod_agg_weekly_rollup_spotify_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.agg_weekly_rollup_spotify_model **int_dbt_prod_agg_monthly_spotify_model** (Spotify Store Model Monthly Data) - Base View: `int_dbt_prod_agg_monthly_spotify_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.agg_monthly_spotify_model #### Model: Analytics_Tencent **int_dbt_prod_agg_tencent_model** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_agg_tencent_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGGREGATED_TENCENT_STOREFRONT_MODEL #### Model: Analytics_Top_Cities_dataset **int_dbt_prod_top_cities_dataset** (Top Cities) - Base View: `int_dbt_prod_top_cities_dataset` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."TOP_CITIES_DATASET" #### Model: Analytics_UMA **int_dbt_prod_agg_uma_model** (UMA Store Model) - Base View: `int_dbt_prod_agg_uma_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_UMA_MODEL #### Model: Analytics_Use_Case_Models **int_dbt_prod_summary_streams** (Summary Streams Model) - Base View: `int_dbt_prod_summary_streams` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS **metadata_simplified** (metadata_simplified) - Base View: `metadata_simplified` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Metadata_Simplified, Intelligence.Dbt_Prod #### Model: Analytics_Wnyk **int_dbt_prod_agg_wynk_model** (Wynk Model) - Base View: `int_dbt_prod_agg_wynk_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_WYNK_MODEL #### Model: Analytics_Youtube **int_dbt_prod_agg_daily_youtube_model** (Transaction Type) - Base View: `int_dbt_prod_agg_daily_youtube_model` - View Type: Direct Table - Data Source: intelligence.dbt_prod.agg_daily_youtube_model #### Model: Apple_Fraudulent_Streaming **APPLE_IN_REVIEW** (Apple In Review Report) - Base View: `APPLE_IN_REVIEW` - View Type: Direct Table - Data Source: Unknown **int_dbt_prod_apple_excluded_streams** (Apple Excluded Streams Report) - Base View: `int_dbt_prod_apple_excluded_streams` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.APPLE_EXCLUDED_STREAMS #### Model: Apple_Podcasting **daily_apple_podcasting_events_snapshots_joined** (Apple Podcasting Model) - Base View: `daily_apple_podcasting_events_snapshots_joined` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."APPLE_PODCASTING_MODEL" #### Model: Approved_Products_Revenue **int_dbt_prod_approved_products_revenue** (Approved Product Revenue) - Base View: `int_dbt_prod_approved_products_revenue` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."APPROVED_PRODUCTS_REVENUE" #### Model: Discovery_mode **int_dev_nsuzara_awal_discovery** (Discovery Mode) - Base View: `int_dev_nsuzara_awal_discovery` - View Type: Direct Table - Data Source: INTELLIGENCE.DEV_AWALSPOTIFY.AWALDISCOVERY04 **int_dev_nsuzara_awaldata** (Discovery Mode Master Data) - Base View: `int_dev_nsuzara_awaldata` - View Type: Direct Table - Data Source: INTELLIGENCE.DEV_AWALSPOTIFY.AWAL_MASTERISRC **int_dev_awalspotify** (Discovery Mode Unique ISRC) - Base View: `int_dev_awalspotify` - View Type: Direct Table - Data Source: INTELLIGENCE.DEV_AWALSPOTIFY.AWALDATAUNIQUE **int_dev_awalspotify_awaldiscovery_v04ebba** (Discovery Mode AWALDISCOVERY_V04EBBA) - Base View: `int_dev_awalspotify_awaldiscovery_v04ebba` - View Type: Direct Table - Data Source: INTELLIGENCE.DEV_AWALSPOTIFY.AWALDISCOVERY_V04EBBA **believe** (Believe) - Base View: `believe` - View Type: Direct Table - Data Source: Unknown #### Model: Download_Stores_Models **int_dbt_prod_agg_daily_beatport_download_model** (Beatport Download Model) - Base View: `int_dbt_prod_agg_daily_beatport_download_model` - View Type: Direct Table - Data Source: intelligence.dbt_prod.agg_daily_beatport_download_model **int_dbt_prod_agg_daily_amazon_download_model** (Amazon Download Model) - Base View: `int_dbt_prod_agg_daily_amazon_download_model` - View Type: Direct Table - Data Source: intelligence.dbt_prod.agg_daily_amazon_download_model **int_dbt_prod_agg_daily_apple_download_model** (Apple Download Model) - Base View: `int_dbt_prod_agg_daily_apple_download_model` - View Type: Direct Table - Data Source: intelligence.dbt_prod.agg_daily_apple_download_model **int_dbt_prod_daily_summary_downloads** (Unified Downloads Model) - Base View: `int_dbt_prod_daily_summary_downloads` - View Type: Direct Table - Data Source: intelligence.dbt_prod.daily_summary_downloads #### Model: FCT_ORCHARD_INSIGHTS_TOP_STREAMS_METRICS_TIKTOK_BY_LABEL **int_dbt_prod_fct_orchard_insights_top_streams_metrics_tiktok_by_label** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_fct_orchard_insights_top_streams_metrics_tiktok_by_label` - View Type: Direct Table - Data Source: intelligence.dbt_prod.fct_orchard_insights_top_streams_metrics_tiktok_by_label #### Model: Insta_Reels **facts_prod_staging_raw_insta_reels_views** (Instagram Reels Views) - Base View: `facts_prod_staging_raw_insta_reels_views` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_INSTA_REELS_VIEWS **facts_prod_staging_raw_insta_reels_creations** (Instagram Reels Creations) - Base View: `facts_prod_staging_raw_insta_reels_creations` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_INSTA_REELS_CREATIONS #### Model: Jorga_Smith_Analysis **JORJA_SMITH_LOST_AND_FOUND_APPLE_PLAYLIST_AND_STORE_FIRST_7_DAYS** (Jorga Smith Analysis - Lost and Found Apple Playlist) - Base View: `JORJA_SMITH_LOST_AND_FOUND_APPLE_PLAYLIST_AND_STORE_FIRST_7_DAYS` - View Type: Direct Table - Data Source: Unknown **JORJA_SMITH_FALLING_OR_FLYING_AMAZON_FIRST_7_DAYS** (Jorga Smith Analysis - Falling or Flying Amazon) - Base View: `JORJA_SMITH_FALLING_OR_FLYING_AMAZON_FIRST_7_DAYS` - View Type: Direct Table - Data Source: Unknown **JORJA_SMITH_FALLING_OR_FLYING_APPLE_PLAYLIST_FIRST_7_DAYS** (Jorga Smith Analysis - Falling or flying Apple Playlist) - Base View: `JORJA_SMITH_FALLING_OR_FLYING_APPLE_PLAYLIST_FIRST_7_DAYS` - View Type: Direct Table - Data Source: Unknown **JORJA_SMITH_FALLING_OR_FLYING_APPLE_STORE_FIRST_7_DAYS** (Jorga Smith Analysis - Falling or Flying Apple Store) - Base View: `JORJA_SMITH_FALLING_OR_FLYING_APPLE_STORE_FIRST_7_DAYS` - View Type: Direct Table - Data Source: Unknown **JORJA_SMITH_FALLING_OR_FLYING_SPOTIFY_FIRST_7_DAYS** (Jorga Smith Analysis - Falling or Flying Spotify) - Base View: `JORJA_SMITH_FALLING_OR_FLYING_SPOTIFY_FIRST_7_DAYS` - View Type: Direct Table - Data Source: Unknown **JORJA_SMITH_LOST_AND_FOUND_AMAZON_FIRST_7_DAYS** (Jorga Smith Analysis - Lost and Found Amazon) - Base View: `JORJA_SMITH_LOST_AND_FOUND_AMAZON_FIRST_7_DAYS` - View Type: Direct Table - Data Source: Unknown **JORJA_SMITH_LOST_AND_FOUND_SPOTIFY_FIRST_7_DAYS** (Jorga Smith Analysis - Lost and Found Spotify) - Base View: `JORJA_SMITH_LOST_AND_FOUND_SPOTIFY_FIRST_7_DAYS` - View Type: Direct Table - Data Source: Unknown #### Model: Label_Review_Spreadsheet **int_dbt_prod_label_performance_spreadsheet** (Label Performance Spreadsheet) - Base View: `int_dbt_prod_label_performance_spreadsheet` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.LABEL_PERFORMANCE_SPREADSHEET #### Model: Last_7_days_streaming **int_dbt_prod_streaming_totals_last_7_days_isrc_level** (Label) - Base View: `int_dbt_prod_streaming_totals_last_7_days_isrc_level` - View Type: Derived Table - Data Source: intelligence.dbt_prod.streaming_totals_last_7_days_isrc_level #### Model: MD5_Changes **orch_app_dd_asset** (MD5 Changes) - Base View: `orch_app_dd_asset` - View Type: Direct Table - Data Source: orchard_app_reporting_v2.reportsdd_direct_delivery.asset #### Model: MRC **facts_prod_staging_raw_mrc** (MRC Report) - Base View: `facts_prod_staging_raw_mrc` - View Type: Direct Table - Data Source: facts.prod.staging_raw_mrc #### Model: Riaa_Certification_Model **int_dbt_prod_riaa_certification** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_riaa_certification` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.RIAA_CERTIFICATION_MODEL #### Model: Sales_Performance_Metrics_Spotify **int_dbt_prod_sales_performance_metrics** (Sales Performance Metrics: Spotify) - Base View: `int_dbt_prod_sales_performance_metrics` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.SALES_PERFORMANCE_METRICS_SPOTIFY #### Model: Snowflake_Monitoring **snowflake_warehouse_metering_xf** (Snowflake Warehouse Cost Monitoring) - Base View: `snowflake_warehouse_metering_xf` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."SNOWFLAKE_WAREHOUSE_METERING_XF" **snowflake_query_history** (Snowflake Query Monitoring) - Base View: `snowflake_query_history` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."SNOWFLAKE_QUERY_HISTORY" **monthly_snowflake_storage_costs** (Snowflake Storage Cost Monitoring) - Base View: `monthly_snowflake_storage_costs` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."MONTHLY_SNOWFLAKE_STORAGE_COSTS" #### Model: Spotify_Charts **facts_prod_spotify_chart** (Track) - Base View: `facts_prod_spotify_chart` - View Type: Direct Table - Data Source: intelligence.dbt_prod_strategy.spotify_charting_combined #### Model: Spotify_Monthly_Fraudulent_Streaming **int_dbt_prod_spotify_monthly_fraudulent_streaming** (Spotify Frauduelent Streaming Monthly Report) - Base View: `int_dbt_prod_spotify_monthly_fraudulent_streaming` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.SPOTIFY_MONTHLY_FRAUDULENT_STREAMING **int_dbt_prod_spotify_fraudulent_fact_sales_combined** (Label Contract) - Base View: `int_dbt_prod_spotify_fraudulent_fact_sales_combined` - View Type: Direct Table - Data Source: intelligence.dbt_prod.spotify_fraudulent_fact_sales_combined #### Model: Spotify_Weekly_Market_Share **spotify_market_share_week_ending** (Spotify Weekly Market Share) - Base View: `spotify_market_share_week_ending` - View Type: Direct Table - Data Source: intelligence.dbt_prod.spotify_weekly_market_share_by_country #### Model: Tier_3_Label_Analysis **int_dbt_prod_tier_3_label_analysis** (Label Manager Territory) - Base View: `int_dbt_prod_tier_3_label_analysis` - View Type: Direct Table - Data Source: intelligence.dbt_prod.tier_3_label_analysis #### Model: TikTok_Fraudulent_Streaming **int_dbt_prod_tiktok_fraud_model** (TikTok Fraudulent Content) - Base View: `int_dbt_prod_tiktok_fraud_model` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.TIKTOK_FRAUD_STREAMS_MODEL #### Model: US_ARTIST_RANKING **US_ARTIST_RANKING** (US Artist Ranking) - Base View: `US_ARTIST_RANKING` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.US_ARTIST_RANKING #### Model: Weekly_Streaming_Overall_Performance **int_dbt_prod_wow_streams_by_dsp** (WoW_Streams_by_DSP) - Base View: `int_dbt_prod_wow_streams_by_dsp` - View Type: Direct Table - Data Source: Unknown **int_dbt_prod_tier_breakdown** (Tier Breakdown) - Base View: `int_dbt_prod_tier_breakdown` - View Type: Direct Table - Data Source: Unknown **int_dbt_prod_source_breakdown** (Source Breakdown) - Base View: `int_dbt_prod_source_breakdown` - View Type: Direct Table - Data Source: Unknown **int_dbt_prod_engagedvsleanbackbreakdown** (engaged vs Leanback breakdown) - Base View: `int_dbt_prod_engagedvsleanbackbreakdown` - View Type: Direct Table - Data Source: Unknown **int_dbt_prod_weekly_no_of_new_releases** (Weekly No Of New Releases) - Base View: `int_dbt_prod_weekly_no_of_new_releases` - View Type: Direct Table - Data Source: Unknown **int_dbt_prod_sub_genres** (Sub Genre) - Base View: `int_dbt_prod_sub_genres` - View Type: Direct Table - Data Source: Unknown #### Model: YouTube_Analytics_API **int_dbt_prod_youtube_summary_streams_daily** (Video) - Base View: `int_dbt_prod_youtube_summary_streams_daily` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.YOUTUBE_SUMMARY_STREAMS_DAILY #### Model: abacus **int_dbt_prod_abacus_fact_sales** (Transaction Country) - Base View: `int_dbt_prod_abacus_fact_sales` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ABACUS_FACT_SALES **int_dbt_prod_abacus_adjustments** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_abacus_adjustments` - View Type: Direct Table - Data Source: intelligence.dbt_prod.abacus_adjustments **int_dbt_prod_qa_abacus_adjustments** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_qa_abacus_adjustments` - View Type: Direct Table - Data Source: intelligence.dbt_prod.qa_abacus_adjustments **int_dbt_prod_abacus_expenses** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_abacus_expenses` - View Type: Direct Table - Data Source: intelligence.dbt_prod.abacus_expenses **int_dbt_prod_qa_abacus_expenses** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_qa_abacus_expenses` - View Type: Direct Table - Data Source: intelligence.dbt_prod.qa_abacus_expenses #### Model: accounting_analytics_blend **int_prod_accounting_analytics_blend** (Artist) - Base View: `int_prod_accounting_analytics_blend` - View Type: Direct Table - Data Source: intelligence.prod.accounting_analytics_blend **int_prod_accounting_analytics_blend** (Artist) - Base View: `int_prod_accounting_analytics_blend` - View Type: Direct Table - Data Source: intelligence.prod.accounting_analytics_blend #### Model: accounting_reports **dt_checks** (Exchange rates) - Base View: `dt_checks` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_CHECKS #### Model: ad_spend **facts_prod_fact_ad_spend** (Artist) - Base View: `facts_prod_fact_ad_spend` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: advertising_campaigns **advertising_campaigns** (advertising_campaigns) - Base View: `advertising_campaigns` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."ORCHARD_NEW_ADVERTISING_CAMPAIGNS" #### Model: advertising_monthly_activity **advertising_monthly_activity** (advertising_monthly_activity) - Base View: `advertising_monthly_activity` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ORCHARD_NEW_ADVERTISING_MONTHLY_ACTIVITY #### Model: advertising_requests **advertising_requests** (advertising_requests) - Base View: `advertising_requests` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."ORCHARD_NEW_ADVERTISING_REQUESTS" #### Model: all_signed_labels **all_signed_labels_revenue_columns** (All Signed Labels - Pivoted) - Base View: `all_signed_labels_revenue_columns` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."ALL_SIGNED_LABELS_REVENUE_COLUMNS" **all_signed_labels** (all_signed_labels) - Base View: `all_signed_labels` - View Type: Direct Table - Data Source: intelligence.dbt_prod.all_signed_labels #### Model: amazon_sos **facts_prod_staging_raw_amazon_unlimited** (Source of Stream) - Base View: `facts_prod_staging_raw_amazon_unlimited` - View Type: Direct Table - Data Source: facts.prod.staging_raw_amazon_unlimited #### Model: amprofon_certification **dt_amprofon_certification** (Amprofon Certification) - Base View: `dt_amprofon_certification` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Isrc, Prod.Dim_Release **dt_amprofon_certification_v2** (Amprofon Certification) - Base View: `dt_amprofon_certification_v2` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Isrc, Prod.Dim_Release #### Model: anomaly_testing **market_share_test** (Market Share Tests) - Base View: `market_share_test` - View Type: Derived Table - Data Source: Derived from: Max_Months, Monthly_Metrics, Prod.Fact_Market_Share **market_share_fact_sales_test** (Market Share fact Sales Tests) - Base View: `market_share_fact_sales_test` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Dt_Fact_Sales_Marketshare, Intelligence.Dbt_Prod, Max_Mon... **amazon_anomaly_testing** (Amazon Anomaly Testing) - Base View: `amazon_anomaly_testing` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Agg_Amazon_Aggregated, Intelligence.Dbt_Prod, Max_Week **apple_anomaly_testing** (Apple Anomaly Testing) - Base View: `apple_anomaly_testing` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Agg_Apple_Summary, Intelligence.Dbt_Prod, Max_Week **spotify_anomaly_testing** (Spotify Anomaly Testing) - Base View: `spotify_anomaly_testing` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Agg_Weekly_Rollup_Spotify_Model, Intelligence.Dbt_Prod, M... **deezer_anomaly_testing** (Deezer Anomaly Testing) - Base View: `deezer_anomaly_testing` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Agg_Deezer_Model, Intelligence.Dbt_Prod, Max_Week **line_anomaly_testing** (Line Anomaly Testing) - Base View: `line_anomaly_testing` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Agg_Line_Model, Intelligence.Dbt_Prod, Max_Week #### Model: apple_container_report **facts_prod_apple_music_container_summary** (Container Report) - Base View: `facts_prod_apple_music_container_summary` - View Type: Direct Table - Data Source: facts.prod.staging_raw_apple_music_container #### Model: apple_music_demographic **int_dbt_prod_apple_music_demographic** (Label) - Base View: `int_dbt_prod_apple_music_demographic` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."APPLE_MUSIC_DEMOGRAPHICS" #### Model: apple_music_pitch_grid **dt_apple_music_pitch_grid** (Release Is Deliverable) - Base View: `dt_apple_music_pitch_grid` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.APG_APPLE_PITCH_GRID **int_dbt_prod_apple_music_pitch_grid_specialist_genres** (Release Is Deliverable) - Base View: `int_dbt_prod_apple_music_pitch_grid_specialist_genres` - View Type: Direct Table - Data Source: intelligence.dbt_prod.apple_music_pitch_grid_specialist_genres **int_prod_apg_apple_pitch_grid** (Release Is Deliverable) - Base View: `int_prod_apg_apple_pitch_grid` - View Type: Direct Table - Data Source: intelligence.prod.apg_apple_pitch_grid #### Model: aria_streaming_score **dt_aria_streaming_score** (dt_aria_streaming_score) - Base View: `dt_aria_streaming_score` - View Type: Derived Table - Data Source: Derived from: Prod.Fact_Analytics #### Model: artist_marketshare **int_dbt_prod_artist_marketshare** (Orchard Marketshare Detail) - Base View: `int_dbt_prod_artist_marketshare` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ARTIST_MARKETSHARE #### Model: artist_similarity **dev_eng_artist_clustering_artist_similarity** (Recommended Country) - Base View: `dev_eng_artist_clustering_artist_similarity` - View Type: Direct Table - Data Source: dev_engineering.artist_clustering.artist_similarity #### Model: artist_store_identifier **int_prod_vw_artist_identifier** (Artist Name (Aggregated)) - Base View: `int_prod_vw_artist_identifier` - View Type: Direct Table - Data Source: intelligence.prod.vw_artist_identifer #### Model: artist_trends_and_demographics **int_dbt_prod_artist_streaming_trends** (Artist Demographics) - Base View: `int_dbt_prod_artist_streaming_trends` - View Type: Direct Table - Data Source: intelligence.dbt_prod.artist_streaming_trends #### Model: audience_segmentation **spotify_engagement_groups_combined_with_user_info** (Demographics) - Base View: `spotify_engagement_groups_combined_with_user_info` - View Type: Direct Table - Data Source: intelligence.dbt_prod.spotify_engagement_groups_combined_with_user_info **amazon_engagement_groups_combined** (Demographics) - Base View: `amazon_engagement_groups_combined` - View Type: Direct Table - Data Source: intelligence.dbt_prod.amazon_engagement_groups_combined_with_user_info #### Model: audio_features **int_dbt_prod_spotify_track_audio_features** (Track) - Base View: `int_dbt_prod_spotify_track_audio_features` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.SPOTIFY_TRACK_AUDIO_FEATURES **dt_track_audio_feature_comparison** (Track Audio Feature Comparison Model) - Base View: `dt_track_audio_feature_comparison` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **dt_track_playlist_audio_feature_comparison** (Track vs Playlist Audio Feature Comparison Model) - Base View: `dt_track_playlist_audio_feature_comparison` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Spotify_Editorial_Audio_Feature_Roll_Up, Dbt_Prod.Spotify... **dt_track_playlist_audio_feature_comparison_2stddev** (Track vs Playlist Audio Feature Comparison Model 2stddev) - Base View: `dt_track_playlist_audio_feature_comparison_2stddev` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Spotify_Editorial_Audio_Feature_Roll_Up, Dbt_Prod.Spotify... **dt_playlist_track_fit** (Playlist) - Base View: `dt_playlist_track_fit` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Spotify_Editorial_Audio_Feature_Roll_Up, Dbt_Prod.Spotify... **dt_playlist_track_fit_v2_2stddev** (Playlist) - Base View: `dt_playlist_track_fit_v2_2stddev` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Artist_Track_Metadata, Intelligence.Dbt_Prod **dt_playlist_audio_features_upper_x_lower_bounds** (Playlist Audio Features - Upper & Lower Bounds) - Base View: `dt_playlist_audio_features_upper_x_lower_bounds` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Spotify_Editorial_Audio_Feature_Roll_Up, Intelligence.Dbt... **dt_audio_features_track_similarity** (Track) - Base View: `dt_audio_features_track_similarity` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Spotify_Track_Audio_Features, Intelligence.Dbt_Prod **int_dbt_prod_spotify_editorial_playlist_position_log** (Spotify Audio Features) - Base View: `int_dbt_prod_spotify_editorial_playlist_position_log` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.SPOTIFY_EDITORIAL_PLAYLIST_POSITION_LOG **dt_audio_features_playlist_similarity** (Playlist Audio Characteristic Similarity Model) - Base View: `dt_audio_features_playlist_similarity` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Spotify_Track_Audio_Features, Intelligence.Dbt_Prod #### Model: awal_toggle **int_dbt_prod_awal_tier_groups** (int_dbt_prod_awal_tier_groups) - Base View: `int_dbt_prod_awal_tier_groups` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AWAL_TIER_GROUPS #### Model: balance_models **dt_outstanding_balances_2** (Outstanding Balances Model) - Base View: `dt_outstanding_balances_2` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.DT_OUTSTANDING_BALANCES_2 **dt_advances_2** (Advances Model) - Base View: `dt_advances_2` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Owner, Art_Relations_Prod_Art_Rel... #### Model: bi_tools **dt_new_signing_revenue_estimate_calculator** (dt_new_signing_revenue_estimate_calculator) - Base View: `dt_new_signing_revenue_estimate_calculator` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: bits_per_sample **orch_app_ar_vendor** (Label) - Base View: `orch_app_ar_vendor` - View Type: Direct Table - Data Source: royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor #### Model: capif_certification **dt_capif_certification** (Orchard/AWAL Tiers) - Base View: `dt_capif_certification` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Isrc, Prod.Dim_Release #### Model: certification_models **int_dbt_prod_promusicae_track_cert** (Promusicae Spain Track Certification) - Base View: `int_dbt_prod_promusicae_track_cert` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.PROMUSICAE_TRACK_CERTIFICATION **int_dbt_prod_promusicae_album_cert** (Promusicae Spain Album Certification) - Base View: `int_dbt_prod_promusicae_album_cert` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.PROMUSICAE_ALBUM_CERTIFICATION **int_dbt_prod_promusicae_brazil_cert** (Promusicae Brazil Track Certification) - Base View: `int_dbt_prod_promusicae_brazil_cert` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.PROMUSICAE_BRAZIL_CERTIFICATION **int_dbt_prod_amprofon_track_cert** (Amprofon Mexico Track Certification) - Base View: `int_dbt_prod_amprofon_track_cert` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AMPROFON_TRACK_CERTIFICATION **int_dbt_prod_amprofon_album_cert** (Amprofon Mexico Album Certification) - Base View: `int_dbt_prod_amprofon_album_cert` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AMPROFON_ALBUM_CERTIFICATION **int_dbt_prod_aria_track_cert** (ARIA Australia Track Certification) - Base View: `int_dbt_prod_aria_track_cert` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ARIA_TRACK_CERTIFICATION **int_dbt_prod_aria_album_cert** (ARIA Australia Album Certification) - Base View: `int_dbt_prod_aria_album_cert` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ARIA_ALBUM_CERTIFICATION **int_dbt_prod_aria_album_cert_accounting** (ARIA Australia Album Certification (Accounting)) - Base View: `int_dbt_prod_aria_album_cert_accounting` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ARIA_ALBUM_CERTIFICATION_ACCOUNTING **int_dbt_prod_aria_track_cert_accounting** (ARIA Australia Track Certification (Accounting)) - Base View: `int_dbt_prod_aria_track_cert_accounting` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ARIA_TRACK_CERTIFICATION_ACCOUNTING **int_dbt_prod_riaa_track_cert** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_riaa_track_cert` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.RIAA_TRACK_CERTIFICATION **int_dbt_prod_riaa_album_cert** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_riaa_album_cert` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.RIAA_ALBUM_CERTIFICATION #### Model: chart_metric_A&R **cm_unioned_chart_advanced** (A&R Tool) - Base View: `cm_unioned_chart_advanced` - View Type: Derived Table - Data Source: intelligence.dbt_prod.cm_unioned_chart_advanced **cm_non_traditional_charts** (Chart) - Base View: `cm_non_traditional_charts` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.CM_NON_TRADITIONAL_CHARTS **cm_unioned_playlist_current** (Playlist) - Base View: `cm_unioned_playlist_current` - View Type: Derived Table - Data Source: intelligence.dbt_prod.cm_unioned_playlist_current **cm_unioned_chart_2** (A&R New) - Base View: `cm_unioned_chart_2` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.CM_UNIONED_CHART_2 #### Model: chart_metric_music **cm_unioned_chart** (Charts) - Base View: `cm_unioned_chart` - View Type: Derived Table - Data Source: intelligence.dbt_prod.cm_unioned_chart #### Model: chart_metric_playlist **cm_unioned_playlist_current** (Playlist) - Base View: `cm_unioned_playlist_current` - View Type: Derived Table - Data Source: intelligence.dbt_prod.cm_unioned_playlist_current **cm_unioned_playlist_history** (Playlist History) - Base View: `cm_unioned_playlist_history` - View Type: Derived Table - Data Source: intelligence.dbt_prod.cm_unioned_playlist_history #### Model: chart_metric_social **cm_social_union** (Artist) - Base View: `cm_social_union` - View Type: Derived Table - Data Source: intelligence.dbt_prod.cm_social_union **cm_track_artists** (TikTok) - Base View: `cm_track_artists` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.CM_TRACK_ARTISTS #### Model: chartable_podcasts **facts_prod_chartable_podcast_rankings** (Podcast) - Base View: `facts_prod_chartable_podcast_rankings` - View Type: Direct Table - Data Source: facts.prod.chartable_podcast_rankings #### Model: chartmetric_charts **facts_prod_chartmetric_charts** (Chartmetric Ingestions) - Base View: `facts_prod_chartmetric_charts` - View Type: Direct Table - Data Source: facts.prod.chartmetric_charts_log #### Model: chartmetric_socials **facts_prod_chartmetric_socials** (Chartmetric Ingestions) - Base View: `facts_prod_chartmetric_socials` - View Type: Direct Table - Data Source: facts.prod.chartmetric_socials_log #### Model: chartmetric_socials_backfill **facts_prod_cm_url_backfill** (Chartmetric Ingestions) - Base View: `facts_prod_cm_url_backfill` - View Type: Direct Table - Data Source: facts.prod.cm_url_backfill #### Model: cherry_pick_report **int_dbt_prod_cherry_pick_report** (int_dbt_prod_cherry_pick_report) - Base View: `int_dbt_prod_cherry_pick_report` - View Type: Derived Table - Data Source: intelligence.dbt_prod.cherry_pick_reports #### Model: compilation_takedowns **int_prod_compilation_takedowns** (Compilation Takedowns Tool) - Base View: `int_prod_compilation_takedowns` - View Type: Direct Table - Data Source: intelligence.prod.compilation_takedowns #### Model: conflict_manager_statistics **facts_prod_fact_conflict** (Conflict manager Statistics Report) - Base View: `facts_prod_fact_conflict` - View Type: Direct Table - Data Source: facts.prod.fact_conflict #### Model: contact_created_date **contact_created_date** (Contact Created Date) - Base View: `contact_created_date` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Contact, Art_Relations_Prod_Art_R... **order_items** (order_items) - Base View: `order_items` - View Type: Direct Table - Data Source: Unknown #### Model: content_validation_itunes_apple **dt_content_validation_explicit_content** (Reporting Template) - Base View: `dt_content_validation_explicit_content` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A... **dt_content_validation_featuring_artists** (Reporting Template) - Base View: `dt_content_validation_featuring_artists` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_CONTENT_VALIDATION_FEATURING_ARTISTS **dt_content_validation_album_credit** (Reporting Template) - Base View: `dt_content_validation_album_credit` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.DT_CONTENT_VALIDATION_ALBUM_CREDIT #### Model: content_validation_itunes_apple_v2 **int_prod_vw_track_explicit** (Reporting Template) - Base View: `int_prod_vw_track_explicit` - View Type: Direct Table - Data Source: Unknown **int_prod_vw_featuring_artists_track_release** (Reporting Template) - Base View: `int_prod_vw_featuring_artists_track_release` - View Type: Direct Table - Data Source: intelligence.prod.featuring_artists_track_release **int_prod_vw_release_content_validation_agg** (Reporting Template) - Base View: `int_prod_vw_release_content_validation_agg` - View Type: Direct Table - Data Source: intelligence.prod.release_content_validation_agg **int_prod_vw_track_content_validation_agg** (Reporting Template) - Base View: `int_prod_vw_track_content_validation_agg` - View Type: Direct Table - Data Source: intelligence.prod.track_content_validation_agg **int_prod_itunes_language_validation** (Language Validation) - Base View: `int_prod_itunes_language_validation` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ITUNES_LANGUAGE_VALIDATION #### Model: core_accounting **facts_prod_fact_sales** (Accounting) - Base View: `facts_prod_fact_sales` - View Type: Direct Table - Data Source: royalty_accounting.prod.workstation_fact_sales_unified_dbt #### Model: core_analytics **facts_prod_fact_analytics** (Analytics) - Base View: `facts_prod_fact_analytics` - View Type: Direct Table - Data Source: facts.prod.fact_analytics #### Model: core_analytics_v2 **facts_prod_fact_analytics_v2** (Analytics) - Base View: `facts_prod_fact_analytics_v2` - View Type: Direct Table - Data Source: facts.prod.fact_analytics **facts_prod_aggregated_skips_and_saves** (Skips & Saves) - Base View: `facts_prod_aggregated_skips_and_saves` - View Type: Direct Table - Data Source: facts.prod.aggregated_skips_and_saves **int_prod_fact_analytics_2020** (Analytics 2020) - Base View: `int_prod_fact_analytics_2020` - View Type: Direct Table - Data Source: intelligence.prod.fact_analytics_2020 **metadata_simplified** (metadata_simplified) - Base View: `metadata_simplified` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Metadata_Simplified, Intelligence.Dbt_Prod **nav** (nav) - Base View: `nav` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: core_metadata **orch_app_ar_owner** (Label) - Base View: `orch_app_ar_owner` - View Type: Direct Table - Data Source: orchard_app_reporting_v2.art_relations_prod_art_relations.owner **nav** (nav) - Base View: `nav` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **metadata_simplified** (metadata_simplified) - Base View: `metadata_simplified` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Metadata_Simplified, Intelligence.Dbt_Prod #### Model: daily_spiking **int_prod_daily_spikes_us** (Label) - Base View: `int_prod_daily_spikes_us` - View Type: Direct Table - Data Source: intelligence.dbt_prod.daily_spikes_us **int_prod_weekly_spikes_us** (Label) - Base View: `int_prod_weekly_spikes_us` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_spikes_us **int_prod_daily_spikes_uk** (Label) - Base View: `int_prod_daily_spikes_uk` - View Type: Direct Table - Data Source: intelligence.dbt_prod.daily_spikes_uk **int_prod_weekly_spikes_uk** (Label) - Base View: `int_prod_weekly_spikes_uk` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_spikes_uk **int_dbt_prod_weekly_spikes_japan** (Label) - Base View: `int_dbt_prod_weekly_spikes_japan` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_spikes_japan **int_dbt_prod_weekly_spikes_africa** (Label) - Base View: `int_dbt_prod_weekly_spikes_africa` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_spikes_africa **dt_daily_spikes** (Label) - Base View: `dt_daily_spikes` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country **dt_daily_negative_spikes** (Label) - Base View: `dt_daily_negative_spikes` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country **dt_daily_spikes_v2** (Label) - Base View: `dt_daily_spikes_v2` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country **dt_weekly_spikes** (Label) - Base View: `dt_weekly_spikes` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country **dt_weekly_negative_spikes** (Label) - Base View: `dt_weekly_negative_spikes` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country #### Model: daily_top_content **int_prod_daily_top_content** (Label) - Base View: `int_prod_daily_top_content` - View Type: Direct Table - Data Source: intelligence.prod.daily_top_content #### Model: dbt_custom_looker_datasets **int_dbt_prod_accounting_last_12_months_activity_date** (Transaction Country) - Base View: `int_dbt_prod_accounting_last_12_months_activity_date` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ACCOUNTING_LAST_12_MONTHS_ACTIVITY_DATE **top_content_daily_editorial_streams** (Custom Models) - Base View: `top_content_daily_editorial_streams` - View Type: Direct Table - Data Source: intelligence.dbt_prod.top_content_daily_editorial_streams_rollup **int_dbt_prod_accounting_last_24_months_activity_date_track_level** (Spotify Editorial Streams) - Base View: `int_dbt_prod_accounting_last_24_months_activity_date_track_level` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ACCOUNTING_LAST_24_MONTHS_ACTIVITY_DATE_TRACK_LEVEL **int_dbt_prod_artist_by_territory_accounting** (Transaction Country) - Base View: `int_dbt_prod_artist_by_territory_accounting` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ARTISTS_BY_TERRITORY_ACCOUNTING **int_dbt_prod_track_level_accounting** (Release) - Base View: `int_dbt_prod_track_level_accounting` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.TRACK_LEVEL_ACCOUNTING_V1 **int_dbt_prod_spatial_audio_delivery_history_search** (int_dbt_prod_spatial_audio_delivery_history_search) - Base View: `int_dbt_prod_spatial_audio_delivery_history_search` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.SPATIAL_AUDIO_DELIVERY_HISTORY_SEARCH **int_dbt_prod_per_play_rate** (int_dbt_prod_per_play_rate) - Base View: `int_dbt_prod_per_play_rate` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.PER_PLAY_RATE_LAST_4_YEARS **int_dbt_prod_digital_bulk_template** (int_dbt_prod_digital_bulk_template) - Base View: `int_dbt_prod_digital_bulk_template` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DIGITAL_BULK_TEMPLATE **tsz_custom** (tsz_custom) - Base View: `tsz_custom` - View Type: Direct Table - Data Source: intelligence.dbt_prod.tsz_custom **int_dbt_prod_completion_rate_track_level_monthly** (int_dbt_prod_completion_rate_track_level_monthly) - Base View: `int_dbt_prod_completion_rate_track_level_monthly` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.COMPLETION_RATE_TRACK_LEVEL_MONTHLY **int_dbt_prod_full_track_metadata_report_delivery_history** (int_dbt_prod_full_track_metadata_report_delivery_history) - Base View: `int_dbt_prod_full_track_metadata_report_delivery_history` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.FULL_TRACK_METADATA_REPORT_DELIVERY_HISTORY **int_dbt_prod_changes_by_country** (int_dbt_prod_changes_by_country) - Base View: `int_dbt_prod_changes_by_country` - View Type: Direct Table - Data Source: intelligence.dbt_prod.changes_by_country **int_dbt_prod_tracks_generating_1000_streams** (int_dbt_prod_tracks_generating_1000_streams) - Base View: `int_dbt_prod_tracks_generating_1000_streams` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.TRACKS_GENERATING_1000_STREAMS **int_dbt_prod_global_chart_tracking** (int_dbt_prod_global_chart_tracking) - Base View: `int_dbt_prod_global_chart_tracking` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.GLOBAL_CHART_TRACKING **int_dbt_prod_anuel_aa_toptracks_monthly** (int_dbt_prod_anuel_aa_toptracks_monthly) - Base View: `int_dbt_prod_anuel_aa_toptracks_monthly` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ANUEL_AA_TOPTACKS_MONTHLY **int_dbt_prod_top_artists_monthly** (int_dbt_prod_top_artists_monthly) - Base View: `int_dbt_prod_top_artists_monthly` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.TOP_ARTISTS_MONTHLY **int_dbt_prod_top_tracks_monthly** (int_dbt_prod_top_tracks_monthly) - Base View: `int_dbt_prod_top_tracks_monthly` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.TOP_TRACKS_MONTHLY **int_dbt_prod_first_access_analytics_reporting** (int_dbt_prod_first_access_analytics_reporting) - Base View: `int_dbt_prod_first_access_analytics_reporting` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.FIRST_ACCESS_7_DAYS_28_DAYS_ALL_TIME **int_dbt_prod_youtube_spike_report** (int_dbt_prod_youtube_spike_report) - Base View: `int_dbt_prod_youtube_spike_report` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.YOUTUBE_SPIKE_REPORT **int_dbt_prod_changes_by_source** (int_dbt_prod_changes_by_source) - Base View: `int_dbt_prod_changes_by_source` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.CHANGES_BY_SOURCE #### Model: dbt_ifpi_models **int_dbt_prod_ifpi_country_label_level_accounting** (int_dbt_prod_ifpi_country_label_level_accounting) - Base View: `int_dbt_prod_ifpi_country_label_level_accounting` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.IFPI_COUNTRY_LABEL_LEVEL_ACCOUNTING #### Model: dbt_monitoring **elementary_model_job_monitoring_v1** (dbt Monitoring) - Base View: `elementary_model_job_monitoring_v1` - View Type: Direct Table - Data Source: intelligence.dbt_prod.elementary_model_job_monitoring #### Model: dbt_playlists **int_dbt_prod_playlist_model_spotify** (Label) - Base View: `int_dbt_prod_playlist_model_spotify` - View Type: Direct Table - Data Source: intelligence.dbt_prod.playlist_model_spotify **int_dbt_prod_playlist_model_amazon** (Label) - Base View: `int_dbt_prod_playlist_model_amazon` - View Type: Direct Table - Data Source: intelligence.dbt_prod.playlist_model_amazon **int_dbt_prod_playlist_model_apple** (Label) - Base View: `int_dbt_prod_playlist_model_apple` - View Type: Direct Table - Data Source: intelligence.dbt_prod.playlist_model_apple **int_dbt_prod_playlist_model_soundcloud** (Label) - Base View: `int_dbt_prod_playlist_model_soundcloud` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.PLAYLIST_MODEL_SOUNDCLOUD **int_dbt_prod_playlist_model_pandora** (Label) - Base View: `int_dbt_prod_playlist_model_pandora` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.PLAYLIST_MODEL_PANDORA **int_dbt_prod_playlist_model_joint** (Label) - Base View: `int_dbt_prod_playlist_model_joint` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.PLAYLIST_MODEL_JOINT #### Model: dbt_release_schedule_dashboard_v2 **int_dbt_prod_rsd_v2** (Artist) - Base View: `int_dbt_prod_rsd_v2` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.RSD_V2 #### Model: dbt_trending_tiktok **int_dbt_prod_rolling_weekly_tiktok_trending_creations** (Label) - Base View: `int_dbt_prod_rolling_weekly_tiktok_trending_creations` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_CREATIONS **int_dbt_prod_rolling_weekly_tiktok_trending_creations_3_weeks** (Label) - Base View: `int_dbt_prod_rolling_weekly_tiktok_trending_creations_3_weeks` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_CREATIONS_3_WEEKS **int_dbt_prod_rolling_weekly_tiktok_trending_creations_5_weeks** (Label) - Base View: `int_dbt_prod_rolling_weekly_tiktok_trending_creations_5_weeks` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_CREATIONS_5_WEEKS **int_dbt_prod_rolling_weekly_tiktok_trending_video_views** (Label) - Base View: `int_dbt_prod_rolling_weekly_tiktok_trending_video_views` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_VIDEO_VIEWS **int_dbt_prod_rolling_weekly_tiktok_trending_video_views_3_weeks** (Label) - Base View: `int_dbt_prod_rolling_weekly_tiktok_trending_video_views_3_weeks` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_VIDEO_VIEWS_3_WEEKS **int_dbt_prod_rolling_weekly_tiktok_trending_video_views_5_weeks** (Label) - Base View: `int_dbt_prod_rolling_weekly_tiktok_trending_video_views_5_weeks` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_VIDEO_VIEWS_5_WEEKS **int_dbt_prod_tiktok_trending_tracks** (Label) - Base View: `int_dbt_prod_tiktok_trending_tracks` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.TIKTOK_TRENDING_TRACKS **int_dbt_prod_weekly_trending_genres_tiktok** (Transaction Country) - Base View: `int_dbt_prod_weekly_trending_genres_tiktok` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_GENRES_TIKTOK #### Model: dbt_trending_tracks **int_dbt_prod_weekly_trending_tracks_uk_spotify** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_uk_spotify` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_spotify **int_dbt_prod_weekly_trending_tracks_uk_spotify_collection** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_uk_spotify_collection` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_spotify_collection_streams **int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_spotify_3rdparty_and_user_playlists... **int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_spotify_lean_fwd_streams **int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_spotify_long_tail **int_dbt_prod_spotify_3rd_party_playlist_spt_last_week** (Transaction Country) - Base View: `int_dbt_prod_spotify_3rd_party_playlist_spt_last_week` - View Type: Direct Table - Data Source: intelligence.dbt_prod.spotify_3rd_party_playlist_spt_last_week **int_dbt_prod_weekly_trending_tracks_amazon** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_amazon` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_amazon **int_dbt_prod_weekly_trending_tracks_amazon_collection** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_amazon_collection` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_amazon_collection_streams **int_dbt_prod_weekly_trending_tracks_amazon_lean_fwd** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_amazon_lean_fwd` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_amazon_lean_fwd_streams **int_dbt_prod_weekly_trending_tracks_amazon_user_playlist** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_amazon_user_playlist` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_amazon_user_playlist_streams **int_dbt_prod_weekly_trending_tracks_amazon_long_tail** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_amazon_long_tail` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_amazon_long_tail **int_dbt_prod_weekly_trending_tracks_apple** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_apple` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_apple **int_dbt_prod_weekly_trending_tracks_apple_discovery_streams** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_apple_discovery_streams` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_apple_discovery_streams **int_dbt_prod_weekly_trending_tracks_apple_library_streams** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_apple_library_streams` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_apple_library_streams **int_dbt_prod_weekly_trending_tracks_apple_long_tail** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_apple_long_tail` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_apple_long_tail **int_dbt_prod_weekly_trending_tracks_apple_search_streams** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_apple_search_streams` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_apple_search_streams **int_dbt_prod_weekly_trending_tracks_apple_voice_streams** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_apple_voice_streams` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_tracks_apple_voice_streams **int_dbt_prod_weekly_trending_tracks_spotify_continent** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_spotify_continent` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_TRACKS_SPOTIFY_CONTINENT_LEVEL **int_dbt_prod_weekly_trending_tracks_combined_tiktok** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_combined_tiktok` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.weekly_trending_tracks_combined_tiktok **int_dbt_prod_weekly_trending_genres_spotify** (Transaction Country) - Base View: `int_dbt_prod_weekly_trending_genres_spotify` - View Type: Direct Table - Data Source: intelligence.dbt_prod.weekly_trending_genres_spotify **int_dbt_prod_weekly_trending_tracks_awa** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_awa` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_TRACKS_AWA **int_dbt_prod_weekly_trending_tracks_deezer** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_deezer` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_TRACKS_DEEZER **int_dbt_prod_weekly_trending_tracks_line** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_line` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_TRACKS_LINE **int_dbt_prod_weekly_trending_tracks_pandora** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_pandora` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_TRACKS_PANDORA **int_dbt_prod_weekly_trending_tracks_soundcloud** (Label) - Base View: `int_dbt_prod_weekly_trending_tracks_soundcloud` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_TRACKS_SOUNDCLOUD #### Model: deezer_fraud **int_dbt_deezer_fraud_report** (Deezer Fraud Detection) - Base View: `int_dbt_deezer_fraud_report` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DEEZER_FRAUD_REPORT #### Model: dim_lookups **facts_prod_dim_country** (Country) - Base View: `facts_prod_dim_country` - View Type: Direct Table - Data Source: facts.prod.dim_country **facts_prod_dim_store** (Store) - Base View: `facts_prod_dim_store` - View Type: Direct Table - Data Source: facts.prod.dim_store **facts_prod_dim_transactiontype** (Transaction Type) - Base View: `facts_prod_dim_transactiontype` - View Type: Direct Table - Data Source: facts.prod.dim_transactiontype **facts_prod_dim_period** (Period) - Base View: `facts_prod_dim_period` - View Type: Direct Table - Data Source: facts.prod.dim_period **int_prod_store_genre_subgenre_mappings** (Store Genre Mappings) - Base View: `int_prod_store_genre_subgenre_mappings` - View Type: Direct Table - Data Source: Unknown **orch_app_ar_vendor** (Label) - Base View: `orch_app_ar_vendor` - View Type: Direct Table - Data Source: royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor **facts_prod_spotify_tracks** (Track) - Base View: `facts_prod_spotify_tracks` - View Type: Direct Table - Data Source: facts.prod.spotify_tracks #### Model: direct_delivery **orch_app_dd_customer_master_master** (Delivery Batch Detail) - Base View: `orch_app_dd_customer_master_master` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Customer_Master_Master, Orchard_A... #### Model: dt_awa_units_by_day **awa_internal_availability** (awa_internal_availability) - Base View: `awa_internal_availability` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Day, Prod.Dim_Licensor, Prod.Fact_Analytics #### Model: dt_blacklist_words **dt_blacklist_words** (Metadata) - Base View: `dt_blacklist_words` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A... #### Model: dt_chargeback_reconciliation **dt_chargeback_reconciliation** (dt_chargeback_reconciliation) - Base View: `dt_chargeback_reconciliation` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Currencies, Art_Relations_Prod_Ar... #### Model: dt_fact_sales_market_share_brazil **dt_fact_sales_market_share_brazil** (Market Share Brazil Query) - Base View: `dt_fact_sales_market_share_brazil` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Base_Dim_Country, Dbt_Prod.Bas... #### Model: dt_label_balances **facts_prod_vw_workstation_summary** (Orchard/AWAL Tiers) - Base View: `facts_prod_vw_workstation_summary` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.PROD.VW_WORKSTATION_SUMMARY_UNIFIED **dt_label_balances** (dt_label_balances) - Base View: `dt_label_balances` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Currencies, Art_Relations_Prod_Ar... #### Model: dt_playlisting_by_track **dt_playlisting_by_track** (Label) - Base View: `dt_playlisting_by_track` - View Type: Derived Table - Data Source: Derived from: Coalesced_Placements, Coalesced_Placements_Amazon_Grouped_By_Playl... #### Model: dt_soundcloud_units_by_day **dt_soundcloud_units_by_day** (dt_soundcloud_units_by_day) - Base View: `dt_soundcloud_units_by_day` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Day, Prod.Dim_Licensor, Prod.Fact_Analytics #### Model: etl_monitor_accounting **dt_etl_monitor_accounting** (Accounting ETL Monitor) - Base View: `dt_etl_monitor_accounting` - View Type: Derived Table - Data Source: Derived from: Bi.Accounting_Aggregates, Prod.Workstation_Fact_Sales_Unified_Dbt,... #### Model: facebook_urls **orch_app_ar_participant_external_link** (Label) - Base View: `orch_app_ar_participant_external_link` - View Type: Direct Table - Data Source: orchard_app_reporting_v2.art_relations_prod_art_relations.participant_external_l... #### Model: feature_controls **orch_app_ar_vendor** (Owner) - Base View: `orch_app_ar_vendor` - View Type: Direct Table - Data Source: royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor **dt_vendor_enabled_features** (Label) - Base View: `dt_vendor_enabled_features` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Vendor_Restricted_Features, Orcha... #### Model: finance_export_uk **dt_finance_export_uk** (Revenue Export for UK) - Base View: `dt_finance_export_uk` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_FINANCE_EXPORT_UK #### Model: finance_label_advances_balances **dt_finance_advance_recouped_balances** (Label) - Base View: `dt_finance_advance_recouped_balances` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Owner, Orchard_App_Reporting_V2.A... #### Model: financial_reports **facts_prod_staging_raw_apple_music_footer** (Apple Vendor) - Base View: `facts_prod_staging_raw_apple_music_footer` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_APPLE_MUSIC_FOOTER **facts_prod_staging_raw_apple_music_linear_radio_service** (Apple Vendor) - Base View: `facts_prod_staging_raw_apple_music_linear_radio_service` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_APPLE_MUSIC_LINEAR_RADIO_SERVICE **facts_prod_staging_raw_apple_music_royalty_calculation** (Apple Vendor) - Base View: `facts_prod_staging_raw_apple_music_royalty_calculation` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_APPLE_MUSIC_ROYALTY_CALCULATION **facts_prod_staging_raw_apple_music_summary** (Apple Vendor) - Base View: `facts_prod_staging_raw_apple_music_summary` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_APPLE_MUSIC_SUMMARY **facts_prod_staging_raw_youtube_monthly_red_label_music_summary** (YouTube Financial Reports) - Base View: `facts_prod_staging_raw_youtube_monthly_red_label_music_summary` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_SUMMARY_V1_1__MUSIC_SUMMARY **facts_prod_staging_raw_youtube_monthly_red_label_non_music_summary** (YouTube Financial Reports) - Base View: `facts_prod_staging_raw_youtube_monthly_red_label_non_music_summary` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_SUMMARY_V1_1__NON_MUSIC_SUMMARY **facts_prod_staging_raw_youtube_monthly_red_label_subscriber_summary** (YouTube Financial Reports) - Base View: `facts_prod_staging_raw_youtube_monthly_red_label_subscriber_summary` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_SUMMARY_V1_1__SUBSCRIBER_SUMMAR... **facts_prod_staging_raw_youtube_monthly_report_v1_0_summary** (YouTube Financial Reports) - Base View: `facts_prod_staging_raw_youtube_monthly_report_v1_0_summary` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_YOUTUBE_MONTHLY_REPORT_V1_0__SUMMARY **facts_prod_staging_raw_youtube_monthly_report_v1_0_summary_by_country** (YouTube Financial Reports) - Base View: `facts_prod_staging_raw_youtube_monthly_report_v1_0_summary_by_country` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_YOUTUBE_MONTHLY_REPORT_V1_0__SUMMARY_BY_COUNTRY **facts_prod_staging_raw_youtube_monthly_report_v1_0_summary_by_day** (YouTube Financial Reports) - Base View: `facts_prod_staging_raw_youtube_monthly_report_v1_0_summary_by_day` - View Type: Direct Table - Data Source: FACTS.PROD.STAGING_RAW_YOUTUBE_MONTHLY_REPORT_V1_0__SUMMARY_BY_DAY #### Model: genre_benchmarking **dt_genre_benchmarking** (dt_genre_benchmarking) - Base View: `dt_genre_benchmarking` - View Type: Direct Table - Data Source: intelligence.prod.avg_units_by_genre_store_country_daily **dt_genre_benchmarking_median** (dt_genre_benchmarking_median) - Base View: `dt_genre_benchmarking_median` - View Type: Direct Table - Data Source: intelligence.prod.median_units_by_genre_store_country_daily **dt_genre_benchmarking_streams_by_day** (dt_genre_benchmarking_streams_by_day) - Base View: `dt_genre_benchmarking_streams_by_day` - View Type: Direct Table - Data Source: intelligence.prod.genre_streaming_by_day #### Model: genre_mappings **dt_genre_mappings** (dt_genre_mappings) - Base View: `dt_genre_mappings` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.DT_GENRE_MAPPINGS #### Model: global_certification **dt_global_certification** (Global Certification) - Base View: `dt_global_certification` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Isrc, Prod.Dim_Release **dt_global_certifications_by_country** (Global Certifications) - Base View: `dt_global_certifications_by_country` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Isrc, Prod.Dim_Release **dt_global_track_certifications_by_country** (Global Certifications) - Base View: `dt_global_track_certifications_by_country` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Isrc, Prod.Dim_Release #### Model: holiday_trending_report **holiday_trending_report** (Holiday Trending Report) - Base View: `holiday_trending_report` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: instagram_spike_stats **int_prod_instagram_spike_stats** (int_prod_instagram_spike_stats) - Base View: `int_prod_instagram_spike_stats` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.INSTAGRAM_SPIKE_STATS **int_prod_social_spike_stats** (int_prod_social_spike_stats) - Base View: `int_prod_social_spike_stats` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.SOCIAL_SPIKE_STATS **facts_prod_social_spike_stats** (facts_prod_social_spike_stats) - Base View: `facts_prod_social_spike_stats` - View Type: Direct Table - Data Source: facts.prod.social_spike_stats #### Model: instagram_statistics **instagram_statistics** (instagram_statistics) - Base View: `instagram_statistics` - View Type: Derived Table - Data Source: Derived from: Dev_Engineering, Dev_Engineering.Npalchinskiy, Dt_Instagram_Engage... #### Model: invalid_references **dt_invalid_references_gameplay_words** (dt_invalid_references_gameplay_words) - Base View: `dt_invalid_references_gameplay_words` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_INVALID_REFERENCES_GAMEPLAY_WORDS **dt_invalid_references_sample_pack_words** (dt_invalid_references_sample_pack_words) - Base View: `dt_invalid_references_sample_pack_words` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_INVALID_REFERENCES_SAMPLE_PACK_WORDS #### Model: invalid_track_writer **dt_invalid_track_writer** (Invalid Track Writer) - Base View: `dt_invalid_track_writer` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_INVALID_TRACK_WRITER #### Model: itunes_hides **prod_hidden_content_itunes_hidden** (iTunes Hide) - Base View: `prod_hidden_content_itunes_hidden` - View Type: Derived Table - Data Source: prod.hidden_content.itunes_hidden #### Model: itunes_tickets **facts_prod_itunes_tickets** (iTunes Ticket) - Base View: `facts_prod_itunes_tickets` - View Type: Direct Table - Data Source: facts.prod.itunes_tickets #### Model: kemado_weekly_reports **int_dbt_prod_kemado_all_time_streams** (int_dbt_prod_kemado_all_time_streams) - Base View: `int_dbt_prod_kemado_all_time_streams` - View Type: Direct Table - Data Source: intelligence.dbt_prod.kemado_all_time_streams **int_dbt_prod_kemado_streams_last_18_months_releases** (int_dbt_prod_kemado_streams_last_18_months_releases) - Base View: `int_dbt_prod_kemado_streams_last_18_months_releases` - View Type: Direct Table - Data Source: intelligence.dbt_prod.kemado_streams_last_18_months_releases #### Model: label_contracts **int_dbt_prod_latest_label_contracts** (Label Contract Audit) - Base View: `int_dbt_prod_latest_label_contracts` - View Type: Direct Table - Data Source: intelligence.dbt_prod.latest_contracts #### Model: label_level_contribution_to_change **label_level_contribution_to_change** (Label) - Base View: `label_level_contribution_to_change` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **label_country_level_contribution_to_change** (Label) - Base View: `label_country_level_contribution_to_change` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **label_artist_level_contribution_to_change** (Label) - Base View: `label_artist_level_contribution_to_change` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **label_store_level_contribution_to_change** (Label) - Base View: `label_store_level_contribution_to_change` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **label_source_level_contribution_to_change** (Label) - Base View: `label_source_level_contribution_to_change` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **label_release_level_contribution_to_change** (Label) - Base View: `label_release_level_contribution_to_change` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **label_track_level_contribution_to_change** (Label) - Base View: `label_track_level_contribution_to_change` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: label_manager_control_panel **int_dbt_prod_lmcp_upcoming_new_releases** (Upcoming New Releases) - Base View: `int_dbt_prod_lmcp_upcoming_new_releases` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_UPCOMING... **int_dbt_prod_lmcp_fact_analytics_last_3_weeks** (Fact analytics Last 3 Weeks) - Base View: `int_dbt_prod_lmcp_fact_analytics_last_3_weeks` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."FACT_ANALYTICS_LAST_3_WEE... **int_dbt_prod_lmcp_lmcp_active_releases** (Active Releases) - Base View: `int_dbt_prod_lmcp_lmcp_active_releases` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_ACTIVE_R... **int_dbt_prod_lmcp_assigned_labels** (Assigned Labels) - Base View: `int_dbt_prod_lmcp_assigned_labels` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_ASSIGNED... **int_dbt_prod_lmcp_lm_name** (LM Name) - Base View: `int_dbt_prod_lmcp_lm_name` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_LM_NAME" **int_dbt_prod_lmcp_new_releases_in_label_processing** (New Releases in Label Processing) - Base View: `int_dbt_prod_lmcp_new_releases_in_label_processing` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_NEW_RELE... **int_dbt_prod_lmcp_shazam_activity** (Shazam Activity) - Base View: `int_dbt_prod_lmcp_shazam_activity` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_SHAZAM_A... **int_dbt_prod_lmcp_tiktok_top_tracks** (TikTok top Tracks) - Base View: `int_dbt_prod_lmcp_tiktok_top_tracks` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TIKTOK_T... **int_dbt_prod_lmcp_top_labels** (Top Labels) - Base View: `int_dbt_prod_lmcp_top_labels` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TOP_LABE... **int_dbt_prod_lmcp_top_overall_tracks** (Top Overall Tracks) - Base View: `int_dbt_prod_lmcp_top_overall_tracks` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TOP_OVER... **int_dbt_prod_lmcp_top_playlists_radio** (Top Playlists Radio) - Base View: `int_dbt_prod_lmcp_top_playlists_radio` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TOP_PLAY... **int_dbt_prod_lmcp_top_overall_releases** (Top Overall Releases) - Base View: `int_dbt_prod_lmcp_top_overall_releases` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TOP_OVER... #### Model: label_manager_insights **dt_label_manager_insights** (Label) - Base View: `dt_label_manager_insights` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_LABEL_MANAGER_INSIGHTS #### Model: label_manager_insights_temp **dt_label_manager_insights_temp** (Label Manager Insights) - Base View: `dt_label_manager_insights_temp` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_LABEL_MANAGER_INSIGHTS_TEMP #### Model: label_manager_territory_map **dev_engineering_ccapalbo_label_manager_territory_map** (Label Manager Map) - Base View: `dev_engineering_ccapalbo_label_manager_territory_map` - View Type: Direct Table - Data Source: DEV_ENGINEERING.CCAPALBO.LABEL_MANAGER_TERRITORY_MAP #### Model: label_offering **label_offering** (label_offering) - Base View: `label_offering` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."LABEL_OFFERING" #### Model: label_streaming_anomalies **int_dbt_prod_label_anomalies_monthly** (Label) - Base View: `int_dbt_prod_label_anomalies_monthly` - View Type: Direct Table - Data Source: intelligence.dbt_prod.label_anomalies_monthly **int_dbt_prod_label_country_monthly_ctc** (Country Monthly CTC) - Base View: `int_dbt_prod_label_country_monthly_ctc` - View Type: Direct Table - Data Source: intelligence.dbt_prod.label_country_monthly_ctc **int_dbt_prod_label_store_monthly_ctc** (Store Monthly CTC) - Base View: `int_dbt_prod_label_store_monthly_ctc` - View Type: Direct Table - Data Source: intelligence.dbt_prod.label_store_monthly_ctc **int_dbt_prod_label_artist_monthly_ctc** (Artist Monthly CTC) - Base View: `int_dbt_prod_label_artist_monthly_ctc` - View Type: Direct Table - Data Source: intelligence.dbt_prod.label_artist_monthly_ctc **int_dbt_prod_label_source_monthly_ctc** (Source Monthly CTC) - Base View: `int_dbt_prod_label_source_monthly_ctc` - View Type: Direct Table - Data Source: intelligence.dbt_prod.label_source_monthly_ctc **int_dbt_prod_label_upc_monthly_ctc** (UPC Monthly CTC) - Base View: `int_dbt_prod_label_upc_monthly_ctc` - View Type: Direct Table - Data Source: intelligence.dbt_prod.label_upc_monthly_ctc **int_dbt_prod_label_isrc_monthly_ctc** (ISRC Monthly CTC) - Base View: `int_dbt_prod_label_isrc_monthly_ctc` - View Type: Direct Table - Data Source: intelligence.dbt_prod.label_isrc_monthly_ctc #### Model: listeners_by_stream_count **dt_listeners_by_stream_count** (dt_listeners_by_stream_count) - Base View: `dt_listeners_by_stream_count` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Track, Orchard_App_Reporting_V2, ... #### Model: looker_history_monitoring **prod_looker_user_history** (prod_looker_user_history) - Base View: `prod_looker_user_history` - View Type: Direct Table - Data Source: "INTELLIGENCE"."PROD_LOOKER_HISTORY"."PROD_LOOKER_USER_HISTORY" **prod_perf_by_user_group** (prod_perf_by_user_group) - Base View: `prod_perf_by_user_group` - View Type: Direct Table - Data Source: "INTELLIGENCE"."PROD_LOOKER_HISTORY"."PROD_PERF_BY_USER_GROUP" **prod_looker_connection_query_history** (prod_looker_connection_query_history) - Base View: `prod_looker_connection_query_history` - View Type: Direct Table - Data Source: "INTELLIGENCE"."PROD_LOOKER_HISTORY"."PROD_LOOKER_CONNECTION_QUERY_HISTORY" **prod_looker_total_query_history** (prod_looker_total_query_history) - Base View: `prod_looker_total_query_history` - View Type: Direct Table - Data Source: "INTELLIGENCE"."PROD_LOOKER_HISTORY"."PROD_LOOKER_TOTAL_QUERY_HISTORY" #### Model: luminate_global_reports **int_dbt_prod_luminate_global_artist** (Global Top 20K Artists Report) - Base View: `int_dbt_prod_luminate_global_artist` - View Type: Direct Table - Data Source: intelligence.dbt_prod.luminate_global_artist **int_dbt_prod_luminate_global_song** (Global Top 50K Songs Report) - Base View: `int_dbt_prod_luminate_global_song` - View Type: Direct Table - Data Source: intelligence.dbt_prod.luminate_global_song **int_dbt_prod_luminate_global_isrc** (Global Top 100K ISRCs Report) - Base View: `int_dbt_prod_luminate_global_isrc` - View Type: Direct Table - Data Source: intelligence.dbt_prod.luminate_global_isrc #### Model: market_share_temp **facts_prod_fact_market_share** (Country) - Base View: `facts_prod_fact_market_share` - View Type: Direct Table - Data Source: facts.prod.fact_market_share **dt_fact_sales_market_share** (Label) - Base View: `dt_fact_sales_market_share` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.DT_FACT_SALES_MARKETSHARE **dt_fact_sales_market_share_artist_level** (Label) - Base View: `dt_fact_sales_market_share_artist_level` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_FACT_SALES_MARKET_SHARE_ARTIST_LEVEL **dt_market_share_change** (Market Share Change) - Base View: `dt_market_share_change` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: marketing_change_log **dt_marketing_change_log** (Deliverable for Release) - Base View: `dt_marketing_change_log` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_MARKETING_CHANGE_LOG **int_prod_rcl_release_change_log** (Release) - Base View: `int_prod_rcl_release_change_log` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.RCL_RELEASE_CHANGE_LOG **int_prod_rcl_track_ig_changes** (Track) - Base View: `int_prod_rcl_track_ig_changes` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.RCL_TRACK_IG_CHANGES #### Model: master_calendar **facts_prod_dim_day** (dim_day) - Base View: `facts_prod_dim_day` - View Type: Direct Table - Data Source: facts.prod.dim_day **metadata_simplified** (metadata_simplified) - Base View: `metadata_simplified` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Metadata_Simplified, Intelligence.Dbt_Prod **nav** (nav) - Base View: `nav` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: master_calendar_sme **facts_prod_dim_day** (dim_day_sme) - Base View: `facts_prod_dim_day` - View Type: Direct Table - Data Source: facts.prod.dim_day #### Model: master_rights_audit **dt_master_rights_audit** (Track) - Base View: `dt_master_rights_audit` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_MASTER_RIGHTS_AUDIT #### Model: meta_analytics **meta_analytics** (Meta Analytics) - Base View: `meta_analytics` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Meta.Staging_Raw_Meta_Consumption, Meta... #### Model: meta_update **meta_update_queue** (Meta Update Queue) - Base View: `meta_update_queue` - View Type: Direct Table - Data Source: ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.META_UPDATE_QUEUE #### Model: metrics_by_channel_country **facts_prod_metrics_by_channel_country_feed_distributor_rollup** (YouTube Channel Metrics) - Base View: `facts_prod_metrics_by_channel_country_feed_distributor_rollup` - View Type: Direct Table - Data Source: facts.prod.metrics_by_channel_country_feed_distributor_rollup #### Model: millward_brown_reporting **int_dbt_prod_millward_brown_upc_list** (Release) - Base View: `int_dbt_prod_millward_brown_upc_list` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.MILLWARD_BROWN_UPC_LIST #### Model: missing_track_duration **dt_missing_track_duration** (dt_missing_track_duration) - Base View: `dt_missing_track_duration` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.DT_MISSING_TRACK_DURATION #### Model: mobile_analytics **dt_mobile_app_opened** (Application Opened) - Base View: `dt_mobile_app_opened` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Art_Relations_Prod_Art_R... #### Model: moments **dev_eng_eimpara_fouriertable_jul_sept_22** (Track) - Base View: `dev_eng_eimpara_fouriertable_jul_sept_22` - View Type: Direct Table - Data Source: Unknown **dev_eng_eimpara_fouriertable_apr_sept_22** (Track) - Base View: `dev_eng_eimpara_fouriertable_apr_sept_22` - View Type: Direct Table - Data Source: Unknown **dev_eng_eimpara_fouriertable_feb_sept_22** (Track) - Base View: `dev_eng_eimpara_fouriertable_feb_sept_22` - View Type: Direct Table - Data Source: Unknown **dt_project_moments_cluster_groups_140_days** (Moments - Cluster Groups) - Base View: `dt_project_moments_cluster_groups_140_days` - View Type: Derived Table - Data Source: Derived from: Dev_Engineering, Dev_Engineering.Eimpara, Eimpara.Moments_Clusters... **dt_project_moments_pred_vs_actual_140_days** (Moments - Actual vs Predicted) - Base View: `dt_project_moments_pred_vs_actual_140_days` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD_PROJECT_MOMENTS.PROJECT_MOMENTS_SPOTIFY_ACTUAL_VS_PREDICTE... **dt_project_moments_cluster_group_audio_upper_x_lower_bounds** (Moments - Cluster Groups Audio Profiles) - Base View: `dt_project_moments_cluster_group_audio_upper_x_lower_bounds` - View Type: Derived Table - Data Source: Derived from: Audio_Feature_Cluster_Profile, Cluster_Groups, Dbt_Prod.Spotify_Tr... **dt_project_moments_cluster_groups_v2_fuzzy_logic** (Moments - Cluster Groups - Version 2) - Base View: `dt_project_moments_cluster_groups_v2_fuzzy_logic` - View Type: Derived Table - Data Source: Derived from: Dev_Engineering, Dev_Engineering.Eimpara, Eimpara.Moments_Clusters... **dt_project_moments_cluster_group_audio_upper_x_lower_bounds_v2_fuzzy_logic** (Moments - Cluster Groups Audio Profiles - Version 2) - Base View: `dt_project_moments_cluster_group_audio_upper_x_lower_bounds_v2_fuzzy_logic` - View Type: Derived Table - Data Source: Derived from: Audio_Feature_Cluster_Profile, Cluster_Groups, Dbt_Prod.Spotify_Tr... **dt_project_moments_som_cluster_groups** (Moments - Cluster Groups - SOM Clusters) - Base View: `dt_project_moments_som_cluster_groups` - View Type: Derived Table - Data Source: Derived from: Dev_Engineering, Dev_Engineering.Eimpara, Eimpara.Moments_Clusters... **dt_project_moments_cluster_groups_audio_upper_x_lower_bounds_som_logic** (Moments - Cluster Groups Audio Profiles - SOM Clusters) - Base View: `dt_project_moments_cluster_groups_audio_upper_x_lower_bounds_som_logic` - View Type: Derived Table - Data Source: Derived from: Audio_Feature_Cluster_Profile, Cluster_Groups, Dbt_Prod.Spotify_Tr... **int_dbt_prod_moments_watchlist** (Moments Watchlist Info) - Base View: `int_dbt_prod_moments_watchlist` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD_PROJECT_MOMENTS.PROJECT_MOMENTS_WATCHLIST_INFO **dt_project_moments_fuzzy_cluster_v4** (Moments - Cluster Groups - Version 4) - Base View: `dt_project_moments_fuzzy_cluster_v4` - View Type: Derived Table - Data Source: Derived from: Dev_Engineering, Dev_Engineering.Eimpara, Eimpara.Moments_Clusters... **dt_project_moments_cluster_group_upper_x_lower_bounds_fuzzy_v4** (Moments - Cluster Groups Audio Profiles - Version 4) - Base View: `dt_project_moments_cluster_group_upper_x_lower_bounds_fuzzy_v4` - View Type: Derived Table - Data Source: Derived from: Audio_Feature_Cluster_Profile, Cluster_Groups, Dbt_Prod.Spotify_Tr... **int_dev_tallman_moments_performance_groups_v1** (K Proto Copy) - Base View: `int_dev_tallman_moments_performance_groups_v1` - View Type: Direct Table - Data Source: intelligence.dbt_prod_project_moments.project_moments_track_groupings_info **project_moments_ma_calculation** (Artist) - Base View: `project_moments_ma_calculation` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD_PROJECT_MOMENTS.project_moments_ma_calculation_key_identif... **project_moments_hedra_output_table** (Project Moments Hedra) - Base View: `project_moments_hedra_output_table` - View Type: Direct Table - Data Source: intelligence.dbt_prod_project_moments.hedra_output **project_moments_hedra_output_140_days_table** (Project Moments Hedra) - Base View: `project_moments_hedra_output_140_days_table` - View Type: Direct Table - Data Source: intelligence.dbt_prod_project_moments.hedra_output_140_days **uniti_recommends_refined** (Uniti Recommends) - Base View: `uniti_recommends_refined` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD_PROJECT_MOMENTS".uniti_recommends_v3 **dt_project_moments_uniti_graphical_representation** (Uniti Recommends Graph) - Base View: `dt_project_moments_uniti_graphical_representation` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Summary_Streams, Dbt_Prod_Project_Moments.Uniti_Recommend... #### Model: one_pager **dt_top_5_countries** (dt_top_5_countries) - Base View: `dt_top_5_countries` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country, Prod.Workstation_Fact_Sales_Unified_Dbt, Royalty... **dt_top_5_stores** (dt_top_5_stores) - Base View: `dt_top_5_stores` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Store, Prod.Workstation_Fact_Sales_Unified_Dbt, Royalty_A... #### Model: orca_a_and_lp **int_dbt_prod_orca_a_and_lp_dataset** (Time Series Info) - Base View: `int_dbt_prod_orca_a_and_lp_dataset` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.ORCA_A_AND_LP_DATASET #### Model: pandora_sos **facts_prod_staging_raw_pandora** (Pandora SOS) - Base View: `facts_prod_staging_raw_pandora` - View Type: Direct Table - Data Source: facts.prod.staging_raw_pandora **order_items** (order_items) - Base View: `order_items` - View Type: Direct Table - Data Source: Unknown #### Model: performance_rights_delivery_history **int_prod_vw_performance_rights_delivery_history** (Track) - Base View: `int_prod_vw_performance_rights_delivery_history` - View Type: Direct Table - Data Source: intelligence.prod.vw_performance_rights_delivery_history #### Model: performance_rights_sales **prs_prod_sx_sales** (Statement Detail) - Base View: `prs_prod_sx_sales` - View Type: Direct Table - Data Source: performance_rights_sales.prod.soundexchange_sales_stmt **prs_prod_ppl_sales** (Statement Detail) - Base View: `prs_prod_ppl_sales` - View Type: Direct Table - Data Source: performance_rights_sales.prod.ppl_sales_stmt #### Model: ph_audit_model **ph_audit_merlinrebates** (ph_audit_merlinrebates) - Base View: `ph_audit_merlinrebates` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country, Prod.Dim_Label, Prod.Dim_Release, Prod.Workstati... **ph_audit_ph_usage_fact_sales** (ph_audit_ph_usage_fact_sales) - Base View: `ph_audit_ph_usage_fact_sales` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country, Prod.Dim_Label, Prod.Dim_Release, Prod.Workstati... **ph_audit_phonofile_rebates_from_ph_db** (ph_audit_phonofile_rebates_from_ph_db) - Base View: `ph_audit_phonofile_rebates_from_ph_db` - View Type: Derived Table - Data Source: Derived from: Dev.Digital_Sale, Dev.Sale_Type, Dev.Usage_Type, Dev.Z_Company_Rol... #### Model: physical **orch_app_ar_product_physical** (Physical Product) - Base View: `orch_app_ar_product_physical` - View Type: Direct Table - Data Source: orchard_app_reporting_v2.art_relations_prod_art_relations.product_physical #### Model: physical_accounting_all_sales **int_prod_physical_accounting_all_sales** (All Sales) - Base View: `int_prod_physical_accounting_all_sales` - View Type: Direct Table - Data Source: intelligence.prod.physical_accounting_all_sales #### Model: physical_eu **physical_eu** (Physical EU) - Base View: `physical_eu` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: playlist_placements_analysis **facts_prod_recent_placements_by_track_playlist_country_feed_hourly** (facts_prod_recent_placements_by_track_playlist_country_feed_hourly) - Base View: `facts_prod_recent_placements_by_track_playlist_country_feed_hourly` - View Type: Direct Table - Data Source: Unknown #### Model: podcast_analytics **facts_prod_staging_raw_megaphone** (Episode) - Base View: `facts_prod_staging_raw_megaphone` - View Type: Direct Table - Data Source: facts.prod.staging_raw_megaphone #### Model: pre_save_data **fact_prod_staging_raw_apple_music_totallibraryadds** (Pre Save Data) - Base View: `fact_prod_staging_raw_apple_music_totallibraryadds` - View Type: Direct Table - Data Source: "FACTS"."PROD"."STAGING_RAW_APPLE_MUSIC_TOTALLIBRARYADDS" #### Model: prod_ows_monitoring **dt_prod_ows_warehouse_monitoring** (dt_prod_ows_warehouse_monitoring) - Base View: `dt_prod_ows_warehouse_monitoring` - View Type: Derived Table - Data Source: Derived from: Account_Usage.Query_History, Snowflake.Account_Usage #### Model: product_manager_control_panel **int_dbt_prod_pmcp_shazam_activity** (Shazam Activity) - Base View: `int_dbt_prod_pmcp_shazam_activity` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."SHAZAM_ACITIVITY" **int_dbt_prod_pmcp_tiktok_top_tracks** (TikTok Top Tracks) - Base View: `int_dbt_prod_pmcp_tiktok_top_tracks` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."TIKTOK_TOP_TRACKS" **int_dbt_prod_pmcp_revenue_last_12_months** (Revenue Last 12 Months) - Base View: `int_dbt_prod_pmcp_revenue_last_12_months` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."REVENUE_LAST_12_MONTHS" **int_dbt_prod_pmcp_top_playlist_radio_station** (Top Playlist/Radio Station) - Base View: `int_dbt_prod_pmcp_top_playlist_radio_station` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."TOP_PLAYLIST_RADIO_STATION" **int_dbt_prod_pmcp_top_10_labels_last_12_months** (Top 10 Labels last 12 Months) - Base View: `int_dbt_prod_pmcp_top_10_labels_last_12_months` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."TOP_10_LABEL_LAST_12_MONTHS" **int_dbt_prod_pmcp_top_streamed_tracks_all_time** (Artist) - Base View: `int_dbt_prod_pmcp_top_streamed_tracks_all_time` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."TOP_STREAMED_TRACKS_ALL_TIME" **int_dbt_prod_pmcp_top_streamed_releases_all_time** (Artist) - Base View: `int_dbt_prod_pmcp_top_streamed_releases_all_time` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."TOP_STREAMED_RELEASES_ALL_TIME" **int_dbt_prod_pmcp_top_10_countries_last_12_months** (Top 10 Countries Last 12 Months) - Base View: `int_dbt_prod_pmcp_top_10_countries_last_12_months` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."TOP_10_COUNTRIES_LAST_12_MONTHS" **int_dbt_prod_pmcp_top_streamed_new_tracks_last_4_months** (Artist) - Base View: `int_dbt_prod_pmcp_top_streamed_new_tracks_last_4_months` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."TOP_STREAMED_NEW_TRACKS_LAST_4_MONTHS" **int_dbt_prod_pmcp_top_streamed_new_releases_last_4_months** (Artist) - Base View: `int_dbt_prod_pmcp_top_streamed_new_releases_last_4_months` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."TOP_STREAMED_NEW_RELEASES_LAST_4_MONTHS" #### Model: product_territory_split **dt_product_territory_splits** (Custom) - Base View: `dt_product_territory_splits` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A... #### Model: project_maze **dbt_prod_spotify_top_200_predictions_weekly** (Spotify Top 200 Chart Predictions) - Base View: `dbt_prod_spotify_top_200_predictions_weekly` - View Type: Direct Table - Data Source: intelligence.dbt_prod.spotify_top_200_predictions_weekly **int_dbt_prod_orch_spotify_top_200_chart_appearances** (Maze Chart Appearances) - Base View: `int_dbt_prod_orch_spotify_top_200_chart_appearances` - View Type: Direct Table - Data Source: intelligence.dbt_prod.orch_spotify_top_200_chart_appearances **dt_spotify_top_200_aggregates** (Maze Chart Appearances) - Base View: `dt_spotify_top_200_aggregates` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Orch_Spotify_Top_200_Chart_Appearances, Intelligence.Dbt_... #### Model: promusicae_certification **dt_promusicae_certification_album** (Metadata) - Base View: `dt_promusicae_certification_album` - View Type: Derived Table - Data Source: Derived from: Prod.Fact_Analytics **dt_promusicae_certification_single** (Metadata) - Base View: `dt_promusicae_certification_single` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Track, Prod.Fact_Analytics **dt_promusicae_certification_album_incl_youtube** (Metadata) - Base View: `dt_promusicae_certification_album_incl_youtube` - View Type: Derived Table - Data Source: Derived from: Prod.Fact_Analytics **dt_promusicae_certification_single_incl_youtube** (Metadata) - Base View: `dt_promusicae_certification_single_incl_youtube` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Track, Prod.Fact_Analytics #### Model: proper_changed_releases **dt_proper_changed_releases** (dt_proper_changed_releases) - Base View: `dt_proper_changed_releases` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Delivery_History, Art_Relations_P... #### Model: publishing **facts_prod_global_sound_recording** (Track) - Base View: `facts_prod_global_sound_recording` - View Type: Direct Table - Data Source: FACTS.PROD.GLOBAL_SOUND_RECORDING **publishing_app_compositions_changes** (Publishing) - Base View: `publishing_app_compositions_changes` - View Type: Derived Table - Data Source: Derived from: Qa.Cdc_Musicgraph_Publishingcomposition #### Model: publishing_revenue **royalty_accounting_prod_vw_abacus_fact_sales_publishing** (Publishing Data) - Base View: `royalty_accounting_prod_vw_abacus_fact_sales_publishing` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.PROD.VW_ABACUS_FACT_SALES_PUBLISHING **dt_revenue_by_songwriter** (Publishing Data) - Base View: `dt_revenue_by_songwriter` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Acct_Period, Prod.Publishing_Agre... #### Model: rank_tool **dt_rank_tool** (Rank Tool) - Base View: `dt_rank_tool` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Artist, Prod.Dim_Country, Prod.Dim_Genre, Prod.Dim_Isrc, ... #### Model: red_bull_reports **int_dbt_prod_red_bull_records_streaming_report_all_time** (Date) - Base View: `int_dbt_prod_red_bull_records_streaming_report_all_time` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.RED_BULL_RECORDS_STREAMING_REPORT_ALL_TIME **int_dbt_prod_red_bull_records_streaming_report_last_60_days** (Date) - Base View: `int_dbt_prod_red_bull_records_streaming_report_last_60_days` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.RED_BULL_RECORDS_STREAMING_REPORT_LAST_60_DAYS #### Model: release_compare **dt_release_compare** (Date) - Base View: `dt_release_compare` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: release_compare_datasets **int_dbt_prod_release_compare_model_spotify_store** (Track) - Base View: `int_dbt_prod_release_compare_model_spotify_store` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."RELEASE_COMPARE_MODEL_SPOTIFY_STORE" **int_dbt_prod_release_compare_model_amazon_store** (Track) - Base View: `int_dbt_prod_release_compare_model_amazon_store` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."RELEASE_COMPARE_MODEL_AMAZON_STORE" **int_dbt_prod_release_compare_model_apple_store** (Track) - Base View: `int_dbt_prod_release_compare_model_apple_store` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."RELEASE_COMPARE_MODEL_APPLE_STORE" **int_dbt_prod_release_compare_model_apple_playlist** (Track) - Base View: `int_dbt_prod_release_compare_model_apple_playlist` - View Type: Direct Table - Data Source: "INTELLIGENCE"."DBT_PROD"."RELEASE_COMPARE_MODEL_APPLE_PLAYLIST" #### Model: release_schedule_dashboard **dt_release_schedule_dashboard** (Release Schedule Dashboard) - Base View: `dt_release_schedule_dashboard` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.RELEASE_SCHEDULE_DASHBOARD **int_prod_rsd_release_schedule_dashboard** (Release Restrictions (Territory)) - Base View: `int_prod_rsd_release_schedule_dashboard` - View Type: Direct Table - Data Source: intelligence.prod.rsd_release_schedule_dashboard #### Model: releases_ingested_top_labels **dt_releases_ingested_top_labels** (dt_releases_ingested_top_labels) - Base View: `dt_releases_ingested_top_labels` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Orchard_App_Reporting_V2... #### Model: rev_and_profit_last_12_months **int_dbt_prod_rev_and_profit_last_12_months** (Label) - Base View: `int_dbt_prod_rev_and_profit_last_12_months` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.REV_AND_PROFIT_LAST_24_MONTHS **int_dbt_prod_last_month_accounting_info** (Label) - Base View: `int_dbt_prod_last_month_accounting_info` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.LAST_MONTH_ACCOUNTING_INFO #### Model: revenue_ex_spatial_deliveries **int_dbt_prod_revenue_apple_amazon_ex_spatial_deliveries** (Revenue ex spatial deliveries) - Base View: `int_dbt_prod_revenue_apple_amazon_ex_spatial_deliveries` - View Type: Direct Table - Data Source: intelligence.dbt_prod.revenue_apple_amazon_ex_spatial_deliveries #### Model: riaa_certification **dt_riaa_certification** (Orchard/AWAL Tiers) - Base View: `dt_riaa_certification` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Isrc, Prod.Dim_Release #### Model: riaa_us_certification **int_dbt_prod_riaa_model_certification** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_riaa_model_certification` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.RIAA_CERTIFICATION #### Model: rights_management **int_prod_internal_conflicts** (int_prod_internal_conflicts) - Base View: `int_prod_internal_conflicts` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.INTERNAL_CONFLICTS #### Model: ritmogestion_top_10k_streaming_tracks_weekly **facts_prod_staging_raw_ritmogestion** (facts_prod_staging_raw_ritmogestion) - Base View: `facts_prod_staging_raw_ritmogestion` - View Type: Direct Table - Data Source: intelligence.dbt_prod.ritmogestion_label_countries #### Model: round_hill_streaming_report_request **round_hill_streaming_report_request** (Round Hill Streaming Report Request) - Base View: `round_hill_streaming_report_request` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Summary_Streams, Intelligence.Dbt_Prod, Prod.Dim_Artist, ... #### Model: shazam **facts_prod_staging_raw_shazam** (Event Location) - Base View: `facts_prod_staging_raw_shazam` - View Type: Direct Table - Data Source: facts.prod.staging_raw_shazam **facts_prod_apple_music_shazam_daily_events** (Shazam Events) - Base View: `facts_prod_apple_music_shazam_daily_events` - View Type: Direct Table - Data Source: facts.prod.apple_music_shazam_daily_events #### Model: shazam_daily_events **facts_prod_shazam_daily_events** (Shazam Daily Events) - Base View: `facts_prod_shazam_daily_events` - View Type: Derived Table - Data Source: my_schema_name.tester #### Model: skips_saves **facts_prod_aggregated_skips_and_saves** (Skips & Saves) - Base View: `facts_prod_aggregated_skips_and_saves` - View Type: Direct Table - Data Source: facts.prod.aggregated_skips_and_saves #### Model: sony_aggregate_revenue **sony_internal_prod_orchard_monthly_sap_aggregate_feed_history** (Transaction Country) - Base View: `sony_internal_prod_orchard_monthly_sap_aggregate_feed_history` - View Type: Direct Table - Data Source: sony_internal.prod.orchard_monthly_sap_aggregate_feed_history #### Model: soundcloud-statistics **soundcloud_statistics** (soundcloud_statistics) - Base View: `soundcloud_statistics` - View Type: Direct Table - Data Source: Unknown #### Model: soundexchange_historic_accounting **int_prod_performance_rights_historic_accounting** (Orchard Track) - Base View: `int_prod_performance_rights_historic_accounting` - View Type: Derived Table - Data Source: Derived from: Clean_Table_1, Clean_Table_2, Prod.Performance_Rights_Historic_Acc... #### Model: spotify_daily_top_200_orchard_content **int_dbt_prod_spotify_daily_top_200** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_spotify_daily_top_200` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.SPOTIFY_DAILY_TOP_200 #### Model: spotify_statistics **spotify_statistics** (spotify_statistics) - Base View: `spotify_statistics` - View Type: Derived Table - Data Source: Derived from: Dev_Engineering, Dev_Engineering.Npalchinskiy, Dt_Spotify_Populari... #### Model: spotify_top_200_distributed_content **int_dbt_prod_spotify_top_200_vs_orchard_distributed_content_streams** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_spotify_top_200_vs_orchard_distributed_content_streams` - View Type: Direct Table - Data Source: intelligence.dbt_prod.spotify_top_200_vs_orchard_distributed_content_streams #### Model: statement_db **stmt_db_dig_sales_analytics** (Statement DB) - Base View: `stmt_db_dig_sales_analytics` - View Type: Direct Table - Data Source: dig_sales_analytics **dt_itunes_complete_month_by_service** (iTunes Complete Month by Service) - Base View: `dt_itunes_complete_month_by_service` - View Type: Derived Table - Data Source: Derived from: Dig_Sales_Analytics **stmt_db_pl_storelist** (Report Ingestion List) - Base View: `stmt_db_pl_storelist` - View Type: Direct Table - Data Source: pl_storelist #### Model: store_availability **dt_store_availability_analytics** (Store Availability: Analytics) - Base View: `dt_store_availability_analytics` - View Type: Derived Table - Data Source: Derived from: Filtered_Summary, Prod.Data_Availability_By_Store_Daily, Prod.Dim_... **dt_store_availability_tiktok** (Store Availability: TikTok) - Base View: `dt_store_availability_tiktok` - View Type: Derived Table - Data Source: Derived from: All_Available, Prod.Dim_Day, Prod.Staging_Raw_Tiktok, Prod.Staging... **dt_store_availability_analytics_sme_updated** (Store Availability: SME Analytics) - Base View: `dt_store_availability_analytics_sme_updated` - View Type: Direct Table - Data Source: Unknown **dt_store_availability_shazam** (Store Availability: Shazam) - Base View: `dt_store_availability_shazam` - View Type: Derived Table - Data Source: Derived from: All_Available, Prod.Dim_Day, Prod.Dim_Store, Prod.Shazam_Daily_Eve... **prod_store_avail_store_avail_availability** (Release) - Base View: `prod_store_avail_store_avail_availability` - View Type: Direct Table - Data Source: prod_store_avail.store_avail.availability #### Model: store_backfill_priority **dt_store_backfill_priority** (Store Backfill Priority) - Base View: `dt_store_backfill_priority` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Period, Prod.Dim_Release, Prod.Workstation_Fact_Sales_Uni... #### Model: store_qbr **dt_fact_sales_revenue_buckets** (Revenue Buckets) - Base View: `dt_fact_sales_revenue_buckets` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: stream_share_spotify_weekly **stream_share_spotify_weekly** (Orchard/AWAL Tiers) - Base View: `stream_share_spotify_weekly` - View Type: Direct Table - Data Source: intelligence.dbt_prod.last_week_streamshare_model #### Model: streaming_fraud **int_dbt_prod_weekly_fraudulent_streams_flags_spotify** (User) - Base View: `int_dbt_prod_weekly_fraudulent_streams_flags_spotify` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.FRAUDULENT_STREAMS_FLAGS_SPOTIFY **int_dbt_prod_stg_sos_fraud_spike_over_500_pct** (Label) - Base View: `int_dbt_prod_stg_sos_fraud_spike_over_500_pct` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.STG_SOS_FRAUD_SPIKE_OVER_500_PCT #### Model: streaming_fraud_detection **dt_streaming_fraud_detection** (Streaming Fraud Detection) - Base View: `dt_streaming_fraud_detection` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A... #### Model: subset_data **SUBSET_FOURIER_2023_DATA** (SUBSET FOURIER 2023 DATA) - Base View: `SUBSET_FOURIER_2023_DATA` - View Type: Direct Table - Data Source: DEV_ENGINEERING.eimpara.SUBSET_FOURIER_2023_DATA **SUBSET_ARIMA_2023_DATA** (SUBSET ARIMA 2023 DATA) - Base View: `SUBSET_ARIMA_2023_DATA` - View Type: Direct Table - Data Source: DEV_ENGINEERING.eimpara.SUBSET_ARIMA_2023_DATA **SUBSET_MANUALCLUSTERING_2023_DATA** (SUBSET MANUALCLUSTERING 2023 DATA) - Base View: `SUBSET_MANUALCLUSTERING_2023_DATA` - View Type: Direct Table - Data Source: DEV_ENGINEERING.eimpara.SUBSET_MANUALCLUSTERING_2023_DATA **SUBSET_PREDICTED_VALUES_2023_DATA** (SUBSET PREDICTED VALUES 2023 DATA) - Base View: `SUBSET_PREDICTED_VALUES_2023_DATA` - View Type: Direct Table - Data Source: DEV_ENGINEERING.eimpara.SUBSET_PREDICTED_VALUES_2023_DATA #### Model: summary_sos **facts_prod_summary_sos** (Summary SOS) - Base View: `facts_prod_summary_sos` - View Type: Direct Table - Data Source: facts.prod.summary_sos #### Model: territory_kpis_2 **int_dbt_prod_summary_territory_kpis** (Summary Territory KPIs) - Base View: `int_dbt_prod_summary_territory_kpis` - View Type: Derived Table - Data Source: Derived from: Cy24_Targets, Dbt_Prod.Ifpi_Summary_Territory_Kpis, Dev_Zallard.Te... **int_dbt_prod_monthly_territory_kpis** (Monthly Territory KPIs) - Base View: `int_dbt_prod_monthly_territory_kpis` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **int_dbt_prod_transaction_country_report** (Transaction Country Report) - Base View: `int_dbt_prod_transaction_country_report` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Ifpi_Transaction_Country_Report, Intelligence.Dbt_Prod **int_dbt_prod_label_country_report** (Label Country Report) - Base View: `int_dbt_prod_label_country_report` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Ifpi_Label_Country_Report, Intelligence.Dbt_Prod **int_dbt_prod_transaction_country_report_filterable** (Transaction Country Report (Filterable)) - Base View: `int_dbt_prod_transaction_country_report_filterable` - View Type: Direct Table - Data Source: intelligence.dbt_prod.stg_ifpi_transaction_country_report_filterable #### Model: tiktok_pitch_grid_us **tiktok_pitch_grid_us** (Orchard/AWAL Tiers) - Base View: `tiktok_pitch_grid_us` - View Type: Direct Table - Data Source: intelligence.dbt_prod.tiktok_pitch_grid #### Model: tiktok_top_500_model **facts_prod_staging_raw_tiktok_trends_topsong** (Top Songs) - Base View: `facts_prod_staging_raw_tiktok_trends_topsong` - View Type: Direct Table - Data Source: facts.prod.staging_raw_tiktok_trends_topsong **facts_prod_staging_raw_tiktok_trends_tophashtag** (Top Hashtags) - Base View: `facts_prod_staging_raw_tiktok_trends_tophashtag` - View Type: Direct Table - Data Source: facts.prod.staging_raw_tiktok_trends_tophashtag **facts_prod_staging_raw_tiktok** (Orchard Metadata) - Base View: `facts_prod_staging_raw_tiktok` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AGG_TIKTOK_MODEL #### Model: timed_release **orchard_app_reporting_v2_prod_ows_timed_release_ows_timed_release_schedule_timed_release** (Release) - Base View: `orchard_app_reporting_v2_prod_ows_timed_release_ows_timed_release_schedule_timed_release` - View Type: Direct Table - Data Source: Unknown #### Model: top_playlist_by_country **dt_top_playlist_by_country** (dt_top_playlist_by_country) - Base View: `dt_top_playlist_by_country` - View Type: Derived Table - Data Source: Derived from: Prod.Fact_Analytics #### Model: top_stores_by_artist **dt_top_stores_by_artist** (dt_top_stores_by_artist) - Base View: `dt_top_stores_by_artist` - View Type: Derived Table - Data Source: Derived from: Prod.Fact_Analytics #### Model: top_tracks **dt_top_tracks** (Label) - Base View: `dt_top_tracks` - View Type: Derived Table - Data Source: Derived from: Date_Difference, Prod.Dim_Country **dt_top_tracks_test** (Label) - Base View: `dt_top_tracks_test` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country #### Model: top_tracks_by_artist **dt_top_tracks_by_artist** (dt_top_tracks_by_artist) - Base View: `dt_top_tracks_by_artist` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Releases, Orchard_App_Reporting_V... #### Model: track_compare **dt_track_compare** (Date) - Base View: `dt_track_compare` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Release, Prod.Dim_Track #### Model: track_playlist **track_level_playlisting** (Label) - Base View: `track_level_playlisting` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.TRACK_LEVEL_PLAYLISTING #### Model: trending_tracks_new **dt_trending_tracks** (Trending Tracks) - Base View: `dt_trending_tracks` - View Type: Derived Table - Data Source: Derived from: Prod.Demographics_Region_Mapping_V2 #### Model: tsz_fa **tsz_fa** (Three Six Zero) - Base View: `tsz_fa` - View Type: Direct Table - Data Source: Unknown **facts_prod_aggregated_skips_and_saves** (Skips & Saves) - Base View: `facts_prod_aggregated_skips_and_saves` - View Type: Direct Table - Data Source: facts.prod.aggregated_skips_and_saves **int_prod_fact_analytics_2020** (Analytics 2020) - Base View: `int_prod_fact_analytics_2020` - View Type: Direct Table - Data Source: intelligence.prod.fact_analytics_2020 **metadata_simplified** (metadata_simplified) - Base View: `metadata_simplified` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Metadata_Simplified, Intelligence.Dbt_Prod **nav** (nav) - Base View: `nav` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: vector_backlog **dt_vector_backlog** (dt_vector_backlog) - Base View: `dt_vector_backlog` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Reportsdd_Direc... #### Model: vendor_payment_hold **orch_app_ph_vendor_payment_hold** (Label) - Base View: `orch_app_ph_vendor_payment_hold` - View Type: Direct Table - Data Source: orchard_app_reporting_v2.prod_ows_accounting_payment_holds.vendor_payment_hold #### Model: video_product_builder **dt_video_product_builder** (Release Restrictions (Country)) - Base View: `dt_video_product_builder` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.VIDEO_PRODUCT_BUILDER #### Model: weekly_hot_tracks **int_prod_analytics_report_full** (Label) - Base View: `int_prod_analytics_report_full` - View Type: Direct Table - Data Source: intelligence.prod.analytics_report_full #### Model: weekly_streaming_overview **int_prod_streaming_totals_last_sales_week** (Label) - Base View: `int_prod_streaming_totals_last_sales_week` - View Type: Derived Table - Data Source: intelligence.dbt_prod.streaming_totals_last_sales_week_release_level **int_prod_streaming_totals_last_sales_week_isrc_level** (Label) - Base View: `int_prod_streaming_totals_last_sales_week_isrc_level` - View Type: Derived Table - Data Source: intelligence.dbt_prod.streaming_totals_last_sales_week_isrc_level #### Model: weekly_trending_playlists_spotify **weekly_trending_playlists_spotify** (Weekly Trending Playlist Spotify) - Base View: `weekly_trending_playlists_spotify` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_PLAYLISTS_SPOTIFY #### Model: youtube_analytics_by_day **dt_itunes_tickets_by_day** (Itunes Tickets) - Base View: `dt_itunes_tickets_by_day` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Day, Prod.Itunes_Tickets, Tickets_By_Day **dt_tiktok_hashtag_tickets_by_week** (TikTik Hashtag Tickets) - Base View: `dt_tiktok_hashtag_tickets_by_week` - View Type: Derived Table - Data Source: Derived from: Dt_Tiktok_Top_Hashtag_By_Day, Prod.Dim_Day, Prod.Staging_Raw_Tikto... **dt_tiktok_song_tickets_by_week** (TikTik Song Tickets) - Base View: `dt_tiktok_song_tickets_by_week` - View Type: Derived Table - Data Source: INTELLIGENCE.DBT_PROD.DT_TIKTOK_SONG_TICKETS_BY_WEEK **dt_tiktok_rows_by_day** (TikTok Rows) - Base View: `dt_tiktok_rows_by_day` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Day, Prod.Staging_Raw_Tiktok **dt_spotify_staging_raw_availability_sme** (Spotify Staging Raw SME) - Base View: `dt_spotify_staging_raw_availability_sme` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Track_Clean_Mv, Prod.Fact_Analytics, Prod.Staging_Raw_Spo... **dt_sme_metadata_rows_by_day** (SME Metadata) - Base View: `dt_sme_metadata_rows_by_day` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Day, Prod.Staging_Sme_Product_Metadata_V2, Sme_Metadata_R... **dt_labelcopy_ingest_rows_by_day** (Label Copy Process (SME)) - Base View: `dt_labelcopy_ingest_rows_by_day` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.DT_LABELCOPY_INGEST_ROWS_BY_DAY **dt_youtube_analytics_by_day** (dt_youtube_analytics_by_day) - Base View: `dt_youtube_analytics_by_day` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: youtube_statistics **youtube_statistics** (youtube_statistics) - Base View: `youtube_statistics` - View Type: Derived Table - Data Source: Derived from: Dev_Engineering, Dev_Engineering.Npalchinskiy, Dt_Youtube_Engageme... #### Model: yt_video_assets **int_prod_vw_yt_video_report_orchard_metadata** (YouTube Assets) - Base View: `int_prod_vw_yt_video_report_orchard_metadata` - View Type: Direct Table - Data Source: intelligence.prod.yt_video_report_orchard_metadata #### Model: zzz_sync_test_pipenv **zzz_sync_int_prod_test_pipenv** (zzz_sync_int_prod_test_pipenv) - Base View: `zzz_sync_int_prod_test_pipenv` - View Type: Direct Table - Data Source: intelligence.prod.test_pipenv ## Impact Analysis Guide ### Making Changes Safely 1. **Before changing a database table:** - Check "Views by Data Source" section above - Identify all views that use the table - Review explores that depend on those views 2. **Before modifying a view:** - Check which models include the view - Review explores that use the view as base - Consider downstream reporting impact 3. **Before changing a model:** - Review all explores in the model - Check business usage of those explores - Coordinate with report consumers ### Complexity Indicators - **High Line Count Views**: Complex business logic, may need optimization - **Many Source Tables**: Complex joins, potential performance impact - **Multiple Dependencies**: Changes have wide impact, need careful testing