# Data Lineage & Dependencies

Generated on: 2026-01-09 05:57:13

This document shows the relationships and dependencies between models, views, and data sources.

## Overview

- **Total Models:** 28
- **Total Views:** 82
- **Derived Views:** 53
- **Direct Table Views:** 29

## Model Dependencies

### Models and Their Views

#### OrchardGo_Adoption_Updated
- **Includes:** 3 views
- **Views:**
  - `dt_orchgo_artist_level_label_invites`
  - `dt_orchgo_user_activity`
  - `dt_orchgo_new_users`

#### anr_de_artists_test
- **Includes:** 1 views
- **Views:**
  - `anr_de_artists_test`

#### anr_followers_statistics_ds
- **Includes:** 1 views
- **Views:**
  - `anr_followers_statistics`

#### anr_likes_statistics_ds
- **Includes:** 1 views
- **Views:**
  - `anr_likes_statistics`

#### anr_missing_days
- **Includes:** 1 views
- **Views:**
  - `anr_missing_days`

#### anr_nav
- **Includes:** 1 views
- **Views:**
  - `anr_nav`

#### anr_sc_artists_test
- **Includes:** 1 views
- **Views:**
  - `anr_sc_artists_test`

#### anr_shazam_ds
- **Includes:** 2 views
- **Views:**
  - `anr_shazam`
  - `anr_shazam_tracks`

#### anr_shazam_total_ds
- **Includes:** 1 views
- **Views:**
  - `anr_shazam_total`

#### anr_spotify_monthly_listeners_ds
- **Includes:** 1 views
- **Views:**
  - `anr_spotify_monthly_listeners`

#### anr_statistics_ds
- **Includes:** 5 views
- **Views:**
  - `anr_instagram`
  - `anr_soundcloud`
  - `anr_spotify`
  - `anr_youtube`
  - `anr_shazam`

#### anr_tiktok_ds
- **Includes:** 1 views
- **Views:**
  - `anr_tiktok`

#### anr_top_staistics_ds
- **Includes:** 7 views
- **Views:**
  - `anr_instagram_followers`
  - `anr_instagram_engagement`
  - `anr_plays_and_views`
  - `anr_spotify_release`
  - `anr_youtube_latest_release`
  - `anr_youtube_subscribers`
  - `anr_soundcloud_release`

#### anr_uk_artists_test
- **Includes:** 1 views
- **Views:**
  - `anr_uk_artists_test`

#### chartmetric_charts_ds
- **Includes:** 1 views
- **Views:**
  - `facts_prod_chartmetric_charts`

#### chartmetric_socials_backfill_ds
- **Includes:** 1 views
- **Views:**
  - `facts_prod_cm_url_backfill`

#### chartmetric_socials_ds
- **Includes:** 1 views
- **Views:**
  - `facts_prod_chartmetric_socials`

#### dt_awa_units_by_day_ds
- **Includes:** 1 views
- **Views:**
  - `awa_internal_availability`

#### dt_charts_monitoring
- **Includes:** 2 views
- **Views:**
  - `dt_charts_monitoring_latest_update`
  - `dt_charts_monitoring_last_four_days`

#### dt_insights
- **Includes:** 1 views
- **Views:**
  - `dt_insights`

#### dt_soundcloud_units_by_day_ds
- **Includes:** 1 views
- **Views:**
  - `dt_soundcloud_units_by_day`

#### facts_prod_apple_podcast_analytics
- **Includes:** 8 views
- **Views:**
  - `facts_prod_apple_podcasts_sales_summary`
  - `facts_prod_apple_podcasts_subscription_events`
  - `facts_prod_apple_podcasts_subscription_snapshot`
  - `facts_prod_apple_podcasts_content_performance`
  - `facts_prod_apple_podcasts_sales_summary_monthly`
  - `facts_prod_apple_podcasts_subscription_events_monthly`
  - `facts_prod_apple_podcasts_subscription_snapshot_monthly`
  - `apple_podcasts_max_listeners_per_episode_by_show`

#### market_share_temp_ds
- **Includes:** 13 views
- **Views:**
  - `facts_prod_fact_market_share`
  - `facts_prod_dim_country`
  - `int_prod_territory_grouping`
  - `dt_rolling_date_windows_market_share`
  - `orch_app_ar_vendor`
  - `orch_app_ar_owner`
  - `dt_fact_sales_market_share`
  - `facts_prod_dim_store`
  - `facts_prod_dim_label`
  - `dt_fact_sales_market_share_artist_level`
  - `facts_prod_dim_store`
  - `facts_prod_dim_label`
  - `dt_market_share_change`

