# Data Lineage & Dependencies

Generated on: 2026-01-07 12:03:33

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

## Overview

- **Total Models:** 22
- **Total Views:** 370
- **Derived Views:** 111
- **Direct Table Views:** 259

## Model Dependencies

### Models and Their Views

#### Accounting
- **Includes:** 1 views
- **Views:**
  - `*.view`

#### Accounting_Aggregates
- **Includes:** 1 views
- **Views:**
  - `*.view`

#### Amazon_Unlimited_Source_of_Stream
- **Includes:** 1 views
- **Views:**
  - `staging_raw_amazon_unlimited.view`

#### Analytics
- **Includes:** 1 views
- **Views:**
  - `*.view`

#### Apple_Music_SOS
- **Includes:** 1 views
- **Views:**
  - `*.view`

#### Apple_Music_Source_of_Stream
- **Includes:** 1 views
- **Views:**
  - `*.view`

#### BIA_REP_product_insights
- **Includes:** 1 views
- **Views:**
  - `intelligence.prod.fact_conflict_snapshot`

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

#### Label_Territory_Carveouts
- **Includes:** 2 views
- **Views:**
  - `label_territory_carveout.view`
  - `vendor_dms_master_restriction.view`

#### Metadata
- **Includes:** 2 views
- **Views:**
  - `*.view`
  - `*.set`

#### RED
- **Includes:** 1 views
- **Views:**
  - `*.view`

#### Reports_AR_The_Orchard
- **Includes:** 1 views
- **Views:**
  - `*.view`

#### Snowflake_Usage
- **Includes:** 1 views
- **Views:**
  - `*.view`

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

#### Spotify_Source_Of_Stream
- **Includes:** 2 views
- **Views:**
  - `*.view`
  - `*.set`

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

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

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

#### hidden_content
- **Includes:** 1 views
- **Views:**
  - `*.view`

#### operations
- **Includes:** 1 views
- **Views:**
  - `*.view`

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

#### youtube_analytics
- **Includes:** 1 views
- **Views:**
  - `*.view`

## View Dependencies

### Views by Data Source

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

**"DBT_PROD"."ORCHARD_NEW_ADVERTISING_REQUESTS"**
- Used by 1 views: `advertising_requests`


**APPLEMUSIC.APPLE_MUSIC_SOS_AGGREGATED**
- Used by 1 views: `apple_music_sos_aggregated`


**ART_RELATIONS_PROD_ART_RELATIONS.CUSTOMER_MASTER_MASTER**
- Used by 2 views: `customer_master_master_snowflake`, `customer_master_master_snowflake_2`


**ART_RELATIONS_PROD_ART_RELATIONS.RELEASES**
- Used by 1 views: `releases_snowflake`


**ART_RELATIONS_PROD_ART_RELATIONS.TRACK**
- Used by 1 views: `track_snowflake`


**ART_RELATIONS_PROD_ART_RELATIONS.YOUTUBE_CHANNEL_UPC**
- Used by 1 views: `orch_app_ar_youtube_channel_upc`


**BI.ANALYTICS_AGGREGATED**
- Used by 1 views: `analytics_aggregated`


**BI.COUNTRY_VIEW**
- Used by 1 views: `country_view`


**BI.TRACK_ALL_TIME_UNITS**
- Used by 1 views: `track_all_time_units`


**DBT_PROD.AWAL_TIER_GROUPS**
- Used by 1 views: `int_dbt_prod_awal_tier_groups`


**DBT_PROD.DEBUT_FORECASTS**
- Used by 1 views: `Debut_Forecasting`


**DBT_PROD.ORCHARD_PRICING_BY_RELEASE**
- Used by 1 views: `int_prod_vw_orchard_pricing_by_release`


**DBT_PROD.SPOTIFY_TRACK_AUDIO_FEATURES**
- Used by 1 views: `int_dbt_prod_spotify_track_audio_features`


**HIDDEN_CONTENT.ITUNES_TICKETS_ACTION_REQUIRED_VIEW**
- Used by 1 views: `itunes_report.tickets_action_required_view`


**PROD.PASSTHRU_PROCESSED**
- Used by 1 views: `spotify_equity`


**PROD.VW_ABACUS_MANUAL_ADJUSTMENT**
- Used by 1 views: `manual_adjustment`


**PROD.VW_ABACUS_RELEASE_MANUAL_ADJUSTMENT**
- Used by 1 views: `release_manual_adjustment_snowflake`


**PROD.VW_ABACUS_VENDOR_ACCOUNTING**
- Used by 1 views: `vendor_accounting_snowflake`


