# Models Inventory Total Models: 219 Generated on: 2026-07-01 15:37:55 ## [Analytics_AWA](Analytics_AWA.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_AWA.model.lkml` - **Explores:** 1 - **Includes:** 10 **Available Explores:** - `int_dbt_prod_agg_awa_model` - AWA Model ## [Analytics_Amazon](Analytics_Amazon.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Amazon.model.lkml` - **Explores:** 1 - **Includes:** 9 **Available Explores:** - `int_dbt_prod_agg_amazon_model` - Amazon Store Model ## [Analytics_Amazon_Rollup](Analytics_Amazon_Rollup.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Amazon_Rollup.model.lkml` - **Explores:** 4 - **Includes:** 12 **Available Explores:** - `int_dbt_prod_agg_amazon_monthly_rollup_user_aggregation` - Amazon Store Model Monthly Data - `int_dbt_prod_agg_amazon_monthly_rollup` - Amazon Store Model Monthly Data - `int_dbt_prod_agg_amazon_weekly_rollup` - Amazon Store Model Weekly Data - `int_dbt_prod_agg_amazon_aggregated_18months` - Amazon Store Model Daily ## [Analytics_Apple](Analytics_Apple.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Apple.model.lkml` - **Explores:** 1 - **Includes:** 14 **Available Explores:** - `int_dbt_prod_agg_apple_model` - Apple Store Model ## [Analytics_Apple_Rollup](Analytics_Apple_Rollup.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Apple_Rollup.model.lkml` - **Explores:** 3 - **Includes:** 16 **Available Explores:** - `int_dbt_prod_agg_apple_summary_18months` - Apple Store Model Daily - `int_dbt_prod_agg_weekly_apple_summary` - Apple Store Model Weekly Data - `int_dbt_prod_agg_monthly_apple_summary` - Apple Store Model Monthly Data ## [Analytics_Deezer](Analytics_Deezer.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Deezer.model.lkml` - **Explores:** 1 - **Includes:** 10 **Available Explores:** - `int_dbt_prod_agg_deezer_model` - Deezer Model ## [Analytics_Line](Analytics_Line.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Line.model.lkml` - **Explores:** 1 - **Includes:** 10 **Available Explores:** - `int_dbt_prod_agg_line_model` - Line Model ## [Analytics_Netease](Analytics_Netease.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Netease.model.lkml` - **Explores:** 1 - **Includes:** 9 **Available Explores:** - `int_dbt_prod_agg_netease_model` - Orchard/AWAL Tiers ## [Analytics_Pandora](Analytics_Pandora.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Pandora.model.lkml` - **Explores:** 1 - **Includes:** 10 **Available Explores:** - `int_dbt_prod_agg_pandora_model` - Pandora Store Model ## [Analytics_Snapchat](Analytics_Snapchat.model.md) - **Label:** Analytics Models - Short Form Video - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Snapchat.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `int_dbt_prod_agg_snapchat_model` - Snapchat Store Model ## [Analytics_Soundcloud](Analytics_Soundcloud.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Soundcloud.model.lkml` - **Explores:** 1 - **Includes:** 10 **Available Explores:** - `int_dbt_prod_agg_soundcloud_model` - Soundcloud Model ## [Analytics_Spotify](Analytics_Spotify.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Spotify.model.lkml` - **Explores:** 1 - **Includes:** 21 **Available Explores:** - `int_dbt_prod_agg_spotify_model` - Spotify Store Model ## [Analytics_Spotify_Rollup](Analytics_Spotify_Rollup.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Spotify_Rollup.model.lkml` - **Explores:** 3 - **Includes:** 23 **Available Explores:** - `int_dbt_prod_agg_spotify_model_18months` - Spotify Store Model Daily - `int_dbt_prod_agg_weekly_rollup_spotify_model` - Spotify Store Model Weekly Data - `int_dbt_prod_agg_monthly_spotify_model` - Spotify Store Model Monthly Data ## [Analytics_Tencent](Analytics_Tencent.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Tencent.model.lkml` - **Explores:** 1 - **Includes:** 9 **Available Explores:** - `int_dbt_prod_agg_tencent_model` - Orchard/AWAL Tiers ## [Analytics_Top_Cities_dataset](Analytics_Top_Cities_dataset.model.md) - **Label:** Top Cities - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Top_Cities_dataset.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_dbt_prod_top_cities_dataset` - Top Cities ## [Analytics_UMA](Analytics_UMA.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_UMA.model.lkml` - **Explores:** 1 - **Includes:** 8 **Available Explores:** - `int_dbt_prod_agg_uma_model` - UMA Store Model ## [Analytics_Use_Case_Models](Analytics_Use_Case_Models.model.md) - **Label:** Analytics Models - Use Case Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Use_Case_Models.model.lkml` - **Explores:** 2 - **Includes:** 25 **Available Explores:** - `int_dbt_prod_summary_streams` - Summary Streams Model - `metadata_simplified` - metadata_simplified ## [Analytics_Wnyk](Analytics_Wnyk.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Wnyk.model.lkml` - **Explores:** 1 - **Includes:** 14 **Available Explores:** - `int_dbt_prod_agg_wynk_model` - Wynk Model ## [Analytics_Youtube](Analytics_Youtube.model.md) - **Label:** Analytics Models - Store Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Analytics_Youtube.model.lkml` - **Explores:** 1 - **Includes:** 4 **Available Explores:** - `int_dbt_prod_agg_daily_youtube_model` - Transaction Type ## [Apple_Fraudulent_Streaming](Apple_Fraudulent_Streaming.model.md) - **Label:** Fraudulent Streaming - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Apple_Fraudulent_Streaming.model.lkml` - **Explores:** 2 - **Includes:** 11 **Available Explores:** - `APPLE_IN_REVIEW` - Apple In Review Report - `int_dbt_prod_apple_excluded_streams` - Apple Excluded Streams Report ## [Apple_Podcasting](Apple_Podcasting.model.md) - **Label:** Apple Podcasting Model - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Apple_Podcasting.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `daily_apple_podcasting_events_snapshots_joined` - Apple Podcasting Model ## [Approved_Products_Revenue](Approved_Products_Revenue.model.md) - **Label:** Approved Products Revenue - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Approved_Products_Revenue.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_dbt_prod_approved_products_revenue` - Approved Product Revenue ## [Discovery_mode](Discovery_mode.model.md) - **Label:** Discovery Mode - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Discovery_mode.model.lkml` - **Explores:** 5 - **Includes:** 6 **Available Explores:** - `int_dev_nsuzara_awal_discovery` - Discovery Mode - `int_dev_nsuzara_awaldata` - Discovery Mode Master Data - `int_dev_awalspotify` - Discovery Mode Unique ISRC - `int_dev_awalspotify_awaldiscovery_v04ebba` - Discovery Mode AWALDISCOVERY_V04EBBA - `believe` - Believe ## [Download_Stores_Models](Download_Stores_Models.model.md) - **Label:** Analytics Models - Download Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Download_Stores_Models.model.lkml` - **Explores:** 4 - **Includes:** 4 **Available Explores:** - `int_dbt_prod_agg_daily_beatport_download_model` - Beatport Download Model - `int_dbt_prod_agg_daily_amazon_download_model` - Amazon Download Model - `int_dbt_prod_agg_daily_apple_download_model` - Apple Download Model - `int_dbt_prod_daily_summary_downloads` - Unified Downloads Model ## [FCT_ORCHARD_INSIGHTS_TOP_STREAMS_METRICS_TIKTOK_BY_LABEL](FCT_ORCHARD_INSIGHTS_TOP_STREAMS_METRICS_TIKTOK_BY_LABEL.model.md) - **Label:** Orchard Insights - **Connection:** snowflake_via_lookerappadmin - **File Path:** `FCT_ORCHARD_INSIGHTS_TOP_STREAMS_METRICS_TIKTOK_BY_LABEL.model.lkml` - **Explores:** 1 - **Includes:** 6 **Available Explores:** - `int_dbt_prod_fct_orchard_insights_top_streams_metrics_tiktok_by_label` - Orchard/AWAL Tiers ## [Insta_Reels](Insta_Reels.model.md) - **Label:** Instagram Reels - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Insta_Reels.model.lkml` - **Explores:** 2 - **Includes:** 12 **Available Explores:** - `facts_prod_staging_raw_insta_reels_views` - Instagram Reels Views - `facts_prod_staging_raw_insta_reels_creations` - Instagram Reels Creations ## [Jorga_Smith_Analysis](Jorga_Smith_Analysis.model.md) - **Label:** Jorga Smith Analysis - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Jorga_Smith_Analysis.model.lkml` - **Explores:** 7 - **Includes:** 1 **Available Explores:** - `JORJA_SMITH_LOST_AND_FOUND_APPLE_PLAYLIST_AND_STORE_FIRST_7_DAYS` - Jorga Smith Analysis - Lost and Found Apple Playlist - `JORJA_SMITH_FALLING_OR_FLYING_AMAZON_FIRST_7_DAYS` - Jorga Smith Analysis - Falling or Flying Amazon - `JORJA_SMITH_FALLING_OR_FLYING_APPLE_PLAYLIST_FIRST_7_DAYS` - Jorga Smith Analysis - Falling or flying Apple Playlist - `JORJA_SMITH_FALLING_OR_FLYING_APPLE_STORE_FIRST_7_DAYS` - Jorga Smith Analysis - Falling or Flying Apple Store - `JORJA_SMITH_FALLING_OR_FLYING_SPOTIFY_FIRST_7_DAYS` - Jorga Smith Analysis - Falling or Flying Spotify - `JORJA_SMITH_LOST_AND_FOUND_AMAZON_FIRST_7_DAYS` - Jorga Smith Analysis - Lost and Found Amazon - `JORJA_SMITH_LOST_AND_FOUND_SPOTIFY_FIRST_7_DAYS` - Jorga Smith Analysis - Lost and Found Spotify ## [Label_Review_Spreadsheet](Label_Review_Spreadsheet.model.md) - **Label:** Label Performance Spreadsheet - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Label_Review_Spreadsheet.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `int_dbt_prod_label_performance_spreadsheet` - Label Performance Spreadsheet ## [Last_7_days_streaming](Last_7_days_streaming.model.md) - **Label:** Last 7 Days Sales Analytics-ISRC Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Last_7_days_streaming.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_dbt_prod_streaming_totals_last_7_days_isrc_level` - Label ## [MD5_Changes](MD5_Changes.model.md) - **Label:** MD5 Changes - **Connection:** snowflake_via_lookerappadmin - **File Path:** `MD5_Changes.model.lkml` - **Explores:** 1 - **Includes:** 5 **Available Explores:** - `orch_app_dd_asset` - MD5 Changes ## [MRC](MRC.model.md) - **Label:** MRC - **Connection:** snowflake_via_lookerappadmin - **File Path:** `MRC.model.lkml` - **Explores:** 1 - **Includes:** 4 **Available Explores:** - `facts_prod_staging_raw_mrc` - MRC Report ## [Riaa_Certification_Model](Riaa_Certification_Model.model.md) - **Label:** RIAA Certification Model - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Riaa_Certification_Model.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `int_dbt_prod_riaa_certification` - Orchard/AWAL Tiers ## [Sales_Performance_Metrics_Spotify](Sales_Performance_Metrics_Spotify.model.md) - **Label:** Sales Performance Metrics: Spotify - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Sales_Performance_Metrics_Spotify.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `int_dbt_prod_sales_performance_metrics` - Sales Performance Metrics: Spotify ## [Snowflake_Monitoring](Snowflake_Monitoring.model.md) - **Label:** Monitoring - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Snowflake_Monitoring.model.lkml` - **Explores:** 3 - **Includes:** 1 **Available Explores:** - `snowflake_warehouse_metering_xf` - Snowflake Warehouse Cost Monitoring - `snowflake_query_history` - Snowflake Query Monitoring - `monthly_snowflake_storage_costs` - Snowflake Storage Cost Monitoring ## [Spotify_Charts](Spotify_Charts.model.md) - **Label:** Spotify Charts - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Spotify_Charts.model.lkml` - **Explores:** 1 - **Includes:** 26 **Available Explores:** - `facts_prod_spotify_chart` - Track ## [Spotify_Monthly_Fraudulent_Streaming](Spotify_Monthly_Fraudulent_Streaming.model.md) - **Label:** Fraudulent Streaming - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Spotify_Monthly_Fraudulent_Streaming.model.lkml` - **Explores:** 2 - **Includes:** 14 **Available Explores:** - `int_dbt_prod_spotify_monthly_fraudulent_streaming` - Spotify Frauduelent Streaming Monthly Report - `int_dbt_prod_spotify_fraudulent_fact_sales_combined` - Label Contract ## [Spotify_Weekly_Market_Share](Spotify_Weekly_Market_Share.model.md) - **Label:** Spotify Weekly Market Share - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Spotify_Weekly_Market_Share.model.lkml` - **Explores:** 1 - **Includes:** 4 **Available Explores:** - `spotify_market_share_week_ending` - Spotify Weekly Market Share ## [Tier_3_Label_Analysis](Tier_3_Label_Analysis.model.md) - **Label:** Tier 3 Label Report - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Tier_3_Label_Analysis.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `int_dbt_prod_tier_3_label_analysis` - Label Manager Territory ## [TikTok_Fraudulent_Streaming](TikTok_Fraudulent_Streaming.model.md) - **Label:** Fraudulent Streaming - **Connection:** snowflake_via_lookerappadmin - **File Path:** `TikTok_Fraudulent_Streaming.model.lkml` - **Explores:** 1 - **Includes:** 11 **Available Explores:** - `int_dbt_prod_tiktok_fraud_model` - TikTok Fraudulent Content ## [US_ARTIST_RANKING](US_ARTIST_RANKING.model.md) - **Label:** US Artist Ranking - **Connection:** snowflake_via_lookerappadmin - **File Path:** `US_ARTIST_RANKING.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `US_ARTIST_RANKING` - US Artist Ranking ## [Weekly_Streaming_Overall_Performance](Weekly_Streaming_Overall_Performance.model.md) - **Label:** WoW_Streams_by_DSP - **Connection:** snowflake_via_lookerappadmin - **File Path:** `Weekly_Streaming_Overall_Performance.model.lkml` - **Explores:** 6 - **Includes:** 6 **Available Explores:** - `int_dbt_prod_wow_streams_by_dsp` - WoW_Streams_by_DSP - `int_dbt_prod_tier_breakdown` - Tier Breakdown - `int_dbt_prod_source_breakdown` - Source Breakdown - `int_dbt_prod_engagedvsleanbackbreakdown` - engaged vs Leanback breakdown - `int_dbt_prod_weekly_no_of_new_releases` - Weekly No Of New Releases - `int_dbt_prod_sub_genres` - Sub Genre ## [YouTube_Analytics_API](YouTube_Analytics_API.model.md) - **Label:** YouTube Store Model - **Connection:** snowflake_via_lookerappadmin - **File Path:** `YouTube_Analytics_API.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `int_dbt_prod_youtube_summary_streams_daily` - Video ## [abacus](abacus.model.md) - **Label:** ABACUS - **Connection:** snowflake_via_lookerappadmin - **File Path:** `abacus.model.lkml` - **Explores:** 5 - **Includes:** 1 **Available Explores:** - `int_dbt_prod_abacus_fact_sales` - Transaction Country - `int_dbt_prod_abacus_adjustments` - Orchard/AWAL Tiers - `int_dbt_prod_qa_abacus_adjustments` - Orchard/AWAL Tiers - `int_dbt_prod_abacus_expenses` - Orchard/AWAL Tiers - `int_dbt_prod_qa_abacus_expenses` - Orchard/AWAL Tiers ## [accounting_analytics_blend](accounting_analytics_blend.model.md) - **Label:** Blended Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `accounting_analytics_blend.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `int_prod_accounting_analytics_blend` - Artist - `int_prod_accounting_analytics_blend` - Artist ## [accounting_reports](accounting_reports.model.md) - **Label:** Exchange rates - **Connection:** snowflake_via_lookerappadmin - **File Path:** `accounting_reports.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_checks` - Exchange rates ## [ad_spend](ad_spend.model.md) - **Label:** Advertising - **Connection:** snowflake_via_lookerappadmin - **File Path:** `ad_spend.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_fact_ad_spend` - Artist ## [advertising_campaigns](advertising_campaigns.model.md) - **Label:** Custom Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `advertising_campaigns.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `advertising_campaigns` - advertising_campaigns ## [advertising_monthly_activity](advertising_monthly_activity.model.md) - **Label:** Custom Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `advertising_monthly_activity.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `advertising_monthly_activity` - advertising_monthly_activity ## [advertising_requests](advertising_requests.model.md) - **Label:** Custom Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `advertising_requests.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `advertising_requests` - advertising_requests ## [all_signed_labels](all_signed_labels.model.md) - **Label:** Custom Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `models/all_signed_labels.model.lkml` - **Explores:** 2 - **Includes:** 2 **Available Explores:** - `all_signed_labels_revenue_columns` - All Signed Labels - Pivoted - `all_signed_labels` - all_signed_labels ## [amazon_sos](amazon_sos.model.md) - **Label:** Source of Stream (SOS) - **Connection:** snowflake_via_lookerappadmin - **File Path:** `amazon_sos.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_staging_raw_amazon_unlimited` - Source of Stream ## [amprofon_certification](amprofon_certification.model.md) - **Label:** Amprofon Certification - **Connection:** snowflake_via_lookerappadmin - **File Path:** `amprofon_certification.model.lkml` - **Explores:** 2 - **Includes:** 2 **Available Explores:** - `dt_amprofon_certification` - Amprofon Certification - `dt_amprofon_certification_v2` - Amprofon Certification ## [anomaly_testing](anomaly_testing.model.md) - **Label:** Market Share Tests - **Connection:** snowflake_via_lookerappadmin - **File Path:** `anomaly_testing.model.lkml` - **Explores:** 7 - **Includes:** 7 **Available Explores:** - `market_share_test` - Market Share Tests - `market_share_fact_sales_test` - Market Share fact Sales Tests - `amazon_anomaly_testing` - Amazon Anomaly Testing - `apple_anomaly_testing` - Apple Anomaly Testing - `spotify_anomaly_testing` - Spotify Anomaly Testing - `deezer_anomaly_testing` - Deezer Anomaly Testing - `line_anomaly_testing` - Line Anomaly Testing ## [apple_container_report](apple_container_report.model.md) - **Label:** Apple Music - **Connection:** snowflake_via_lookerappadmin - **File Path:** `apple_container_report.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_apple_music_container_summary` - Container Report ## [apple_music_demographic](apple_music_demographic.model.md) - **Label:** Demographics - **Connection:** snowflake_via_lookerappadmin - **File Path:** `apple_music_demographic.model.lkml` - **Explores:** 1 - **Includes:** 5 **Available Explores:** - `int_dbt_prod_apple_music_demographic` - Label ## [apple_music_pitch_grid](apple_music_pitch_grid.model.md) - **Label:** Apple Music Pitch Grid - **Connection:** snowflake_via_lookerappadmin - **File Path:** `apple_music_pitch_grid.model.lkml` - **Explores:** 3 - **Includes:** 10 **Available Explores:** - `dt_apple_music_pitch_grid` - Release Is Deliverable - `int_dbt_prod_apple_music_pitch_grid_specialist_genres` - Release Is Deliverable - `int_prod_apg_apple_pitch_grid` - Release Is Deliverable ## [aria_streaming_score](aria_streaming_score.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `aria_streaming_score.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_aria_streaming_score` - dt_aria_streaming_score ## [artist_marketshare](artist_marketshare.model.md) - **Label:** Orchard Marketshare Detail - **Connection:** snowflake_via_lookerappadmin - **File Path:** `artist_marketshare.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_dbt_prod_artist_marketshare` - Orchard Marketshare Detail ## [artist_similarity](artist_similarity.model.md) - **Label:** Data Scien - **Connection:** snowflake_via_lookerappadmin - **File Path:** `artist_similarity.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dev_eng_artist_clustering_artist_similarity` - Recommended Country ## [artist_store_identifier](artist_store_identifier.model.md) - **Label:** Artist Store Identifiers - **Connection:** snowflake_via_lookerappadmin - **File Path:** `artist_store_identifier.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `int_prod_vw_artist_identifier` - Artist Name (Aggregated) ## [artist_trends_and_demographics](artist_trends_and_demographics.model.md) - **Label:** Ad-Sales - **Connection:** snowflake_via_lookerappadmin - **File Path:** `models/artist_trends_and_demographics.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `int_dbt_prod_artist_streaming_trends` - Artist Demographics ## [audience_segmentation](audience_segmentation.model.md) - **Label:** Demographics - **Connection:** snowflake_via_lookerappadmin - **File Path:** `models/audience_segmentation.model.lkml` - **Explores:** 2 - **Includes:** 3 **Available Explores:** - `spotify_engagement_groups_combined_with_user_info` - Demographics - `amazon_engagement_groups_combined` - Demographics ## [audio_features](audio_features.model.md) - **Label:** Spotify Track Audio Characteristics - **Connection:** snowflake_via_lookerappadmin - **File Path:** `audio_features.model.lkml` - **Explores:** 10 - **Includes:** 27 **Available Explores:** - `int_dbt_prod_spotify_track_audio_features` - Track - `dt_track_audio_feature_comparison` - Track Audio Feature Comparison Model - `dt_track_playlist_audio_feature_comparison` - Track vs Playlist Audio Feature Comparison Model - `dt_track_playlist_audio_feature_comparison_2stddev` - Track vs Playlist Audio Feature Comparison Model 2stddev - `dt_playlist_track_fit` - Playlist - `dt_playlist_track_fit_v2_2stddev` - Playlist - `dt_playlist_audio_features_upper_x_lower_bounds` - Playlist Audio Features - Upper & Lower Bounds - `dt_audio_features_track_similarity` - Track - `int_dbt_prod_spotify_editorial_playlist_position_log` - Spotify Audio Features - `dt_audio_features_playlist_similarity` - Playlist Audio Characteristic Similarity Model ## [awal_toggle](awal_toggle.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `awal_toggle.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_dbt_prod_awal_tier_groups` - int_dbt_prod_awal_tier_groups ## [balance_models](balance_models.model.md) - **Label:** Outstanding Balances Model - **Connection:** snowflake_via_lookerappadmin - **File Path:** `balance_models.model.lkml` - **Explores:** 2 - **Includes:** 2 **Available Explores:** - `dt_outstanding_balances_2` - Outstanding Balances Model - `dt_advances_2` - Advances Model ## [bi_tools](bi_tools.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `bi_tools.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_new_signing_revenue_estimate_calculator` - dt_new_signing_revenue_estimate_calculator ## [bits_per_sample](bits_per_sample.model.md) - **Label:** Label - **Connection:** snowflake_via_lookerappadmin - **File Path:** `bits_per_sample.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `orch_app_ar_vendor` - Label ## [capif_certification](capif_certification.model.md) - **Label:** CAPIF Certification - **Connection:** snowflake_via_lookerappadmin - **File Path:** `capif_certification.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `dt_capif_certification` - Orchard/AWAL Tiers ## [certification_models](certification_models.model.md) - **Label:** Certification Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `certification_models.model.lkml` - **Explores:** 11 - **Includes:** 12 **Available Explores:** - `int_dbt_prod_promusicae_track_cert` - Promusicae Spain Track Certification - `int_dbt_prod_promusicae_album_cert` - Promusicae Spain Album Certification - `int_dbt_prod_promusicae_brazil_cert` - Promusicae Brazil Track Certification - `int_dbt_prod_amprofon_track_cert` - Amprofon Mexico Track Certification - `int_dbt_prod_amprofon_album_cert` - Amprofon Mexico Album Certification - `int_dbt_prod_aria_track_cert` - ARIA Australia Track Certification - `int_dbt_prod_aria_album_cert` - ARIA Australia Album Certification - `int_dbt_prod_aria_album_cert_accounting` - ARIA Australia Album Certification (Accounting) - `int_dbt_prod_aria_track_cert_accounting` - ARIA Australia Track Certification (Accounting) - `int_dbt_prod_riaa_track_cert` - Orchard/AWAL Tiers - `int_dbt_prod_riaa_album_cert` - Orchard/AWAL Tiers ## [chart_metric_A&R](chart_metric_A&R.model.md) - **Label:** Chart Metric - **Connection:** looker_high_performance - **File Path:** `chart_metric_A&R.model.lkml` - **Explores:** 4 - **Includes:** 2 **Available Explores:** - `cm_unioned_chart_advanced` - A&R Tool - `cm_non_traditional_charts` - Chart - `cm_unioned_playlist_current` - Playlist - `cm_unioned_chart_2` - A&R New ## [chart_metric_music](chart_metric_music.model.md) - **Label:** ChartMetric - **Connection:** snowflake_via_lookerappadmin - **File Path:** `chart_metric_music.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `cm_unioned_chart` - Charts ## [chart_metric_playlist](chart_metric_playlist.model.md) - **Label:** ChartMetric - **Connection:** snowflake_via_lookerappadmin - **File Path:** `chart_metric_playlist.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `cm_unioned_playlist_current` - Playlist - `cm_unioned_playlist_history` - Playlist History ## [chart_metric_social](chart_metric_social.model.md) - **Label:** ChartMetric - **Connection:** snowflake_via_lookerappadmin - **File Path:** `chart_metric_social.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `cm_social_union` - Artist - `cm_track_artists` - TikTok ## [chartable_podcasts](chartable_podcasts.model.md) - **Label:** Chartable Podcasts - **Connection:** snowflake_via_lookerappadmin - **File Path:** `chartable_podcasts.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_chartable_podcast_rankings` - Podcast ## [chartmetric_charts](chartmetric_charts.model.md) - **Label:** Chartmetric Ingestions - **Connection:** snowflake_via_lookerappadmin - **File Path:** `chartmetric_charts.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_chartmetric_charts` - Chartmetric Ingestions ## [chartmetric_socials](chartmetric_socials.model.md) - **Label:** Chartmetric Ingestions - **Connection:** snowflake_via_lookerappadmin - **File Path:** `chartmetric_socials.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_chartmetric_socials` - Chartmetric Ingestions ## [chartmetric_socials_backfill](chartmetric_socials_backfill.model.md) - **Label:** Chartmetric Ingestions - **Connection:** snowflake_via_lookerappadmin - **File Path:** `chartmetric_socials_backfill.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_cm_url_backfill` - Chartmetric Ingestions ## [cherry_pick_report](cherry_pick_report.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `cherry_pick_report.model.lkml` - **Explores:** 1 - **Includes:** 4 **Available Explores:** - `int_dbt_prod_cherry_pick_report` - int_dbt_prod_cherry_pick_report ## [compilation_takedowns](compilation_takedowns.model.md) - **Label:** Compilation Takedowns Tool - **Connection:** snowflake_via_lookerappadmin - **File Path:** `compilation_takedowns.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_prod_compilation_takedowns` - Compilation Takedowns Tool ## [conflict_manager_statistics](conflict_manager_statistics.model.md) - **Label:** Conflict manager Statistics Report - **Connection:** snowflake_via_lookerappadmin - **File Path:** `conflict_manager_statistics.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `facts_prod_fact_conflict` - Conflict manager Statistics Report ## [contact_created_date](contact_created_date.model.md) - **Label:** Contact Created Details - **Connection:** snowflake_via_lookerappadmin - **File Path:** `contact_created_date.model.lkml` - **Explores:** 2 - **Includes:** 2 **Available Explores:** - `contact_created_date` - Contact Created Date - `order_items` - order_items ## [content_validation_itunes_apple](content_validation_itunes_apple.model.md) - **Label:** Content Validation for iTunes/Apple - **Connection:** snowflake_via_lookerappadmin - **File Path:** `content_validation_itunes_apple.model.lkml` - **Explores:** 3 - **Includes:** 1 **Available Explores:** - `dt_content_validation_explicit_content` - Reporting Template - `dt_content_validation_featuring_artists` - Reporting Template - `dt_content_validation_album_credit` - Reporting Template ## [content_validation_itunes_apple_v2](content_validation_itunes_apple_v2.model.md) - **Label:** Explicit Content - **Connection:** snowflake_via_lookerappadmin - **File Path:** `content_validation_itunes_apple_v2.model.lkml` - **Explores:** 5 - **Includes:** 1 **Available Explores:** - `int_prod_vw_track_explicit` - Reporting Template - `int_prod_vw_featuring_artists_track_release` - Reporting Template - `int_prod_vw_release_content_validation_agg` - Reporting Template - `int_prod_vw_track_content_validation_agg` - Reporting Template - `int_prod_itunes_language_validation` - Language Validation ## [core_accounting](core_accounting.model.md) - **Label:** Core Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `core_accounting.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `facts_prod_fact_sales` - Accounting ## [core_analytics](core_analytics.model.md) - **Label:** Core Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `core_analytics.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_fact_analytics` - Analytics ## [core_analytics_v2](core_analytics_v2.model.md) - **Label:** Core Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `core_analytics_v2.model.lkml` - **Explores:** 5 - **Includes:** 1 **Available Explores:** - `facts_prod_fact_analytics_v2` - Analytics - `facts_prod_aggregated_skips_and_saves` - Skips & Saves - `int_prod_fact_analytics_2020` - Analytics 2020 - `metadata_simplified` - metadata_simplified - `nav` - nav ## [core_metadata](core_metadata.model.md) - **Label:** Core Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `core_metadata.model.lkml` - **Explores:** 3 - **Includes:** 7 **Available Explores:** - `orch_app_ar_owner` - Label - `nav` - nav - `metadata_simplified` - metadata_simplified ## [daily_spiking](daily_spiking.model.md) - **Label:** Label - **Connection:** snowflake_via_lookerappadmin - **File Path:** `daily_spiking.model.lkml` - **Explores:** 11 - **Includes:** 1 **Available Explores:** - `int_prod_daily_spikes_us` - Label - `int_prod_weekly_spikes_us` - Label - `int_prod_daily_spikes_uk` - Label - `int_prod_weekly_spikes_uk` - Label - `int_dbt_prod_weekly_spikes_japan` - Label - `int_dbt_prod_weekly_spikes_africa` - Label - `dt_daily_spikes` - Label - `dt_daily_negative_spikes` - Label - `dt_daily_spikes_v2` - Label - `dt_weekly_spikes` - Label - `dt_weekly_negative_spikes` - Label ## [daily_top_content](daily_top_content.model.md) - **Label:** Label - **Connection:** snowflake_via_lookerappadmin - **File Path:** `daily_top_content.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_prod_daily_top_content` - Label ## [dbt_custom_looker_datasets](dbt_custom_looker_datasets.model.md) - **Label:** Custom Data Sets - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dbt_custom_looker_datasets.model.lkml` - **Explores:** 20 - **Includes:** 25 **Available Explores:** - `int_dbt_prod_accounting_last_12_months_activity_date` - Transaction Country - `top_content_daily_editorial_streams` - Custom Models - `int_dbt_prod_accounting_last_24_months_activity_date_track_level` - Spotify Editorial Streams - `int_dbt_prod_artist_by_territory_accounting` - Transaction Country - `int_dbt_prod_track_level_accounting` - Release - `int_dbt_prod_spatial_audio_delivery_history_search` - int_dbt_prod_spatial_audio_delivery_history_search - `int_dbt_prod_per_play_rate` - int_dbt_prod_per_play_rate - `int_dbt_prod_digital_bulk_template` - int_dbt_prod_digital_bulk_template - `tsz_custom` - tsz_custom - `int_dbt_prod_completion_rate_track_level_monthly` - int_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 - `int_dbt_prod_changes_by_country` - int_dbt_prod_changes_by_country - `int_dbt_prod_tracks_generating_1000_streams` - int_dbt_prod_tracks_generating_1000_streams - `int_dbt_prod_global_chart_tracking` - int_dbt_prod_global_chart_tracking - `int_dbt_prod_anuel_aa_toptracks_monthly` - int_dbt_prod_anuel_aa_toptracks_monthly - `int_dbt_prod_top_artists_monthly` - int_dbt_prod_top_artists_monthly - `int_dbt_prod_top_tracks_monthly` - int_dbt_prod_top_tracks_monthly - `int_dbt_prod_first_access_analytics_reporting` - int_dbt_prod_first_access_analytics_reporting - `int_dbt_prod_youtube_spike_report` - int_dbt_prod_youtube_spike_report - `int_dbt_prod_changes_by_source` - int_dbt_prod_changes_by_source ## [dbt_ifpi_models](dbt_ifpi_models.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dbt_ifpi_models.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_dbt_prod_ifpi_country_label_level_accounting` - int_dbt_prod_ifpi_country_label_level_accounting ## [dbt_monitoring](dbt_monitoring.model.md) - **Label:** Monitoring - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dbt_monitoring.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `elementary_model_job_monitoring_v1` - dbt Monitoring ## [dbt_playlists](dbt_playlists.model.md) - **Label:** Analytics Models - Playlist Level - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dbt_playlists.model.lkml` - **Explores:** 6 - **Includes:** 27 **Available Explores:** - `int_dbt_prod_playlist_model_spotify` - Label - `int_dbt_prod_playlist_model_amazon` - Label - `int_dbt_prod_playlist_model_apple` - Label - `int_dbt_prod_playlist_model_soundcloud` - Label - `int_dbt_prod_playlist_model_pandora` - Label - `int_dbt_prod_playlist_model_joint` - Label ## [dbt_release_schedule_dashboard_v2](dbt_release_schedule_dashboard_v2.model.md) - **Label:** Artist - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dbt_release_schedule_dashboard_v2.model.lkml` - **Explores:** 1 - **Includes:** 17 **Available Explores:** - `int_dbt_prod_rsd_v2` - Artist ## [dbt_trending_tiktok](dbt_trending_tiktok.model.md) - **Label:** Label - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dbt_trending_tiktok.model.lkml` - **Explores:** 8 - **Includes:** 15 **Available Explores:** - `int_dbt_prod_rolling_weekly_tiktok_trending_creations` - Label - `int_dbt_prod_rolling_weekly_tiktok_trending_creations_3_weeks` - Label - `int_dbt_prod_rolling_weekly_tiktok_trending_creations_5_weeks` - Label - `int_dbt_prod_rolling_weekly_tiktok_trending_video_views` - Label - `int_dbt_prod_rolling_weekly_tiktok_trending_video_views_3_weeks` - Label - `int_dbt_prod_rolling_weekly_tiktok_trending_video_views_5_weeks` - Label - `int_dbt_prod_tiktok_trending_tracks` - Label - `int_dbt_prod_weekly_trending_genres_tiktok` - Transaction Country ## [dbt_trending_tracks](dbt_trending_tracks.model.md) - **Label:** Label - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dbt_trending_tracks.model.lkml` - **Explores:** 25 - **Includes:** 37 **Available Explores:** - `int_dbt_prod_weekly_trending_tracks_uk_spotify` - Label - `int_dbt_prod_weekly_trending_tracks_uk_spotify_collection` - Label - `int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist` - Label - `int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd` - Label - `int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail` - Label - `int_dbt_prod_spotify_3rd_party_playlist_spt_last_week` - Transaction Country - `int_dbt_prod_weekly_trending_tracks_amazon` - Label - `int_dbt_prod_weekly_trending_tracks_amazon_collection` - Label - `int_dbt_prod_weekly_trending_tracks_amazon_lean_fwd` - Label - `int_dbt_prod_weekly_trending_tracks_amazon_user_playlist` - Label - `int_dbt_prod_weekly_trending_tracks_amazon_long_tail` - Label - `int_dbt_prod_weekly_trending_tracks_apple` - Label - `int_dbt_prod_weekly_trending_tracks_apple_discovery_streams` - Label - `int_dbt_prod_weekly_trending_tracks_apple_library_streams` - Label - `int_dbt_prod_weekly_trending_tracks_apple_long_tail` - Label - `int_dbt_prod_weekly_trending_tracks_apple_search_streams` - Label - `int_dbt_prod_weekly_trending_tracks_apple_voice_streams` - Label - `int_dbt_prod_weekly_trending_tracks_spotify_continent` - Label - `int_dbt_prod_weekly_trending_tracks_combined_tiktok` - Label - `int_dbt_prod_weekly_trending_genres_spotify` - Transaction Country - `int_dbt_prod_weekly_trending_tracks_awa` - Label - `int_dbt_prod_weekly_trending_tracks_deezer` - Label - `int_dbt_prod_weekly_trending_tracks_line` - Label - `int_dbt_prod_weekly_trending_tracks_pandora` - Label - `int_dbt_prod_weekly_trending_tracks_soundcloud` - Label ## [deezer_fraud](deezer_fraud.model.md) - **Label:** Deezer Fraud Detection - **Connection:** snowflake_via_lookerappadmin - **File Path:** `deezer_fraud.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_dbt_deezer_fraud_report` - Deezer Fraud Detection ## [dim_lookups](dim_lookups.model.md) - **Label:** Lookup Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dim_lookups.model.lkml` - **Explores:** 7 - **Includes:** 1 **Available Explores:** - `facts_prod_dim_country` - Country - `facts_prod_dim_store` - Store - `facts_prod_dim_transactiontype` - Transaction Type - `facts_prod_dim_period` - Period - `int_prod_store_genre_subgenre_mappings` - Store Genre Mappings - `orch_app_ar_vendor` - Label - `facts_prod_spotify_tracks` - Track ## [direct_delivery](direct_delivery.model.md) - **Label:** Direct Delivery - **Connection:** snowflake_via_lookerappadmin - **File Path:** `direct_delivery.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `orch_app_dd_customer_master_master` - Delivery Batch Detail ## [dt_awa_units_by_day](dt_awa_units_by_day.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dt_awa_units_by_day.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `awa_internal_availability` - awa_internal_availability ## [dt_blacklist_words](dt_blacklist_words.model.md) - **Label:** Custom Model - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dt_blacklist_words.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_blacklist_words` - Metadata ## [dt_chargeback_reconciliation](dt_chargeback_reconciliation.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dt_chargeback_reconciliation.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_chargeback_reconciliation` - dt_chargeback_reconciliation ## [dt_fact_sales_market_share_brazil](dt_fact_sales_market_share_brazil.model.md) - **Label:** Market Share Brazil Query - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dt_fact_sales_market_share_brazil.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_fact_sales_market_share_brazil` - Market Share Brazil Query ## [dt_label_balances](dt_label_balances.model.md) - **Label:** Finance - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dt_label_balances.model.lkml` - **Explores:** 2 - **Includes:** 14 **Available Explores:** - `facts_prod_vw_workstation_summary` - Orchard/AWAL Tiers - `dt_label_balances` - dt_label_balances ## [dt_playlisting_by_track](dt_playlisting_by_track.model.md) - **Label:** Label - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dt_playlisting_by_track.model.lkml` - **Explores:** 1 - **Includes:** 5 **Available Explores:** - `dt_playlisting_by_track` - Label ## [dt_soundcloud_units_by_day](dt_soundcloud_units_by_day.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `dt_soundcloud_units_by_day.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_soundcloud_units_by_day` - dt_soundcloud_units_by_day ## [etl_monitor_accounting](etl_monitor_accounting.model.md) - **Label:** Accounting ETL Monitor - **Connection:** snowflake_via_lookerappadmin - **File Path:** `etl_monitor_accounting.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_etl_monitor_accounting` - Accounting ETL Monitor ## [facebook_urls](facebook_urls.model.md) - **Label:** Facebook URL - **Connection:** snowflake_via_lookerappadmin - **File Path:** `facebook_urls.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `orch_app_ar_participant_external_link` - Label ## [feature_controls](feature_controls.model.md) - **Label:** Product - **Connection:** snowflake_via_lookerappadmin - **File Path:** `feature_controls.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `orch_app_ar_vendor` - Owner - `dt_vendor_enabled_features` - Label ## [finance_export_uk](finance_export_uk.model.md) - **Label:** Revenue Export for UK - **Connection:** snowflake_via_lookerappadmin - **File Path:** `finance_export_uk.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `dt_finance_export_uk` - Revenue Export for UK ## [finance_label_advances_balances](finance_label_advances_balances.model.md) - **Label:** Label - **Connection:** snowflake_via_lookerappadmin - **File Path:** `finance_label_advances_balances.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `dt_finance_advance_recouped_balances` - Label ## [financial_reports](financial_reports.model.md) - **Label:** Apple Music Footer - **Connection:** snowflake_via_lookerappadmin - **File Path:** `models/financial_reports.model.lkml` - **Explores:** 10 - **Includes:** 2 **Available Explores:** - `facts_prod_staging_raw_apple_music_footer` - Apple Vendor - `facts_prod_staging_raw_apple_music_linear_radio_service` - Apple Vendor - `facts_prod_staging_raw_apple_music_royalty_calculation` - Apple Vendor - `facts_prod_staging_raw_apple_music_summary` - Apple Vendor - `facts_prod_staging_raw_youtube_monthly_red_label_music_summary` - YouTube Financial Reports - `facts_prod_staging_raw_youtube_monthly_red_label_non_music_summary` - YouTube Financial Reports - `facts_prod_staging_raw_youtube_monthly_red_label_subscriber_summary` - YouTube Financial Reports - `facts_prod_staging_raw_youtube_monthly_report_v1_0_summary` - YouTube Financial Reports - `facts_prod_staging_raw_youtube_monthly_report_v1_0_summary_by_country` - YouTube Financial Reports - `facts_prod_staging_raw_youtube_monthly_report_v1_0_summary_by_day` - YouTube Financial Reports ## [genre_benchmarking](genre_benchmarking.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `genre_benchmarking.model.lkml` - **Explores:** 3 - **Includes:** 1 **Available Explores:** - `dt_genre_benchmarking` - dt_genre_benchmarking - `dt_genre_benchmarking_median` - dt_genre_benchmarking_median - `dt_genre_benchmarking_streams_by_day` - dt_genre_benchmarking_streams_by_day ## [genre_mappings](genre_mappings.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `genre_mappings.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_genre_mappings` - dt_genre_mappings ## [global_certification](global_certification.model.md) - **Label:** Global Certification - **Connection:** snowflake_via_lookerappadmin - **File Path:** `global_certification.model.lkml` - **Explores:** 3 - **Includes:** 4 **Available Explores:** - `dt_global_certification` - Global Certification - `dt_global_certifications_by_country` - Global Certifications - `dt_global_track_certifications_by_country` - Global Certifications ## [holiday_trending_report](holiday_trending_report.model.md) - **Label:** Holiday Trending Report - **Connection:** snowflake_via_lookerappadmin - **File Path:** `holiday_trending_report.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `holiday_trending_report` - Holiday Trending Report ## [instagram_spike_stats](instagram_spike_stats.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `instagram_spike_stats.model.lkml` - **Explores:** 3 - **Includes:** 1 **Available Explores:** - `int_prod_instagram_spike_stats` - int_prod_instagram_spike_stats - `int_prod_social_spike_stats` - int_prod_social_spike_stats - `facts_prod_social_spike_stats` - facts_prod_social_spike_stats ## [instagram_statistics](instagram_statistics.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `instagram_statistics.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `instagram_statistics` - instagram_statistics ## [invalid_references](invalid_references.model.md) - **Label:** YouTube Invalid References - **Connection:** snowflake_via_lookerappadmin - **File Path:** `invalid_references.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `dt_invalid_references_gameplay_words` - dt_invalid_references_gameplay_words - `dt_invalid_references_sample_pack_words` - dt_invalid_references_sample_pack_words ## [invalid_track_writer](invalid_track_writer.model.md) - **Label:** Invalid Track Writer - **Connection:** snowflake_via_lookerappadmin - **File Path:** `invalid_track_writer.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `dt_invalid_track_writer` - Invalid Track Writer ## [itunes_hides](itunes_hides.model.md) - **Label:** Operations - **Connection:** snowflake_via_lookerappadmin - **File Path:** `itunes_hides.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `prod_hidden_content_itunes_hidden` - iTunes Hide ## [itunes_tickets](itunes_tickets.model.md) - **Label:** Operations - **Connection:** snowflake_via_lookerappadmin - **File Path:** `itunes_tickets.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `facts_prod_itunes_tickets` - iTunes Ticket ## [kemado_weekly_reports](kemado_weekly_reports.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `kemado_weekly_reports.model.lkml` - **Explores:** 2 - **Includes:** 2 **Available Explores:** - `int_dbt_prod_kemado_all_time_streams` - int_dbt_prod_kemado_all_time_streams - `int_dbt_prod_kemado_streams_last_18_months_releases` - int_dbt_prod_kemado_streams_last_18_months_releases ## [label_contracts](label_contracts.model.md) - **Label:** Label Contract Audit - **Connection:** snowflake_via_lookerappadmin - **File Path:** `label_contracts.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_dbt_prod_latest_label_contracts` - Label Contract Audit ## [label_level_contribution_to_change](label_level_contribution_to_change.model.md) - **Label:** Label - **Connection:** snowflake_via_lookerappadmin - **File Path:** `models/label_level_contribution_to_change.model.lkml` - **Explores:** 7 - **Includes:** 11 **Available Explores:** - `label_level_contribution_to_change` - Label - `label_country_level_contribution_to_change` - Label - `label_artist_level_contribution_to_change` - Label - `label_store_level_contribution_to_change` - Label - `label_source_level_contribution_to_change` - Label - `label_release_level_contribution_to_change` - Label - `label_track_level_contribution_to_change` - Label ## [label_manager_control_panel](label_manager_control_panel.model.md) - **Label:** Upcoming New Releases - **Connection:** snowflake_via_lookerappadmin - **File Path:** `label_manager_control_panel.model.lkml` - **Explores:** 12 - **Includes:** 12 **Available Explores:** - `int_dbt_prod_lmcp_upcoming_new_releases` - Upcoming New Releases - `int_dbt_prod_lmcp_fact_analytics_last_3_weeks` - Fact analytics Last 3 Weeks - `int_dbt_prod_lmcp_lmcp_active_releases` - Active Releases - `int_dbt_prod_lmcp_assigned_labels` - Assigned Labels - `int_dbt_prod_lmcp_lm_name` - LM Name - `int_dbt_prod_lmcp_new_releases_in_label_processing` - New Releases in Label Processing - `int_dbt_prod_lmcp_shazam_activity` - Shazam Activity - `int_dbt_prod_lmcp_tiktok_top_tracks` - TikTok top Tracks - `int_dbt_prod_lmcp_top_labels` - Top Labels - `int_dbt_prod_lmcp_top_overall_tracks` - Top Overall Tracks - `int_dbt_prod_lmcp_top_playlists_radio` - Top Playlists Radio - `int_dbt_prod_lmcp_top_overall_releases` - Top Overall Releases ## [label_manager_insights](label_manager_insights.model.md) - **Label:** Label Manager Insights - **Connection:** snowflake_via_lookerappadmin - **File Path:** `label_manager_insights.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_label_manager_insights` - Label ## [label_manager_insights_temp](label_manager_insights_temp.model.md) - **Label:** Label Manager Insights (Temp) - **Connection:** snowflake_via_lookerappadmin - **File Path:** `label_manager_insights_temp.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_label_manager_insights_temp` - Label Manager Insights ## [label_manager_territory_map](label_manager_territory_map.model.md) - **Label:** Label Manager Map - **Connection:** snowflake_via_lookerappadmin - **File Path:** `label_manager_territory_map.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dev_engineering_ccapalbo_label_manager_territory_map` - Label Manager Map ## [label_offering](label_offering.model.md) - **Label:** Custom Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `label_offering.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `label_offering` - label_offering ## [label_streaming_anomalies](label_streaming_anomalies.model.md) - **Label:** Label Streaming Anomalies - Monthly - **Connection:** snowflake_via_lookerappadmin - **File Path:** `models/label_streaming_anomalies.model.lkml` - **Explores:** 7 - **Includes:** 6 **Available Explores:** - `int_dbt_prod_label_anomalies_monthly` - Label - `int_dbt_prod_label_country_monthly_ctc` - Country Monthly CTC - `int_dbt_prod_label_store_monthly_ctc` - Store Monthly CTC - `int_dbt_prod_label_artist_monthly_ctc` - Artist Monthly CTC - `int_dbt_prod_label_source_monthly_ctc` - Source Monthly CTC - `int_dbt_prod_label_upc_monthly_ctc` - UPC Monthly CTC - `int_dbt_prod_label_isrc_monthly_ctc` - ISRC Monthly CTC ## [listeners_by_stream_count](listeners_by_stream_count.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `listeners_by_stream_count.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_listeners_by_stream_count` - dt_listeners_by_stream_count ## [looker_history_monitoring](looker_history_monitoring.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `looker_history_monitoring.model.lkml` - **Explores:** 4 - **Includes:** 1 **Available Explores:** - `prod_looker_user_history` - prod_looker_user_history - `prod_perf_by_user_group` - prod_perf_by_user_group - `prod_looker_connection_query_history` - prod_looker_connection_query_history - `prod_looker_total_query_history` - prod_looker_total_query_history ## [luminate_global_reports](luminate_global_reports.model.md) - **Label:** Luminate Global Reports - **Connection:** snowflake_via_lookerappadmin - **File Path:** `luminate_global_reports.model.lkml` - **Explores:** 3 - **Includes:** 3 **Available Explores:** - `int_dbt_prod_luminate_global_artist` - Global Top 20K Artists Report - `int_dbt_prod_luminate_global_song` - Global Top 50K Songs Report - `int_dbt_prod_luminate_global_isrc` - Global Top 100K ISRCs Report ## [market_share_temp](market_share_temp.model.md) - **Label:** Core Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `market_share_temp.model.lkml` - **Explores:** 4 - **Includes:** 10 **Available Explores:** - `facts_prod_fact_market_share` - Country - `dt_fact_sales_market_share` - Label - `dt_fact_sales_market_share_artist_level` - Label - `dt_market_share_change` - Market Share Change ## [marketing_change_log](marketing_change_log.model.md) - **Label:** Marketing Change Log - **Connection:** snowflake_via_lookerappadmin - **File Path:** `marketing_change_log.model.lkml` - **Explores:** 3 - **Includes:** 4 **Available Explores:** - `dt_marketing_change_log` - Deliverable for Release - `int_prod_rcl_release_change_log` - Release - `int_prod_rcl_track_ig_changes` - Track ## [master_calendar](master_calendar.model.md) - **Label:** Master Calendar Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `master_calendar.model.lkml` - **Explores:** 3 - **Includes:** 1 **Available Explores:** - `facts_prod_dim_day` - dim_day - `metadata_simplified` - metadata_simplified - `nav` - nav ## [master_calendar_sme](master_calendar_sme.model.md) - **Label:** Master Calendar Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `master_calendar_sme.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_dim_day` - dim_day_sme ## [master_rights_audit](master_rights_audit.model.md) - **Label:** Master Rights Audit - **Connection:** snowflake_via_lookerappadmin - **File Path:** `master_rights_audit.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_master_rights_audit` - Track ## [meta_analytics](meta_analytics.model.md) - **Label:** Meta Analytics - **Connection:** snowflake_via_lookerappadmin - **File Path:** `docs/meta_analytics.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `meta_analytics` - Meta Analytics ## [meta_update](meta_update.model.md) - **Label:** Operations - **Connection:** snowflake_via_lookerappadmin - **File Path:** `meta_update.model.lkml` - **Explores:** 1 - **Includes:** 22 **Available Explores:** - `meta_update_queue` - Meta Update Queue ## [metrics_by_channel_country](metrics_by_channel_country.model.md) - **Label:** YouTube Channel Metrics - **Connection:** snowflake_via_lookerappadmin - **File Path:** `metrics_by_channel_country.model.lkml` - **Explores:** 1 - **Includes:** 8 **Available Explores:** - `facts_prod_metrics_by_channel_country_feed_distributor_rollup` - YouTube Channel Metrics ## [millward_brown_reporting](millward_brown_reporting.model.md) - **Label:** Millward Brown Report - **Connection:** snowflake_via_lookerappadmin - **File Path:** `millward_brown_reporting.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `int_dbt_prod_millward_brown_upc_list` - Release ## [missing_track_duration](missing_track_duration.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `missing_track_duration.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_missing_track_duration` - dt_missing_track_duration ## [mobile_analytics](mobile_analytics.model.md) - **Label:** Product - **Connection:** snowflake_via_lookerappadmin - **File Path:** `mobile_analytics.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `dt_mobile_app_opened` - Application Opened ## [moments](moments.model.md) - **Label:** Project Moments - **Connection:** snowflake_via_lookerappadmin - **File Path:** `moments.model.lkml` - **Explores:** 19 - **Includes:** 29 **Available Explores:** - `dev_eng_eimpara_fouriertable_jul_sept_22` - Track - `dev_eng_eimpara_fouriertable_apr_sept_22` - Track - `dev_eng_eimpara_fouriertable_feb_sept_22` - Track - `dt_project_moments_cluster_groups_140_days` - Moments - Cluster Groups - `dt_project_moments_pred_vs_actual_140_days` - Moments - Actual vs Predicted - `dt_project_moments_cluster_group_audio_upper_x_lower_bounds` - Moments - Cluster Groups Audio Profiles - `dt_project_moments_cluster_groups_v2_fuzzy_logic` - Moments - Cluster Groups - Version 2 - `dt_project_moments_cluster_group_audio_upper_x_lower_bounds_v2_fuzzy_logic` - Moments - Cluster Groups Audio Profiles - Version 2 - `dt_project_moments_som_cluster_groups` - Moments - Cluster Groups - SOM Clusters - `dt_project_moments_cluster_groups_audio_upper_x_lower_bounds_som_logic` - Moments - Cluster Groups Audio Profiles - SOM Clusters - `int_dbt_prod_moments_watchlist` - Moments Watchlist Info - `dt_project_moments_fuzzy_cluster_v4` - Moments - Cluster Groups - Version 4 - `dt_project_moments_cluster_group_upper_x_lower_bounds_fuzzy_v4` - Moments - Cluster Groups Audio Profiles - Version 4 - `int_dev_tallman_moments_performance_groups_v1` - K Proto Copy - `project_moments_ma_calculation` - Artist - `project_moments_hedra_output_table` - Project Moments Hedra - `project_moments_hedra_output_140_days_table` - Project Moments Hedra - `uniti_recommends_refined` - Uniti Recommends - `dt_project_moments_uniti_graphical_representation` - Uniti Recommends Graph ## [one_pager](one_pager.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `one_pager.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `dt_top_5_countries` - dt_top_5_countries - `dt_top_5_stores` - dt_top_5_stores ## [orca_a_and_lp](orca_a_and_lp.model.md) - **Label:** ORCA - **Connection:** snowflake_via_lookerappadmin - **File Path:** `models/orca_a_and_lp.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `int_dbt_prod_orca_a_and_lp_dataset` - Time Series Info ## [pandora_sos](pandora_sos.model.md) - **Label:** Source of Stream (SOS) - **Connection:** snowflake_via_lookerappadmin - **File Path:** `pandora_sos.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `facts_prod_staging_raw_pandora` - Pandora SOS - `order_items` - order_items ## [performance_rights_delivery_history](performance_rights_delivery_history.model.md) - **Label:** Performance Rights - **Connection:** snowflake_via_lookerappadmin - **File Path:** `performance_rights_delivery_history.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_prod_vw_performance_rights_delivery_history` - Track ## [performance_rights_sales](performance_rights_sales.model.md) - **Label:** Performance Rights - **Connection:** snowflake_via_lookerappadmin - **File Path:** `performance_rights_sales.model.lkml` - **Explores:** 2 - **Includes:** 2 **Available Explores:** - `prs_prod_sx_sales` - Statement Detail - `prs_prod_ppl_sales` - Statement Detail ## [ph_audit_model](ph_audit_model.model.md) - **Label:** Phonofile Audit - **Connection:** snowflake_via_lookerappadmin - **File Path:** `ph_audit_model.model.lkml` - **Explores:** 3 - **Includes:** 1 **Available Explores:** - `ph_audit_merlinrebates` - ph_audit_merlinrebates - `ph_audit_ph_usage_fact_sales` - ph_audit_ph_usage_fact_sales - `ph_audit_phonofile_rebates_from_ph_db` - ph_audit_phonofile_rebates_from_ph_db ## [physical](physical.model.md) - **Label:** Core Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `physical.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `orch_app_ar_product_physical` - Physical Product ## [physical_accounting_all_sales](physical_accounting_all_sales.model.md) - **Label:** Physical - **Connection:** snowflake_via_lookerappadmin - **File Path:** `physical_accounting_all_sales.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_prod_physical_accounting_all_sales` - All Sales ## [physical_eu](physical_eu.model.md) - **Label:** Core Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `physical_eu.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `physical_eu` - Physical EU ## [playlist_placements_analysis](playlist_placements_analysis.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `playlist_placements_analysis.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_recent_placements_by_track_playlist_country_feed_hourly` - facts_prod_recent_placements_by_track_playlist_country_feed_hourly ## [podcast_analytics](podcast_analytics.model.md) - **Label:** Podcast Analytics - **Connection:** snowflake_via_lookerappadmin - **File Path:** `podcast_analytics.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_staging_raw_megaphone` - Episode ## [pre_save_data](pre_save_data.model.md) - **Label:** Pre Save Data - **Connection:** snowflake_via_lookerappadmin - **File Path:** `pre_save_data.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `fact_prod_staging_raw_apple_music_totallibraryadds` - Pre Save Data ## [prod_ows_monitoring](prod_ows_monitoring.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `prod_ows_monitoring.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_prod_ows_warehouse_monitoring` - dt_prod_ows_warehouse_monitoring ## [product_manager_control_panel](product_manager_control_panel.model.md) - **Label:** Shazam Activity - **Connection:** snowflake_via_lookerappadmin - **File Path:** `product_manager_control_panel.model.lkml` - **Explores:** 10 - **Includes:** 13 **Available Explores:** - `int_dbt_prod_pmcp_shazam_activity` - Shazam Activity - `int_dbt_prod_pmcp_tiktok_top_tracks` - TikTok Top Tracks - `int_dbt_prod_pmcp_revenue_last_12_months` - Revenue Last 12 Months - `int_dbt_prod_pmcp_top_playlist_radio_station` - Top Playlist/Radio Station - `int_dbt_prod_pmcp_top_10_labels_last_12_months` - Top 10 Labels last 12 Months - `int_dbt_prod_pmcp_top_streamed_tracks_all_time` - Artist - `int_dbt_prod_pmcp_top_streamed_releases_all_time` - Artist - `int_dbt_prod_pmcp_top_10_countries_last_12_months` - Top 10 Countries Last 12 Months - `int_dbt_prod_pmcp_top_streamed_new_tracks_last_4_months` - Artist - `int_dbt_prod_pmcp_top_streamed_new_releases_last_4_months` - Artist ## [product_territory_split](product_territory_split.model.md) - **Label:** Custom - **Connection:** snowflake_via_lookerappadmin - **File Path:** `product_territory_split.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_product_territory_splits` - Custom ## [project_maze](project_maze.model.md) - **Label:** Spotify Top 200 Chart Predictions - **Connection:** snowflake_via_lookerappadmin - **File Path:** `models/project_maze.model.lkml` - **Explores:** 3 - **Includes:** 3 **Available Explores:** - `dbt_prod_spotify_top_200_predictions_weekly` - Spotify Top 200 Chart Predictions - `int_dbt_prod_orch_spotify_top_200_chart_appearances` - Maze Chart Appearances - `dt_spotify_top_200_aggregates` - Maze Chart Appearances ## [promusicae_certification](promusicae_certification.model.md) - **Label:** Metadata - **Connection:** snowflake_via_lookerappadmin - **File Path:** `promusicae_certification.model.lkml` - **Explores:** 4 - **Includes:** 1 **Available Explores:** - `dt_promusicae_certification_album` - Metadata - `dt_promusicae_certification_single` - Metadata - `dt_promusicae_certification_album_incl_youtube` - Metadata - `dt_promusicae_certification_single_incl_youtube` - Metadata ## [proper_changed_releases](proper_changed_releases.model.md) - **Label:** Release Restrictions - **Connection:** snowflake_via_lookerappadmin - **File Path:** `proper_changed_releases.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_proper_changed_releases` - dt_proper_changed_releases ## [publishing](publishing.model.md) - **Label:** Publishing - **Connection:** snowflake_via_lookerappadmin - **File Path:** `publishing.model.lkml` - **Explores:** 2 - **Includes:** 2 **Available Explores:** - `facts_prod_global_sound_recording` - Track - `publishing_app_compositions_changes` - Publishing ## [publishing_revenue](publishing_revenue.model.md) - **Label:** Publishing - **Connection:** snowflake_via_lookerappadmin - **File Path:** `publishing_revenue.model.lkml` - **Explores:** 2 - **Includes:** 5 **Available Explores:** - `royalty_accounting_prod_vw_abacus_fact_sales_publishing` - Publishing Data - `dt_revenue_by_songwriter` - Publishing Data ## [rank_tool](rank_tool.model.md) - **Label:** Rank Tool - **Connection:** snowflake_via_lookerappadmin - **File Path:** `rank_tool.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_rank_tool` - Rank Tool ## [red_bull_reports](red_bull_reports.model.md) - **Label:** Red Bull Reports - Mike Heygler - All Time - **Connection:** snowflake_via_lookerappadmin - **File Path:** `red_bull_reports.model.lkml` - **Explores:** 2 - **Includes:** 3 **Available Explores:** - `int_dbt_prod_red_bull_records_streaming_report_all_time` - Date - `int_dbt_prod_red_bull_records_streaming_report_last_60_days` - Date ## [release_compare](release_compare.model.md) - **Label:** Date - **Connection:** snowflake_via_lookerappadmin - **File Path:** `release_compare.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_release_compare` - Date ## [release_compare_datasets](release_compare_datasets.model.md) - **Label:** Release Compare Datasets - **Connection:** snowflake_via_lookerappadmin - **File Path:** `release_compare_datasets.model.lkml` - **Explores:** 4 - **Includes:** 7 **Available Explores:** - `int_dbt_prod_release_compare_model_spotify_store` - Track - `int_dbt_prod_release_compare_model_amazon_store` - Track - `int_dbt_prod_release_compare_model_apple_store` - Track - `int_dbt_prod_release_compare_model_apple_playlist` - Track ## [release_schedule_dashboard](release_schedule_dashboard.model.md) - **Label:** Release Schedule Dashboard - **Connection:** snowflake_via_lookerappadmin - **File Path:** `release_schedule_dashboard.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `dt_release_schedule_dashboard` - Release Schedule Dashboard - `int_prod_rsd_release_schedule_dashboard` - Release Restrictions (Territory) ## [releases_ingested_top_labels](releases_ingested_top_labels.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `releases_ingested_top_labels.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `dt_releases_ingested_top_labels` - dt_releases_ingested_top_labels ## [rev_and_profit_last_12_months](rev_and_profit_last_12_months.model.md) - **Label:** Custom Data Sets - **Connection:** snowflake_via_lookerappadmin - **File Path:** `rev_and_profit_last_12_months.model.lkml` - **Explores:** 2 - **Includes:** 9 **Available Explores:** - `int_dbt_prod_rev_and_profit_last_12_months` - Label - `int_dbt_prod_last_month_accounting_info` - Label ## [revenue_ex_spatial_deliveries](revenue_ex_spatial_deliveries.model.md) - **Label:** Revenue ex spatial deliveries - **Connection:** snowflake_via_lookerappadmin - **File Path:** `revenue_ex_spatial_deliveries.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_dbt_prod_revenue_apple_amazon_ex_spatial_deliveries` - Revenue ex spatial deliveries ## [riaa_certification](riaa_certification.model.md) - **Label:** RIAA Certification - **Connection:** snowflake_via_lookerappadmin - **File Path:** `riaa_certification.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `dt_riaa_certification` - Orchard/AWAL Tiers ## [riaa_us_certification](riaa_us_certification.model.md) - **Label:** RIAA Model Certification - **Connection:** snowflake_via_lookerappadmin - **File Path:** `riaa_us_certification.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `int_dbt_prod_riaa_model_certification` - Orchard/AWAL Tiers ## [rights_management](rights_management.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `rights_management.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_prod_internal_conflicts` - int_prod_internal_conflicts ## [ritmogestion_top_10k_streaming_tracks_weekly](ritmogestion_top_10k_streaming_tracks_weekly.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `ritmogestion/ritmogestion_top_10k_streaming_tracks_weekly.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_staging_raw_ritmogestion` - facts_prod_staging_raw_ritmogestion ## [round_hill_streaming_report_request](round_hill_streaming_report_request.model.md) - **Label:** Round Hill Streaming Report Request - **Connection:** snowflake_via_lookerappadmin - **File Path:** `round_hill_streaming_report_request.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `round_hill_streaming_report_request` - Round Hill Streaming Report Request ## [shazam](shazam.model.md) - **Label:** Analytics - **Connection:** snowflake_via_lookerappadmin - **File Path:** `shazam.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `facts_prod_staging_raw_shazam` - Event Location - `facts_prod_apple_music_shazam_daily_events` - Shazam Events ## [shazam_daily_events](shazam_daily_events.model.md) - **Label:** Shazam Daily Events - **Connection:** snowflake_via_lookerappadmin - **File Path:** `shazam_daily_events.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_shazam_daily_events` - Shazam Daily Events ## [skips_saves](skips_saves.model.md) - **Label:** Core Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `skips_saves.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_aggregated_skips_and_saves` - Skips & Saves ## [sony_aggregate_revenue](sony_aggregate_revenue.model.md) - **Label:** Finance - **Connection:** snowflake_via_lookerappadmin - **File Path:** `sony_aggregate_revenue.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `sony_internal_prod_orchard_monthly_sap_aggregate_feed_history` - Transaction Country ## [soundcloud-statistics](soundcloud-statistics.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `soundcloud-statistics.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `soundcloud_statistics` - soundcloud_statistics ## [soundexchange_historic_accounting](soundexchange_historic_accounting.model.md) - **Label:** Performance Rights - **Connection:** snowflake_via_lookerappadmin - **File Path:** `soundexchange_historic_accounting.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_prod_performance_rights_historic_accounting` - Orchard Track ## [spotify_daily_top_200_orchard_content](spotify_daily_top_200_orchard_content.model.md) - **Label:** Spotify Daily Top 200 - **Connection:** snowflake_via_lookerappadmin - **File Path:** `spotify_daily_top_200_orchard_content.model.lkml` - **Explores:** 1 - **Includes:** 5 **Available Explores:** - `int_dbt_prod_spotify_daily_top_200` - Orchard/AWAL Tiers ## [spotify_statistics](spotify_statistics.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `spotify_statistics.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `spotify_statistics` - spotify_statistics ## [spotify_top_200_distributed_content](spotify_top_200_distributed_content.model.md) - **Label:** Spotify Top 200 vs Orchard Distributed Conent - **Connection:** snowflake_via_lookerappadmin - **File Path:** `spotify_top_200_distributed_content.model.lkml` - **Explores:** 1 - **Includes:** 6 **Available Explores:** - `int_dbt_prod_spotify_top_200_vs_orchard_distributed_content_streams` - Orchard/AWAL Tiers ## [statement_db](statement_db.model.md) - **Label:** Statement Processing - **Connection:** statement_db - **File Path:** `statement_db.model.lkml` - **Explores:** 3 - **Includes:** 2 **Available Explores:** - `stmt_db_dig_sales_analytics` - Statement DB - `dt_itunes_complete_month_by_service` - iTunes Complete Month by Service - `stmt_db_pl_storelist` - Report Ingestion List ## [store_availability](store_availability.model.md) - **Label:** Store Availability - **Connection:** snowflake_via_lookerappadmin - **File Path:** `store_availability.model.lkml` - **Explores:** 5 - **Includes:** 1 **Available Explores:** - `dt_store_availability_analytics` - Store Availability: Analytics - `dt_store_availability_tiktok` - Store Availability: TikTok - `dt_store_availability_analytics_sme_updated` - Store Availability: SME Analytics - `dt_store_availability_shazam` - Store Availability: Shazam - `prod_store_avail_store_avail_availability` - Release ## [store_backfill_priority](store_backfill_priority.model.md) - **Label:** Store Backfill Priority - **Connection:** snowflake_via_lookerappadmin - **File Path:** `store_backfill_priority.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `dt_store_backfill_priority` - Store Backfill Priority ## [store_qbr](store_qbr.model.md) - **Label:** Store QBRs - **Connection:** snowflake_via_lookerappadmin - **File Path:** `store_qbr.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_fact_sales_revenue_buckets` - Revenue Buckets ## [stream_share_spotify_weekly](stream_share_spotify_weekly.model.md) - **Label:** Last Week Spotify Markest Share - **Connection:** snowflake_via_lookerappadmin - **File Path:** `stream_share_spotify_weekly.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `stream_share_spotify_weekly` - Orchard/AWAL Tiers ## [streaming_fraud](streaming_fraud.model.md) - **Label:** Streaming Fraud Indicators Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `streaming_fraud.model.lkml` - **Explores:** 2 - **Includes:** 10 **Available Explores:** - `int_dbt_prod_weekly_fraudulent_streams_flags_spotify` - User - `int_dbt_prod_stg_sos_fraud_spike_over_500_pct` - Label ## [streaming_fraud_detection](streaming_fraud_detection.model.md) - **Label:** Streaming Fraud Detection - **Connection:** snowflake_via_lookerappadmin - **File Path:** `streaming_fraud_detection.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_streaming_fraud_detection` - Streaming Fraud Detection ## [subset_data](subset_data.model.md) - **Label:** Subset Data - **Connection:** snowflake_via_lookerappadmin - **File Path:** `subset_data.model.lkml` - **Explores:** 4 - **Includes:** 4 **Available Explores:** - `SUBSET_FOURIER_2023_DATA` - SUBSET FOURIER 2023 DATA - `SUBSET_ARIMA_2023_DATA` - SUBSET ARIMA 2023 DATA - `SUBSET_MANUALCLUSTERING_2023_DATA` - SUBSET MANUALCLUSTERING 2023 DATA - `SUBSET_PREDICTED_VALUES_2023_DATA` - SUBSET PREDICTED VALUES 2023 DATA ## [summary_sos](summary_sos.model.md) - **Label:** Source of Stream (SOS) - **Connection:** snowflake_via_lookerappadmin - **File Path:** `summary_sos.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `facts_prod_summary_sos` - Summary SOS ## [territory_kpis_2](territory_kpis_2.model.md) - **Label:** Territory KPIs - **Connection:** snowflake_via_lookerappadmin - **File Path:** `territory_kpis_2.model.lkml` - **Explores:** 5 - **Includes:** 1 **Available Explores:** - `int_dbt_prod_summary_territory_kpis` - Summary Territory KPIs - `int_dbt_prod_monthly_territory_kpis` - Monthly Territory KPIs - `int_dbt_prod_transaction_country_report` - Transaction Country Report - `int_dbt_prod_label_country_report` - Label Country Report - `int_dbt_prod_transaction_country_report_filterable` - Transaction Country Report (Filterable) ## [tiktok_pitch_grid_us](tiktok_pitch_grid_us.model.md) - **Label:** TikTok Pitch Grid - **Connection:** snowflake_via_lookerappadmin - **File Path:** `tiktok_pitch_grid_us.model.lkml` - **Explores:** 1 - **Includes:** 3 **Available Explores:** - `tiktok_pitch_grid_us` - Orchard/AWAL Tiers ## [tiktok_top_500_model](tiktok_top_500_model.model.md) - **Label:** Analytics Models - Short Form Video - **Connection:** snowflake_via_lookerappadmin - **File Path:** `tiktok_top_500_model.model.lkml` - **Explores:** 3 - **Includes:** 1 **Available Explores:** - `facts_prod_staging_raw_tiktok_trends_topsong` - Top Songs - `facts_prod_staging_raw_tiktok_trends_tophashtag` - Top Hashtags - `facts_prod_staging_raw_tiktok` - Orchard Metadata ## [timed_release](timed_release.model.md) - **Label:** Timed Release - **Connection:** snowflake_via_lookerappadmin - **File Path:** `timed_release.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `orchard_app_reporting_v2_prod_ows_timed_release_ows_timed_release_schedule_timed_release` - Release ## [top_playlist_by_country](top_playlist_by_country.model.md) - **Label:** Top Playlist by Country - **Connection:** snowflake_via_lookerappadmin - **File Path:** `top_playlist_by_country.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_top_playlist_by_country` - dt_top_playlist_by_country ## [top_stores_by_artist](top_stores_by_artist.model.md) - **Label:** Top Tracks By Stores - **Connection:** snowflake_via_lookerappadmin - **File Path:** `top_stores_by_artist.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_top_stores_by_artist` - dt_top_stores_by_artist ## [top_tracks](top_tracks.model.md) - **Label:** Label - **Connection:** snowflake_via_lookerappadmin - **File Path:** `top_tracks.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `dt_top_tracks` - Label - `dt_top_tracks_test` - Label ## [top_tracks_by_artist](top_tracks_by_artist.model.md) - **Label:** Top Tracks By Artist - **Connection:** snowflake_via_lookerappadmin - **File Path:** `top_tracks_by_artist.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `dt_top_tracks_by_artist` - dt_top_tracks_by_artist ## [track_compare](track_compare.model.md) - **Label:** Date - **Connection:** snowflake_via_lookerappadmin - **File Path:** `track_compare.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_track_compare` - Date ## [track_playlist](track_playlist.model.md) - **Label:** Label - **Connection:** snowflake_via_lookerappadmin - **File Path:** `track_playlist.model.lkml` - **Explores:** 1 - **Includes:** 6 **Available Explores:** - `track_level_playlisting` - Label ## [trending_tracks_new](trending_tracks_new.model.md) - **Label:** Trending Tracks - **Connection:** snowflake_via_lookerappadmin - **File Path:** `trending_tracks_new.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_trending_tracks` - Trending Tracks ## [tsz_fa](tsz_fa.model.md) - **Label:** Custom Models - **Connection:** snowflake_via_lookerappadmin - **File Path:** `tsz_fa.model.lkml` - **Explores:** 5 - **Includes:** 1 **Available Explores:** - `tsz_fa` - Three Six Zero - `facts_prod_aggregated_skips_and_saves` - Skips & Saves - `int_prod_fact_analytics_2020` - Analytics 2020 - `metadata_simplified` - metadata_simplified - `nav` - nav ## [vector_backlog](vector_backlog.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `vector_backlog.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `dt_vector_backlog` - dt_vector_backlog ## [vendor_payment_hold](vendor_payment_hold.model.md) - **Label:** Vendor Payment Hold - **Connection:** snowflake_via_lookerappadmin - **File Path:** `vendor_payment_hold.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `orch_app_ph_vendor_payment_hold` - Label ## [video_product_builder](video_product_builder.model.md) - **Label:** Video Product Builder - **Connection:** snowflake_via_lookerappadmin - **File Path:** `video_product_builder.model.lkml` - **Explores:** 1 - **Includes:** 13 **Available Explores:** - `dt_video_product_builder` - Release Restrictions (Country) ## [weekly_hot_tracks](weekly_hot_tracks.model.md) - **Label:** Daily Top Spotify/Apple Music Tracks - **Connection:** snowflake_via_lookerappadmin - **File Path:** `weekly_hot_tracks.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `int_prod_analytics_report_full` - Label ## [weekly_streaming_overview](weekly_streaming_overview.model.md) - **Label:** Weekly Streaming Overview - **Connection:** snowflake_via_lookerappadmin - **File Path:** `weekly_streaming_overview.model.lkml` - **Explores:** 2 - **Includes:** 1 **Available Explores:** - `int_prod_streaming_totals_last_sales_week` - Label - `int_prod_streaming_totals_last_sales_week_isrc_level` - Label ## [weekly_trending_playlists_spotify](weekly_trending_playlists_spotify.model.md) - **Label:** Weekly Trending Playlist Spotify - **Connection:** snowflake_via_lookerappadmin - **File Path:** `weekly_trending_playlists_spotify.model.lkml` - **Explores:** 1 - **Includes:** 2 **Available Explores:** - `weekly_trending_playlists_spotify` - Weekly Trending Playlist Spotify ## [youtube_analytics_by_day](youtube_analytics_by_day.model.md) - **Label:** Itunes Tickets - **Connection:** snowflake_via_lookerappadmin - **File Path:** `youtube_analytics_by_day.model.lkml` - **Explores:** 8 - **Includes:** 1 **Available Explores:** - `dt_itunes_tickets_by_day` - Itunes Tickets - `dt_tiktok_hashtag_tickets_by_week` - TikTik Hashtag Tickets - `dt_tiktok_song_tickets_by_week` - TikTik Song Tickets - `dt_tiktok_rows_by_day` - TikTok Rows - `dt_spotify_staging_raw_availability_sme` - Spotify Staging Raw SME - `dt_sme_metadata_rows_by_day` - SME Metadata - `dt_labelcopy_ingest_rows_by_day` - Label Copy Process (SME) - `dt_youtube_analytics_by_day` - dt_youtube_analytics_by_day ## [youtube_statistics](youtube_statistics.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `youtube_statistics.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `youtube_statistics` - youtube_statistics ## [yt_video_assets](yt_video_assets.model.md) - **Label:** YouTube Assets - **Connection:** snowflake_via_lookerappadmin - **File Path:** `yt_video_assets.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `int_prod_vw_yt_video_report_orchard_metadata` - YouTube Assets ## [zzz_sync_test_pipenv](zzz_sync_test_pipenv.model.md) - **Label:** None - **Connection:** snowflake_via_lookerappadmin - **File Path:** `zzz_sync_test_pipenv.model.lkml` - **Explores:** 1 - **Includes:** 1 **Available Explores:** - `zzz_sync_int_prod_test_pipenv` - zzz_sync_int_prod_test_pipenv