#### master_calendar_ds
- **Includes:** 5 views
- **Views:**
  - `metadata_simplified`
  - `nav`
  - `facts_prod_dim_day`
  - `facts_prod_dim_licensor`
  - `facts_prod_fact_analytics_for_master_calendar`

#### master_calendar_sme_ds
- **Includes:** 3 views
- **Views:**
  - `facts_prod_dim_day`
  - `facts_prod_dim_licensor`
  - `facts_prod_fact_analytics_for_master_calendar`

#### shazam_ds
- **Includes:** 8 views
- **Views:**
  - `facts_prod_staging_raw_shazam`
  - `orch_app_ar_country`
  - `dev_eng_nsnyder_sme_lat_long_to_dma`
  - `facts_prod_apple_music_shazam_daily_events`
  - `facts_prod_dim_isrc`
  - `orch_app_ar_vendor`
  - `orch_app_ar_orchadmin_users`
  - `orch_app_ar_owner`

#### store_availability_ds
- **Includes:** 11 views
- **Views:**
  - `dt_store_availability_analytics`
  - `dt_store_availability_tiktok`
  - `dt_store_availability_analytics_sme`
  - `dt_store_availability_shazam`
  - `prod_store_avail_store_avail_availability`
  - `orch_app_ar_artist_info`
  - `orch_app_ar_releases`
  - `orch_app_ar_vendor`
  - `facts_prod_dim_store`
  - `dt_store_availability_analytics_reduced`
  - `dt_store_availability_tiktok_reduced`

#### youtube_analytics_by_day_ds
- **Includes:** 9 views
- **Views:**
  - `dt_youtube_analytics_by_day`
  - `dt_itunes_tickets_by_day`
  - `dt_tiktok_hashtag_tickets_by_week`
  - `dt_tiktok_song_tickets_by_week`
  - `dt_tiktok_rows_by_day`
  - `dt_spotify_staging_raw_availability_sme`
  - `dt_sme_metadata_rows_by_day`
  - `dt_labelcopy_ingest_rows_by_day`
  - `dt_music_analytics_in_review_report`

## View Dependencies

### Views by Data Source

#### Direct Database Tables
Views that directly reference database tables:

**PROD.APPLE_PODCASTS_CONTENT_PERFORMANCE**
- Used by 1 views: `facts_prod_apple_podcasts_content_performance`


**PROD.APPLE_PODCASTS_SALES_SUMMARY**
- Used by 1 views: `facts_prod_apple_podcasts_sales_summary`


**PROD.APPLE_PODCASTS_SALES_SUMMARY_MONTHLY**
- Used by 1 views: `facts_prod_apple_podcasts_sales_summary_monthly`


**PROD.APPLE_PODCASTS_SUBSCRIPTION_EVENTS**
- Used by 1 views: `facts_prod_apple_podcasts_subscription_events`


**PROD.APPLE_PODCASTS_SUBSCRIPTION_EVENTS_MONTHLY**
- Used by 1 views: `facts_prod_apple_podcasts_subscription_events_monthly`


**PROD.APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT**
- Used by 1 views: `facts_prod_apple_podcasts_subscription_snapshot`


**PROD.APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT_MONTHLY**
- Used by 1 views: `facts_prod_apple_podcasts_subscription_snapshot_monthly`


**art_relations_prod_art_relations.artist_info**
- Used by 1 views: `orch_app_ar_artist_info`


**art_relations_prod_art_relations.country**
- Used by 1 views: `orch_app_ar_country`


**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.releases**
- Used by 1 views: `orch_app_ar_releases`


**nsnyder.sme_lat_long_to_dma**
- Used by 1 views: `dev_eng_nsnyder_sme_lat_long_to_dma`


**prod.apple_music_shazam_daily_events**
- Used by 1 views: `facts_prod_apple_music_shazam_daily_events`


**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.dim_country**
- Used by 1 views: `facts_prod_dim_country`


**prod.dim_day**
- Used by 1 views: `facts_prod_dim_day`


**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_store**
- Used by 1 views: `facts_prod_dim_store`


**prod.fact_analytics**
- Used by 1 views: `facts_prod_fact_analytics_for_master_calendar`


**prod.fact_market_share**
- Used by 1 views: `facts_prod_fact_market_share`


**prod.staging_raw_shazam**
- Used by 1 views: `facts_prod_staging_raw_shazam`


**prod.territory_grouping_v2**
- Used by 1 views: `int_prod_territory_grouping`