**PROD.VW_DIM_ABACUS_AR_BOOKED_VENDOR_CONTRACT_SNAPSHOT**
- Used by 1 views: `booked_vendor_contract_snapshot`


**REPORTSDD_DIRECT_DELIVERY.DMS_ENCODING_PROFILE**
- Used by 1 views: `dms_encoding_profile`


**REPORTSDD_DIRECT_DELIVERY.ENCODING_PROFILE**
- Used by 1 views: `encoding_profile`


**SPOTIFY.PERCENT_OF_STREAMS_PER_DAY**
- Used by 1 views: `percent_of_streams_per_day`


**account_usage.databases**
- Used by 1 views: `databases_snowflake_usage`


**account_usage.login_history**
- Used by 1 views: `login_history_snowflake_usage`


**account_usage.query_history**
- Used by 1 views: `query_history_snowflake_usage`


**account_usage.schemata**
- Used by 1 views: `schemata_snowflake_usage`


**account_usage.storage_usage**
- Used by 1 views: `storage_usage_snowflake_usage`


**account_usage.tables**
- Used by 1 views: `tables_snowflake_usage`


**account_usage.warehouse_metering_history**
- Used by 1 views: `warehouse_metering_history_snowflake_usage`


**art_relations.api_product_label_installations**
- Used by 1 views: `api_product_label_installations`


**art_relations.artist_info**
- Used by 1 views: `artist_info`


**art_relations.contact**
- Used by 1 views: `contact`


**art_relations.country**
- Used by 2 views: `country`, `vendor_country`


**art_relations.delivery_history**
- Used by 1 views: `art_relations_delivery_history`


**art_relations.distribution_format**
- Used by 1 views: `distribution_format`


**art_relations.distribution_format_media**
- Used by 1 views: `distribution_format_media`


**art_relations.genre**
- Used by 2 views: `genre`, `vendor_primary_genre`


**art_relations.ioda_rightsholder_mapping**
- Used by 1 views: `ioda_rightsholder_mapping`


**art_relations.mkt_priority**
- Used by 1 views: `mkt_priority`


**art_relations.mkt_program**
- Used by 1 views: `mkt_program`


**art_relations.mkt_program_info**
- Used by 1 views: `mkt_program_info`


**art_relations.orchadmin_users**
- Used by 2 views: `orchadmin_users`, `orchadmin_closer`


**art_relations.orchard_state**
- Used by 1 views: `orchard_state`


**art_relations.physical_order_targets**
- Used by 1 views: `physical_order_targets`


**art_relations.product_physical**
- Used by 1 views: `product_physical`


**art_relations.product_physical_change_history**
- Used by 1 views: `product_physical_change_history`


**art_relations.product_physical_packaging**
- Used by 1 views: `product_physical_packaging`


**art_relations.product_type**
- Used by 1 views: `product_type_art_relations`


**art_relations.proper_stock_essn**
- Used by 1 views: `proper_stock_essn`


**art_relations.release_grid**
- Used by 1 views: `release_grid`


**art_relations.release_subgenre**
- Used by 1 views: `release_subgenre`


**art_relations.release_territory_restriction**
- Used by 1 views: `release_territory_restriction`


**art_relations.releases**
- Used by 1 views: `releases`


**art_relations.subaccount**
- Used by 1 views: `subaccount`


**art_relations.subgenre**
- Used by 1 views: `subgenre`


**art_relations.track**
- Used by 1 views: `track`


**art_relations.track_master_rights**
- Used by 1 views: `track_master_rights`


**art_relations.track_producer_nationality**
- Used by 1 views: `track_producer_nationality`


**art_relations.vend_contact**
- Used by 1 views: `vend_contact`


**art_relations.vendor**
- Used by 1 views: `vendor`


**art_relations.vendor_contract**
- Used by 1 views: `vendor_contract`


**art_relations.vw_active_vendor_contract**
- Used by 1 views: `vw_active_vendor_contract`


**art_relations.youtube_channel**
- Used by 1 views: `youtube_channel`


**art_relations.youtube_channel_service_tier_history**
- Used by 1 views: `youtube_channel_service_tier_history`


**art_relations_log.releases_log**
- Used by 1 views: `releases_log`


**art_relations_prod_art_relations.PRODUCT_PHYSICAL_SUPPLY_CHAIN_INFO**
- Used by 1 views: `product_physical_supply_chain_info`


**art_relations_prod_art_relations.artist_custom_events**
- Used by 1 views: `artist_custom_events_snowflake`


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


**art_relations_prod_art_relations.asset**
- Used by 1 views: `asset_snowflake`


**art_relations_prod_art_relations.closed_caption_reasons**
- Used by 1 views: `closed_caption_reasons_snowflake`