**prod.vw_dim_abacus_ar_vendor**
- Used by 1 views: `orch_app_ar_vendor`


**store_avail.availability**
- Used by 1 views: `prod_store_avail_store_avail_availability`


#### Derived Tables
Views with custom SQL (complex transformations):

Total: 53 views

| View | Lines of Code | Source Tables |
|------|---------------|---------------|
| `nav` | 771 | Custom SQL |
| `dt_store_availability_tiktok_reduced` | 519 |  All_Available, Prod.Dim_Day, Prod.Staging_Raw_... |
| `dt_store_availability_tiktok` | 519 |  All_Available, Prod.Dim_Day, Prod.Staging_Raw_... |
| `dt_store_availability_analytics_sme` | 356 |  Prod.Data_Availability_By_Store_Daily, Prod.Di... |
| `anr_likes_statistics` | 316 | Custom SQL |
| `anr_followers_statistics` | 263 | Custom SQL |
| `anr_tiktok` | 241 | Custom SQL |
| `anr_youtube` | 241 | Custom SQL |
| `anr_missing_days` | 239 | Custom SQL |
| `anr_soundcloud` | 228 | Custom SQL |
| `dt_store_availability_shazam` | 192 |  All_Available, Prod.Dim_Day, Prod.Dim_Store, P... |
| `dt_store_availability_analytics` | 191 |  Filtered_Summary, Prod.Data_Availability_By_St... |
| `dt_store_availability_analytics_reduced` | 190 |  Filtered_Summary, Prod.Data_Availability_By_St... |
| `anr_spotify` | 179 | Custom SQL |
| `dt_fact_sales_market_share_artist_level` | 172 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `metadata_simplified` | 164 |  Dbt_Prod.Metadata_Simplified, Intelligence.Dbt_Prod |
| `anr_instagram` | 163 | Custom SQL |
| `dt_fact_sales_market_share` | 162 |  Prod.Dim_Country, Prod.Fact_Market_Share, Prod.Fact_Sales |
| `anr_shazam` | 145 | Custom SQL |
| `dt_insights` | 138 |  Art_Relations_Prod_Art_Relations.Country, Art_... |

*Showing top 20 most complex derived views. Total: 53*


## Explore Relationships

### Explores and Their Dependencies

#### Model: OrchardGo_Adoption_Updated

**dt_orchgo_artist_level_label_invites** (dt_orchgo_artist_level_label_invites)
- Base View: `dt_orchgo_artist_level_label_invites`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Orchard_App_Reporting_V2...

**dt_orchgo_user_activity** (dt_orchgo_user_activity)
- Base View: `dt_orchgo_user_activity`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Mobile_Orchard_Prod_Andr...

**dt_orchgo_new_users** (dt_orchgo_new_users)
- Base View: `dt_orchgo_new_users`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Mobile_Orchard_Prod_Andr...

#### Model: anr_de_artists_test

**anr_de_artists_test** (DE Artists)
- Base View: `anr_de_artists_test`
- View Type: Derived Table
- Data Source: Derived from: Prod.Artist_To_Track_De

#### Model: anr_followers_statistics_ds

**anr_followers_statistics** (anr_followers_statistics)
- Base View: `anr_followers_statistics`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

#### Model: anr_likes_statistics_ds

**anr_likes_statistics** (anr_likes_statistics)
- Base View: `anr_likes_statistics`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

#### Model: anr_missing_days

**anr_missing_days** (anr_missing_days)
- Base View: `anr_missing_days`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_missing_days_count** (anr_missing_days_count)
- Base View: `anr_missing_days_count`
- View Type: Direct Table
- Data Source: Unknown

#### Model: anr_nav

**anr_nav** (anr_nav)
- Base View: `anr_nav`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

#### Model: anr_sc_artists_test

**anr_sc_artists_test** (SC Artists)
- Base View: `anr_sc_artists_test`
- View Type: Derived Table
- Data Source: Derived from: Prod.Artist_To_Track_Sc

#### Model: anr_shazam_ds

**anr_shazam** (anr_shazam)
- Base View: `anr_shazam`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_shazam_tracks_top_weekly_shazams** (anr_shazam_tracks_top_weekly_shazams)
- Base View: `anr_shazam_tracks_top_weekly_shazams`
- View Type: Direct Table
- Data Source: Unknown

**anr_shazam_tracks_spike_song** (anr_shazam_tracks_spike_song)
- Base View: `anr_shazam_tracks_spike_song`
- View Type: Direct Table
- Data Source: Unknown

#### Model: anr_shazam_total_ds