**art_relations_prod_art_relations.contact**
- Used by 1 views: `contact_snowflake`


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


**art_relations_prod_art_relations.currencies**
- Used by 1 views: `currencies_snowflake`


**art_relations_prod_art_relations.currency_exchange_rates**
- Used by 1 views: `currency_exchange_rates`


**art_relations_prod_art_relations.customer_master**
- Used by 1 views: `customer_master_snowflake`


**art_relations_prod_art_relations.customer_master_master_distribution_type**
- Used by 1 views: `customer_master_master_distribution_type_snowflake`


**art_relations_prod_art_relations.delivery_history**
- Used by 1 views: `delivery_history_snowflake`


**art_relations_prod_art_relations.distribution_format**
- Used by 1 views: `distribution_format_snowflake`


**art_relations_prod_art_relations.distribution_format_media**
- Used by 1 views: `distribution_format_media_snowflake`


**art_relations_prod_art_relations.distribution_type**
- Used by 1 views: `distribution_type_snowflake`


**art_relations_prod_art_relations.dms_genre_mapping**
- Used by 1 views: `dms_genre_mapping_snowflake`


**art_relations_prod_art_relations.dms_master_genre**
- Used by 1 views: `dms_master_genre_snowflake`


**art_relations_prod_art_relations.dms_subgenre_mapping**
- Used by 1 views: `dms_subgenre_mapping_snowflake`


**art_relations_prod_art_relations.encoding_order**
- Used by 1 views: `orch_app_ar.encoding_order`


**art_relations_prod_art_relations.film_genre**
- Used by 2 views: `art_relations_prod_film_genre`, `film_genre_snowflake`


**art_relations_prod_art_relations.genre**
- Used by 1 views: `genre_snowflake`


**art_relations_prod_art_relations.import_asset**
- Used by 1 views: `import_asset_snowflake`


**art_relations_prod_art_relations.import_asset_batch**
- Used by 1 views: `import_asset_batch_snowflake`


**art_relations_prod_art_relations.import_asset_detail**
- Used by 1 views: `import_asset_detail_snowflake`


**art_relations_prod_art_relations.language**
- Used by 1 views: `language_snowflake`


**art_relations_prod_art_relations.manual_adjustment_category**
- Used by 1 views: `manual_adjustment_category`


**art_relations_prod_art_relations.mfit_studio**
- Used by 1 views: `mfit_studio_snowflake`


**art_relations_prod_art_relations.mkt_program**
- Used by 1 views: `mkt_program_snowflake`


**art_relations_prod_art_relations.orchadmin_users**
- Used by 2 views: `orchadmin_users_snowflake`, `orchadmin_users_snowflake_2`


**art_relations_prod_art_relations.owner**
- Used by 1 views: `owner_snowflake`


**art_relations_prod_art_relations.period**
- Used by 1 views: `period_snowflake`


**art_relations_prod_art_relations.product_distribution**
- Used by 1 views: `orch_app_ar_product_distribution`


**art_relations_prod_art_relations.product_physical**
- Used by 1 views: `product_physical_snowflake`


**art_relations_prod_art_relations.product_physical_packaging**
- Used by 1 views: `product_physical_packaging_snowflake`


**art_relations_prod_art_relations.project**
- Used by 2 views: `project_snowflake`, `art_relations_prod_project`


**art_relations_prod_art_relations.proper_stock_essn**
- Used by 1 views: `proper_stock_essn_snowflake`


**art_relations_prod_art_relations.release_correction**
- Used by 1 views: `release_correction_snowflake`


**art_relations_prod_art_relations.release_correction_detail**
- Used by 1 views: `release_correction_detail_snowflake`


**art_relations_prod_art_relations.release_dms_master_restriction**
- Used by 1 views: `release_dms_master_restriction_snowflake`


**art_relations_prod_art_relations.release_dms_restriction**
- Used by 1 views: `release_dms_restriction_snowflake`


**art_relations_prod_art_relations.release_film_genre**
- Used by 2 views: `art_relations_prod_release_film_genre`, `release_film_genre_snowflake`


**art_relations_prod_art_relations.release_grid**
- Used by 1 views: `release_grid_snowflake`


**art_relations_prod_art_relations.release_mfit_info**
- Used by 1 views: `release_mfit_info_snowflake`


**art_relations_prod_art_relations.release_subgenre**
- Used by 1 views: `release_subgenre_snowflake`


**art_relations_prod_art_relations.release_subtitles**
- Used by 1 views: `release_subtitles_snowflake`


**art_relations_prod_art_relations.release_territory_restriction**
- Used by 1 views: `release_territory_restriction_snowflake`


**art_relations_prod_art_relations.releases**
- Used by 1 views: `art_relations_prod_releases`


**art_relations_prod_art_relations.service_type**
- Used by 1 views: `orch_app.ar.service_type`


**art_relations_prod_art_relations.subaccount**
- Used by 1 views: `subaccount_snowflake`


**art_relations_prod_art_relations.subaccount_dms_master_restriction**
- Used by 1 views: `subaccount_dms_master_restriction_snowflake`


**art_relations_prod_art_relations.subaccount_dms_restriction**
- Used by 1 views: `subaccount_dms_restriction_snowflake`


**art_relations_prod_art_relations.subaccount_territory_restriction**
- Used by 1 views: `subaccount_territory_restriction_snowflake`


**art_relations_prod_art_relations.subgenre**
- Used by 1 views: `subgenre_snowflake`


**art_relations_prod_art_relations.track_instant_grat**
- Used by 1 views: `track_instant_grat_snowflake`


**art_relations_prod_art_relations.track_master_rights**
- Used by 1 views: `track_master_rights_snowflake`


**art_relations_prod_art_relations.track_physical**
- Used by 2 views: `track_physical`, `orch_app_ar_track_physical`


**art_relations_prod_art_relations.track_producer_nationality**
- Used by 1 views: `track_producer_nationality_snowflake`


**art_relations_prod_art_relations.track_video**
- Used by 1 views: `track_video_snowflake`


**art_relations_prod_art_relations.travelex**
- Used by 1 views: `travelex_snowflake`


**art_relations_prod_art_relations.vend_contact**
- Used by 1 views: `vend_contact_snowflake`


**art_relations_prod_art_relations.vendor_contract_advance**
- Used by 1 views: `vendor_contract_advance_snowflake`


**art_relations_prod_art_relations.vendor_contract_change_history**
- Used by 1 views: `vendor_contract_change_history`


**art_relations_prod_art_relations.vendor_dms_master_contract**
- Used by 1 views: `vendor_dms_master_contract_snowflake`


**art_relations_prod_art_relations.vendor_dms_master_restriction**
- Used by 1 views: `vendor_dms_master_restriction_snowflake`


**art_relations_prod_art_relations.vendor_proposed_term**
- Used by 1 views: `vendor_proposed_term`


**art_relations_prod_art_relations.vendor_proposed_term_change_history**
- Used by 1 views: `vendor_proposed_term_change_history`


**art_relations_prod_art_relations.vendor_territory_contract**
- Used by 1 views: `vendor_territory_contract_snowflake`


**art_relations_prod_art_relations.vendor_territory_restriction**
- Used by 1 views: `vendor_territory_restriction`


**art_relations_prod_art_relations.vendor_transaction_type_contract**
- Used by 1 views: `vendor_transaction_type_contract_snowflake`


**art_relations_prod_art_relations.vendor_tt_territory_contract**
- Used by 1 views: `vendor_tt_territory_contract_snowflake`


**art_relations_prod_art_relations.youtube_channel**
- Used by 1 views: `orch_app_ar_youtube_channel`


**art_relations_prod_art_relations_log.releases_log**
- Used by 1 views: `releases_log_snowflake`


**bi.LABEL_YEARLY_ACTIVE_RELEASES**
- Used by 1 views: `label_yearly_active_releases`


**bi.accounting**
- Used by 1 views: `bi.accounting`


**bi.accounting_aggregates**
- Used by 1 views: `accounting_aggregates`


**bi.analytics_track_level**
- Used by 1 views: `bi.analytics_track_level`


**bi.artist_name_cleaned**
- Used by 1 views: `bi.artist_name_cleaned`


**bi.artist_view**
- Used by 1 views: `bi.artist_view`


**bi.artists_blacklisted_by_itunes**
- Used by 1 views: `bi.artists_blacklisted_by_itunes`


**bi.country_view**
- Used by 1 views: `bi.country_view`


**bi.digital_splits**
- Used by 1 views: `digital_splits`


**bi.fx_rates_payout_statements_db**
- Used by 1 views: `bi.fx_rates_payout_statements_db.view`


**bi.genre_view**
- Used by 1 views: `bi.genre_view`


**bi.label_view**
- Used by 1 views: `bi.label_view`


**bi.label_yearly_active_artists**
- Used by 1 views: `label_yearly_active_artists`


**bi.period_view**
- Used by 1 views: `bi.period_view`


**bi.release_with_metadata_view**
- Used by 1 views: `bi.release_with_metadata_view`


**bi.store_view**
- Used by 1 views: `bi.store_view`


**bi.track_artists_by_track_id**
- Used by 1 views: `bi.track_artists_by_track_id`