**anr_shazams** (anr_shazams)
- Base View: `anr_shazams`
- View Type: Direct Table
- Data Source: Unknown

**anr_shazam_average** (anr_shazam_average)
- Base View: `anr_shazam_average`
- View Type: Direct Table
- Data Source: Unknown

**anr_shazam_tracks** (anr_shazam_tracks)
- Base View: `anr_shazam_tracks`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_shazam_weekly** (anr_shazam_weekly)
- Base View: `anr_shazam_weekly`
- View Type: Direct Table
- Data Source: Unknown

#### Model: anr_spotify_monthly_listeners_ds

**anr_spotify_monthly_listeners** (anr_spotify_monthly_listeners)
- Base View: `anr_spotify_monthly_listeners`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

#### Model: anr_statistics_ds

**anr_instagram** (anr_instagram)
- Base View: `anr_instagram`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_soundcloud** (anr_soundcloud)
- Base View: `anr_soundcloud`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_spotify** (anr_spotify)
- Base View: `anr_spotify`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_youtube** (anr_youtube)
- Base View: `anr_youtube`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_youtube_views** (anr_youtube_views)
- Base View: `anr_youtube_views`
- View Type: Direct Table
- Data Source: Unknown

**anr_shazam_weeklies** (anr_shazam_weeklies)
- Base View: `anr_shazam_weeklies`
- View Type: Direct Table
- Data Source: Unknown

**anr_soundcloud_weekly** (anr_soundcloud_weekly)
- Base View: `anr_soundcloud_weekly`
- View Type: Direct Table
- Data Source: Unknown

#### Model: anr_tiktok_ds

**anr_tiktok** (anr_tiktok)
- Base View: `anr_tiktok`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_tiktok_followers** (anr_tiktok_followers)
- Base View: `anr_tiktok_followers`
- View Type: Direct Table
- Data Source: Unknown

**anr_tiktok_followings** (anr_tiktok_followings)
- Base View: `anr_tiktok_followings`
- View Type: Direct Table
- Data Source: Unknown

**anr_tiktok_likes** (anr_tiktok_likes)
- Base View: `anr_tiktok_likes`
- View Type: Direct Table
- Data Source: Unknown

#### Model: anr_top_staistics_ds

**anr_instagram_followers** (anr_instagram_followers)
- Base View: `anr_instagram_followers`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_instagram_engagement** (anr_instagram_engagement)
- Base View: `anr_instagram_engagement`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_plays** (anr_plays)
- Base View: `anr_plays`
- View Type: Direct Table
- Data Source: Unknown

**anr_views** (anr_views)
- Base View: `anr_views`
- View Type: Direct Table
- Data Source: Unknown

**anr_spotify_release** (anr_spotify_release)
- Base View: `anr_spotify_release`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_youtube_latest_release** (anr_youtube_latest_release)
- Base View: `anr_youtube_latest_release`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_youtube_subscribers** (anr_youtube_subscribers)
- Base View: `anr_youtube_subscribers`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

**anr_soundcloud_release** (anr_soundcloud_release)
- Base View: `anr_soundcloud_release`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

#### Model: anr_uk_artists_test

**anr_uk_artists_test** (UK Artists)
- Base View: `anr_uk_artists_test`
- View Type: Derived Table
- Data Source: Derived from: Prod.Artist_To_Track_Uk

#### Model: chartmetric_charts_ds

**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_backfill_ds

**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: chartmetric_socials_ds

**facts_prod_chartmetric_socials** (Chartmetric Ingestions)
- Base View: `facts_prod_chartmetric_socials`
- View Type: Direct Table
- Data Source: facts.prod.chartmetric_socials_log

#### Model: dt_awa_units_by_day_ds

**awa_internal_availability** (awa_internal_availability)
- Base View: `awa_internal_availability`
- View Type: Derived Table
- Data Source: Derived from: Prod.Dim_Day, Prod.Fact_Analytics

#### Model: dt_charts_monitoring

**dt_charts_monitoring_latest_update** (dt_charts_monitoring_latest_update)
- Base View: `dt_charts_monitoring_latest_update`
- View Type: Derived Table
- Data Source: Derived from: Prod.Dim_Chart

**dt_charts_monitoring_last_four_days** (dt_charts_monitoring_last_four_days)
- Base View: `dt_charts_monitoring_last_four_days`
- View Type: Derived Table
- Data Source: Derived from: Charts_Raw_Data, Prod.Dim_Chart, Prod.Fact_Charts

#### Model: dt_insights