**bi.track_with_upc_view**
- Used by 1 views: `bi.track_with_upc_view`


**country**
- Used by 1 views: `statementsdb_country`


**customer_master_master**
- Used by 1 views: `statementsdb_customer_master_master`


**dbt_prod.active_vendor_contracts**
- Used by 1 views: `vw_active_vendor_contract_snowflake`


**dbt_prod.artist_socials_page_urls**
- Used by 1 views: `int_dbt_prod_artist_socials_page_urls`


**dbt_prod.focus_track_pitch_grid**
- Used by 1 views: `orch_app_ar_focus_track`


**dbt_prod.orch_app_ar_track_track_physical_joined**
- Used by 1 views: `orch_app_ar_track`


**dbt_prod.restrictions_release_territory**
- Used by 1 views: `int_prod_vw_restrictions_release_territory`


**dev.dummy_table**
- Used by 1 views: `dummy_table`


**dev.owned_and_operated_artist_royalty_rates**
- Used by 1 views: `owned_and_operated_artist_royalty_rates`


**dev.track_level_outages**
- Used by 1 views: `analytics_track_level_date_monitor`


**dig_sales_analytics**
- Used by 1 views: `statementsdb_dig_sales_analytics`


**dig_sales_period_id**
- Used by 1 views: `dig_sales_period_id`


**direct_delivery.customer_master_master**
- Used by 1 views: `operations.customer`


**dms_delivery_spec**
- Used by 1 views: `operations_dms_delivery_spec`


**effective_units.MAX_ITUNES_US_DT_GROSS_UNITS_BY_DATE**
- Used by 1 views: `max_itunes_us_dt_gross_units_by_date`


**effective_units.analytics_effective_units_stage_for_joining**
- Used by 1 views: `analytics_effective_units_stage_for_joining`


**effective_units.effective_units_mult_factor_by_date_country_store_transac**
- Used by 1 views: `effective_units`


**effective_units.itunes_us_dt_gross_units_by_date**
- Used by 1 views: `itunes_us_dt_gross_units_by_date`


**hidden_content.itunes_hidden_view**
- Used by 1 views: `itunes_report.hidden_tracks_view`


**hidden_content.spotify_hidden_view**
- Used by 2 views: `hidden_content.spotify_hidden_view`, `hidden_content.spotify_strikes_view`


**prod.CDSUS_BILLING_HISTORY**
- Used by 1 views: `cdsus_billing_history`


**prod.DIM_ARTIST**
- Used by 1 views: `dim_artist`


**prod.DIM_COUNTRY**
- Used by 1 views: `dim_country`


**prod.DIM_CURRENCY**
- Used by 1 views: `dim_currency`


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


**prod.DIM_GENRE**
- Used by 1 views: `dim_genre`


**prod.DIM_IMPRINT**
- Used by 1 views: `dim_imprint`


**prod.DIM_LABEL**
- Used by 1 views: `dim_label`


**prod.DIM_OWNER**
- Used by 1 views: `dim_owner`


**prod.DIM_PERIOD**
- Used by 2 views: `dim_period`, `dim_period_accounting`


**prod.DIM_RELEASE**
- Used by 1 views: `dim_release`


**prod.DIM_STORE**
- Used by 1 views: `dim_store`


**prod.DIM_SUBACCOUNT**
- Used by 1 views: `dim_subaccount`


**prod.DIM_TRACK**
- Used by 1 views: `dim_track`


**prod.DIM_TRANSACTIONTYPE**
- Used by 1 views: `dim_transactiontype`


**prod.DMS_CUSTOMER**
- Used by 1 views: `dms_customer`


**prod.STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS**
- Used by 1 views: `staging_raw_spotify_aggregated_streams`


**prod.apple_id_mapping**
- Used by 1 views: `apple_id_mapping`


**prod.cdsus_customer**
- Used by 1 views: `cdsus_customer`


**prod.cdsus_product**
- Used by 1 views: `cdsus_product`


**prod.demographics_region_mapping_v2**
- Used by 1 views: `demographics_region_mapping_v2`


**prod.dim_catalog**
- Used by 1 views: `dim_catalog`


**prod.dim_project**
- Used by 1 views: `dim_project`


**prod.dim_subaccount**
- Used by 1 views: `production.dim_subaccount`


**prod.dim_track**
- Used by 1 views: `production.dim_track`


**prod.dim_track_clean**
- Used by 1 views: `dim_track_clean`


**prod.fact_conflict_snapshot**
- Used by 1 views: `intelligence.prod.fact_conflict_snapshot`


**prod.product_type**
- Used by 1 views: `product_type_snowflake`


**prod.restrictions_label_territory**
- Used by 1 views: `int_prod_vw_restrictions_label_territory`


**prod.selling_company_regular_sales_view**
- Used by 1 views: `selling_company_regular_sales_view`


**prod.shazam_daily_events**
- Used by 1 views: `shazam_daily_events`


**prod.staging_raw_amazon_unlimited**
- Used by 1 views: `staging_raw_amazon_unlimited`


**prod.staging_raw_apple_music_streams**
- Used by 1 views: `staging_raw_apple_music_streams`


**prod.staging_raw_spotify_v2**
- Used by 1 views: `staging_raw_spotify_v2`


**prod.staging_raw_youtube_monthly_v2**
- Used by 1 views: `staging_raw_youtube_monthly`


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


**prod.vw_dim_abacus_ar_vendor_contract**
- Used by 1 views: `vendor_contract_snowflake_original`


**prod.workstation_fact_sales_unified_dbt**
- Used by 1 views: `fact_sales`


**prod_ows_pricing_pricing.PRODUCT_STORE_EFFECTIVE_PRICE_CODE**
- Used by 1 views: `product_store_effective_price_code`


**prod_ows_pricing_pricing.orchard_pricing_tier**
- Used by 1 views: `orchard_pricing_tier`


**prod_ows_pricing_pricing.product_orchard_pricing_tier**
- Used by 1 views: `product_orchard_pricing_tier`


**prod_ows_track_ows_track.performer**
- Used by 1 views: `performer_snowflake`


**prod_ows_track_ows_track.performer_role**
- Used by 1 views: `performer_role_snowflake`


**prod_promo_player_promo_player.promo_player**
- Used by 1 views: `promo_player`


**prod_sales_goals_sales_goals.TARGET_MARKET_GOAL**
- Used by 1 views: `target_market_goal`


**prod_sales_goals_sales_goals.sales_goal**
- Used by 1 views: `sales_goal`


**prod_sales_goals_sales_goals.store**
- Used by 1 views: `store_physical_sales_goal`


**prod_sony_metadata_sony_metadata.field_manager**
- Used by 1 views: `field_manager_snowflake`


**reportsdd_direct_delivery.asset**
- Used by 2 views: `orch_app_dd_asset`, `direct_delivery_asset_snowflake`


**reportsdd_direct_delivery.asset_location**
- Used by 2 views: `orch_app_dd_asset_location`, `asset_location_snowflake`


**reportsdd_direct_delivery.asset_location_detail**
- Used by 2 views: `asset_location_detail_snowflake`, `orch_app_dd_asset_location_detail`


**reportsdd_direct_delivery.customer_master_master**
- Used by 1 views: `direct_delivery_customer_master_master_snowflake`


**reportsdd_direct_delivery.dms_delivery_spec**
- Used by 1 views: `dms_delivery_spec_snowflake`


**reportsdd_direct_delivery.encoding_queue**
- Used by 1 views: `encoding_queue_snowflake`


**reportsdd_direct_delivery.encoding_queue_detail**
- Used by 1 views: `encoding_queue_detail_snowflake`


**reportsdd_direct_delivery.storage**
- Used by 1 views: `storage_snowflake`


**reportsdd_direct_delivery.storage_drive**
- Used by 1 views: `storage_drive_snowflake`


**spotify.playlist_owner**
- Used by 1 views: `spotify.playlist_owner`


**spotify.spotify_sos_aggregated**
- Used by 1 views: `spotify_sos_aggregated`


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


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

Total: 111 views

| View | Lines of Code | Source Tables |
|------|---------------|---------------|
| `dt_mgm_physical_price_code` | 600 |  Orchard_App_Reporting_V2, Orchard_App_Reportin... |
| `dt_membran_physical_price_code` | 599 |  Orchard_App_Reporting_V2, Orchard_App_Reportin... |
| `ca_physical_product_view_with_release_grid` | 489 |  Art_Relations_Prod_Art_Relations.Release_Grid,... |
| `vendor_contract_snowflake` | 471 |  Prod.Vw_Dim_Abacus_Ar_Vendor_Contract, Royalty... |
| `us_physical_product_view_with_release_grid` | 445 |  Art_Relations_Prod_Art_Relations.Release_Grid,... |
| `peer_generator` | 346 |  Bi.Label_Yearly_Revenue, Bi.Second_Genre_Per_L... |
| `us_physical_retail_view_with_release_grid` | 344 |  Art_Relations_Prod_Art_Relations.Release_Grid,... |
| `ca_physical_retail_view_with_release_grid` | 333 |  Art_Relations_Prod_Art_Relations.Release_Grid,... |
| `spot_metadata.playlist_metadata` | 281 |  Prod.Spotify_Playlists_Cache |
| `dms_preferred_deliverable_upcs` | 272 | Custom SQL |
| `label_territory_carveout` | 253 |  Art_Relations, Art_Relations.Country, Art_Rela... |
| `deliverable_digital_substore_snowflake` | 229 | Custom SQL |
| `worldwide_trending_tracks` | 202 |  Analytics_Aggregated, Analytics_Aggregated.Act... |
| `deliverable_digital_release_snowflake` | 199 | Custom SQL |
| `delivery_history_delivered_status` | 172 | Custom SQL |
| `tcat_data` | 164 |  Art_Relations.Artist_Info, Art_Relations.Distr... |
| `deliverable_digital_subaccount_snowflake` | 154 | Custom SQL |
| `artists_perc_of_revenue` | 154 |  Bi.Accounting_Aggregates |
| `release_perc_of_revenue` | 147 |  Bi.Accounting_Aggregates |
| `mkt_program_info_snowflake` | 146 |  Art_Relations_Prod_Art_Relations.Mkt_Program_I... |

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