**dt_insights** (dt_insights)
- Base View: `dt_insights`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Art_Relations_Prod_Art_R...

#### Model: dt_soundcloud_units_by_day_ds

**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: facts_prod_apple_podcast_analytics

**facts_prod_apple_podcasts_sales_summary** (Sales Summary Model)
- Base View: `facts_prod_apple_podcasts_sales_summary`
- View Type: Direct Table
- Data Source: FACTS.PROD.APPLE_PODCASTS_SALES_SUMMARY

**facts_prod_apple_podcasts_subscription_events** (Subscription Events Model)
- Base View: `facts_prod_apple_podcasts_subscription_events`
- View Type: Direct Table
- Data Source: FACTS.PROD.APPLE_PODCASTS_SUBSCRIPTION_EVENTS

**facts_prod_apple_podcasts_subscription_snapshot** (Subscription Snapshot Model)
- Base View: `facts_prod_apple_podcasts_subscription_snapshot`
- View Type: Direct Table
- Data Source: FACTS.PROD.APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT

**facts_prod_apple_podcasts_content_performance** (Content Performance Model)
- Base View: `facts_prod_apple_podcasts_content_performance`
- View Type: Direct Table
- Data Source: FACTS.PROD.APPLE_PODCASTS_CONTENT_PERFORMANCE

**apple_podcasts_max_listeners_per_episode_by_show** (Content Performance Model Max Listeners)
- Base View: `apple_podcasts_max_listeners_per_episode_by_show`
- View Type: Derived Table
- Data Source: Derived from: Prod.Apple_Podcasts_Content_Performance

**facts_prod_apple_podcasts_sales_summary_monthly** (Sales Summary Monthly Model)
- Base View: `facts_prod_apple_podcasts_sales_summary_monthly`
- View Type: Direct Table
- Data Source: FACTS.PROD.APPLE_PODCASTS_SALES_SUMMARY_MONTHLY

**facts_prod_apple_podcasts_subscription_events_monthly** (Subscription Events Monthly Model)
- Base View: `facts_prod_apple_podcasts_subscription_events_monthly`
- View Type: Direct Table
- Data Source: FACTS.PROD.APPLE_PODCASTS_SUBSCRIPTION_EVENTS_MONTHLY

**facts_prod_apple_podcasts_subscription_snapshot_monthly** (Subscription Snapshot Monthly Model)
- Base View: `facts_prod_apple_podcasts_subscription_snapshot_monthly`
- View Type: Direct Table
- Data Source: FACTS.PROD.APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT_MONTHLY

#### Model: market_share_temp_ds

**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: Derived from: Prod.Dim_Country, Prod.Fact_Market_Share, Prod.Fact_Sales

**dt_fact_sales_market_share_artist_level** (Label)
- Base View: `dt_fact_sales_market_share_artist_level`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Orchard_App_Reportin...

**dt_market_share_change** (Market Share Change)
- Base View: `dt_market_share_change`
- View Type: Derived Table
- Data Source: Derived Table (Custom SQL)

#### Model: master_calendar_ds

**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_ds

**facts_prod_dim_day** (dim_day_sme)
- Base View: `facts_prod_dim_day`
- View Type: Direct Table
- Data Source: facts.prod.dim_day

#### Model: shazam_ds

**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: store_availability_ds

**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...

**dt_store_availability_analytics_reduced** (Store Availability: Analytics)
- Base View: `dt_store_availability_analytics_reduced`
- View Type: Derived Table
- Data Source: Derived from: Filtered_Summary, Prod.Data_Availability_By_Store_Daily, Prod.Dim_...

**dt_store_availability_tiktok_reduced** (Store Availability: TikTok)
- Base View: `dt_store_availability_tiktok_reduced`
- View Type: Derived Table
- Data Source: Derived from: All_Available, Prod.Dim_Day, Prod.Staging_Raw_Tiktok, Prod.Staging...

**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: youtube_analytics_by_day_ds

**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_music_analytics_in_review_report** (Music Analytics In Review)
- Base View: `dt_music_analytics_in_review_report`
- View Type: Derived Table
- Data Source: Derived from: In_Review_Report, Prod.Dim_Day, Prod.Staging_Raw_Music_Analytics_I...

**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: Derived from: Dt_Tiktok_Top_Song_By_Day, Prod.Dim_Day, Prod.Staging_Raw_Tiktok_T...

**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: Derived Table
- Data Source: Derived from: Labelcopy_Ingest_Rows_By_Day, Prod.Dim_Day, Prod.Sme_Labelcopy_Ing...

**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)

## 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