## Explore Relationships

### Explores and Their Dependencies

#### Model: Accounting

**bi_accounting** (Track Level)
- Base View: `bi_accounting`
- View Type: Direct Table
- Data Source: Unknown

**peer_generator** (peer_generator)
- Base View: `peer_generator`
- View Type: Derived Table
- Data Source: Derived from: Bi.Label_Yearly_Revenue, Bi.Second_Genre_Per_Label, Bi.Top_Genre_P...

#### Model: Accounting_Aggregates

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

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

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

#### Model: Amazon_Unlimited_Source_of_Stream

**staging_raw_amazon_unlimited** (Amazon Unlimited SOS)
- Base View: `staging_raw_amazon_unlimited`
- View Type: Direct Table
- Data Source: facts.prod.staging_raw_amazon_unlimited

#### Model: Analytics

**shazam_daily_events** (Shazam)
- Base View: `shazam_daily_events`
- View Type: Direct Table
- Data Source: facts.prod.shazam_daily_events

#### Model: Apple_Music_SOS

**staging_raw_apple_music_streams** (Territory)
- Base View: `staging_raw_apple_music_streams`
- View Type: Direct Table
- Data Source: facts.prod.staging_raw_apple_music_streams

#### Model: Apple_Music_Source_of_Stream

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

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

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

#### Model: BIA_REP_product_insights

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

#### Model: Debut_Forecasting

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

#### Model: Label_Territory_Carveouts

**label_territory_carveout** (label_territory_carveout)
- Base View: `label_territory_carveout`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations, Art_Relations.Country, Art_Relations.Orchadmin_User...

#### Model: Metadata

**bi_release_with_metadata_view** (Release-Level Metadata)
- Base View: `bi_release_with_metadata_view`
- View Type: Direct Table
- Data Source: Unknown

**bi_track_view** (Track-Level Metadata)
- Base View: `bi_track_view`
- View Type: Direct Table
- Data Source: Unknown

#### Model: RED

**us_physical_product_view_with_release_grid** (First Weeks Sales)
- Base View: `us_physical_product_view_with_release_grid`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Release_Grid, Orchard_App_Reporti...

**cdsus_billing_history** (CDS Customer)
- Base View: `cdsus_billing_history`
- View Type: Direct Table
- Data Source: sony_internal.prod.CDSUS_BILLING_HISTORY

**us_physical_retail_view_with_release_grid** (Releases)
- Base View: `us_physical_retail_view_with_release_grid`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Release_Grid, Orchard_App_Reporti...

**ca_physical_product_view_with_release_grid** (First Weeks Sales)
- Base View: `ca_physical_product_view_with_release_grid`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Release_Grid, Orchard_App_Reporti...

**ca_physical_retail_view_with_release_grid** (Releases)
- Base View: `ca_physical_retail_view_with_release_grid`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Release_Grid, Orchard_App_Reporti...

**track_snowflake** (Releases)
- Base View: `track_snowflake`
- View Type: Direct Table
- Data Source: ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.TRACK

**releases_snowflake** (Track)
- Base View: `releases_snowflake`
- View Type: Direct Table
- Data Source: ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.RELEASES

**vendor_snowflake** (Subaccount)
- Base View: `vendor_snowflake`
- View Type: Direct Table
- Data Source: royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor

**gfk_view** (GFK)
- Base View: `gfk_view`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

#### Model: Reports_AR_The_Orchard

**vendor** (Label Level Report)
- Base View: `vendor`
- View Type: Direct Table
- Data Source: art_relations.vendor

**releases** (Release Level Report)
- Base View: `releases`
- View Type: Direct Table
- Data Source: art_relations.releases

**track** (Track Level Report)
- Base View: `track`
- View Type: Direct Table
- Data Source: art_relations.track

**tcat_data** (tcat_data)
- Base View: `tcat_data`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations.Artist_Info, Art_Relations.Distribution_Format, Art_...

#### Model: Snowflake_Usage

**login_history_snowflake_usage** (Login Facts)
- Base View: `login_history_snowflake_usage`
- View Type: Direct Table
- Data Source: snowflake.account_usage.login_history

**query_history_snowflake_usage** (Databases)
- Base View: `query_history_snowflake_usage`
- View Type: Direct Table
- Data Source: snowflake.account_usage.query_history

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

**user_login_facts_snowflake_usage** (user_login_facts_snowflake_usage)
- Base View: `user_login_facts_snowflake_usage`
- View Type: Derived Table
- Data Source: Derived from: Account_Usage, Account_Usage.Login_History

**storage_usage_snowflake_usage** (storage_usage_snowflake_usage)
- Base View: `storage_usage_snowflake_usage`
- View Type: Direct Table
- Data Source: snowflake.account_usage.storage_usage

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

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

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

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

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

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

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

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

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

**tables_snowflake_usage** (tables_snowflake_usage)
- Base View: `tables_snowflake_usage`
- View Type: Direct Table
- Data Source: snowflake.account_usage.tables

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

**warehouse_metering_history_snowflake_usage** (warehouse_metering_history_snowflake_usage)
- Base View: `warehouse_metering_history_snowflake_usage`
- View Type: Direct Table
- Data Source: snowflake.account_usage.warehouse_metering_history

#### Model: Spotify_SOS

**staging_raw_spotify_v2** (Spotify SOS)
- Base View: `staging_raw_spotify_v2`
- View Type: Direct Table
- Data Source: facts.prod.staging_raw_spotify_v2

**staging_raw_spotify_aggregated_streams** (Spotify Skips & Saves)
- Base View: `staging_raw_spotify_aggregated_streams`
- View Type: Direct Table
- Data Source: facts.prod.STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS

#### Model: Spotify_Source_Of_Stream

**staging_raw_spotify_aggregated_streams** (_Staging Raw Spotify Aggregated Streams)
- Base View: `staging_raw_spotify_aggregated_streams`
- View Type: Direct Table
- Data Source: facts.prod.STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS

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

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

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

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

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

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

#### Model: art_relations_snowflake

**releases_snowflake** (Artist Info)
- Base View: `releases_snowflake`
- View Type: Direct Table
- Data Source: ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.RELEASES

**track_snowflake** (Pitch Info)
- Base View: `track_snowflake`
- View Type: Direct Table
- Data Source: ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.TRACK

**vendor_snowflake** (Label)
- Base View: `vendor_snowflake`
- View Type: Direct Table
- Data Source: royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor

#### Model: direct_delivery_snowflake

**encoding_queue_detail_snowflake** (Encoding Queue Detail)
- Base View: `encoding_queue_detail_snowflake`
- View Type: Direct Table
- Data Source: orchard_app_reporting_v2.reportsdd_direct_delivery.encoding_queue_detail

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

#### Model: fact_sales

**fact_sales** (Date)
- Base View: `fact_sales`
- View Type: Direct Table
- Data Source: royalty_accounting.prod.workstation_fact_sales_unified_dbt

**comp_set_release_requirements** (Accounting)
- Base View: `comp_set_release_requirements`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Distribution_Format, Art_Relation...

**spotify_equity** (Track)
- Base View: `spotify_equity`
- View Type: Direct Table
- Data Source: ACCOUNTINGFLAT.PROD.PASSTHRU_PROCESSED

#### Model: hidden_content

**hidden_content_spotify_hidden_view** (Spotify Hides)
- Base View: `hidden_content_spotify_hidden_view`
- View Type: Direct Table
- Data Source: Unknown

**itunes_report_hidden_tracks_view** (iTunes Hides)
- Base View: `itunes_report_hidden_tracks_view`
- View Type: Direct Table
- Data Source: Unknown

#### Model: operations

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

#### Model: trending_tracks

**worldwide_trending_tracks** (worldwide_trending_tracks)
- Base View: `worldwide_trending_tracks`
- View Type: Derived Table
- Data Source: Derived from: Analytics_Aggregated, Analytics_Aggregated.Activity_Date, Bi.Analy...

#### Model: youtube_analytics

**staging_raw_youtube_monthly** (Country)
- Base View: `staging_raw_youtube_monthly`
- View Type: Direct Table
- Data Source: facts.prod.staging_raw_youtube_monthly_v2

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