# Data Lineage & Dependencies

Generated on: 2026-06-29 06:33:55

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

## Overview

- **Total Models:** 16
- **Total Views:** 124
- **Derived Views:** 50
- **Direct Table Views:** 74

## Model Dependencies

### Models and Their Views

#### periscope_migration
- **Includes:** 16 views
- **Views:**
  - `periscope_migration/potential_audio_infringement_audit_history`
  - `periscope_migration/review_product_history/review_history`
  - `periscope_migration/review_product_history/approvals`
  - `periscope_migration/review_product_history/rejections`
  - `periscope_migration/review_product_history/queue_move_history_escalations`
  - `periscope_migration/review_product_history/queue_move_history`
  - `periscope_migration/review_product_history/validation_history`
  - `periscope_migration/review_approval_history`
  - `periscope_migration/assigned_reviewer_change_log`
  - `periscope_migration/content_integrity_team_analytics/content_review_sla`
  - `periscope_migration/content_distribution_statistics/content_deliveries`
  - `periscope_migration/content_integrity_team_analytics/team_volume_speed`
  - `periscope_migration/content_integrity_team_analytics/review_session_history`
  - `periscope_migration/content_integrity_team_analytics/review_volume`
  - `periscope_migration/content_integrity_team_analytics/validation_codes`
  - `periscope_migration/content_integrity_team_analytics/completion_reasons_separated`

#### rights_mgmt_content_int
- **Includes:** 41 views
- **Views:**
  - `dt_youtube_dashboard`
  - `dt_avod_svod_join`
  - `dt_yt_conflicts`
  - `dt_isrc_assignment_history`
  - `dt_account_termination`
  - `facts_prod_youtube_monthly_ad_enabled`
  - `int_dbt_prod_youtube_subscription`
  - `yt_performance_report/month_year`
  - `yt_performance_report/total_revenue_views`
  - `yt_performance_report/avod_revenue_views`
  - `yt_performance_report/svod_revenue_views`
  - `yt_performance_report/ugc_revenue_views`
  - `yt_performance_report/premium_revenue_views`
  - `yt_performance_report/art_tracks_revenue_views`
  - `yt_performance_report/cpm`
  - `yt_performance_report/cpm_fill_rate`
  - `yt_performance_report/revenue_pie_chart`
  - `yt_performance_report/rpm_timeline`
  - `yt_performance_report/views_pie_chart`
  - `dt_apple_lyrics_breakdown`
  - `yt_performance_report/content_type_combined`
  - `yt_performance_report/top_ten_countries`
  - `dt_incomplete_reviews`
  - `yt_performance_report/fiscal_yr_comparison`
  - `dt_registry_territory_match`
  - `tiktok_conflicts/tiktok_carveout_monetization`
  - `tiktok_conflicts/no_tiktok_carveout_no_monetization`
  - `tiktok_conflicts/territory_carveout_missing_monetization`
  - `dt_Third_Party_Publishing_Claims`
  - `dt_tier_change_log`
  - `dt_gross_revenue_active_products`
  - `staging_raw_tiktok_openescrow`
  - `yt_assets_project_space/yt_conflict_report_final`
  - `periscope_migration/content_integrity_team_analytics/cr_team_members`
  - `yt_assets_project_space/dim_track`
  - `yt_assets_project_space/dim_release`
  - `yt_assets_project_space/dim_artist`
  - `yt_assets_project_space/dim_label`
  - `yt_assets_project_space/dim_subaccount`
  - `int_dbt_prod_awal_tier_groups`
  - `yt_assets_project_space/ows_conflict_manager_prod_action`

#### youtube_asset_conflict
- **Includes:** 9 views
- **Views:**
  - `facts_prod_staging_raw_youtube_asset_conflict.view`
  - `orch_app_ar_track`
  - `orch_app_ar_releases`
  - `orch_app_ar_artist_info`
  - `orch_app_ar_vendor`
  - `orch_app_ar_subaccount`
  - `facts_prod_dim_label.view`
  - `facts_prod_fact_conflict.view`
  - `int_dbt_prod_awal_tier_groups`

#### youtube_assets
- **Includes:** 14 views
- **Views:**
  - `yt_assets_project_space/facts_prod_registry`
  - `yt_assets_project_space/facts_prod_staging_raw_youtube_asset_report`
  - `yt_assets_project_space/facts_prod_staging_raw_youtube_claim`
  - `yt_assets_project_space/yt_assets_conflict_new`
  - `yt_assets_project_space/yt_conflict_report_final`
  - `yt_assets_project_space/ows_conflict_manager_prod_action`
  - `yt_assets_project_space/dim_track`
  - `yt_assets_project_space/dim_release`
  - `yt_assets_project_space/dim_artist`
  - `yt_assets_project_space/dim_label`
  - `yt_assets_project_space/dim_subaccount`
  - `orch_app_ar_track`
  - `yt_assets_project_space/dt_isrc_registry`
  - `int_dbt_prod_awal_tier_groups`

#### youtube_audit_tool
- **Includes:** 11 views
- **Views:**
  - `youtube_audit_tool/AUDITS`
  - `youtube_audit_tool/AUDITS_FLAGS`
  - `youtube_audit_tool/AUDITS_GROUPS`
  - `youtube_audit_tool/AUDITS_LOG`
  - `youtube_audit_tool/AUDITS_META`
  - `youtube_audit_tool/AUDITS_ROWS`
  - `youtube_audit_tool/AUDITS_ROWS_ROWTYPES`
  - `youtube_audit_tool/AUDITS_ROWTYPES`
  - `youtube_audit_tool/USERS`
  - `youtube_audit_tool/yt_avod_revenue_views`
  - `youtube_audit_tool/yt_svod_revenue_views`

#### youtube_fact_asset_analytics
- **Includes:** 19 views
- **Views:**
  - `facts_prod_fact_youtube_asset_analytics`
  - `facts_prod_dim_country`
  - `facts_prod_dim_genre`
  - `facts_prod_dim_store`
  - `facts_prod_dim_feed`
  - `facts_prod_dim_track`
  - `orch_app_ar_track`
  - `orch_app_ar_releases`
  - `dt_track_artist_by_type`
  - `facts_prod_dim_artist`
  - `facts_prod_dim_label`
  - `facts_prod_dim_imprint`
  - `facts_prod_dim_catalog`
  - `int_dev_skeels_youtube_channel_mappings`
  - `facts_prod_dim_licensor`
  - `int_dbt_prod_awal_tier_groups`
  - `orch_app_ar_vendor`
  - `orch_app_ar_orchadmin_users`
  - `orch_app_ar_subaccount`

#### youtube_fact_asset_demographics
- **Includes:** 9 views
- **Views:**
  - `facts_prod_fact_youtube_asset_demographics`
  - `facts_prod_dim_trafficsource`
  - `facts_prod_dim_os`
  - `facts_prod_dim_playback`
  - `facts_prod_dim_device`
  - `facts_prod_dim_country`
  - `facts_prod_dim_store`
  - `facts_prod_dim_feed`
  - `int_dev_skeels_youtube_channel_mappings`

#### youtube_fact_video_analytics
- **Includes:** 15 views
- **Views:**
  - `facts_prod_fact_youtube_video_analytics`
  - `facts_prod_dim_country`
  - `facts_prod_dim_store`
  - `facts_prod_dim_feed`
  - `dt_youtube_video_titles_mapping`
  - `facts_prod_staging_raw_youtube_video_report`
  - `facts_prod_staging_raw_youtube_video_report`
  - `orch_app_ar_youtube_channel`
  - `facts_prod_staging_raw_youtube_asset_report`
  - `facts_prod_staging_raw_youtube_claim`
  - `orch_app_ar_vendor`
  - `orch_app_ar_orchadmin_users`
  - `int_dbt_prod_awal_tier_groups`
  - `orch_app_ar_releases`
  - `orch_app_ar_subaccount`

#### youtube_fact_video_demographics
- **Includes:** 9 views
- **Views:**
  - `facts_prod_fact_youtube_video_demographics`
  - `facts_prod_dim_trafficsource`
  - `facts_prod_dim_os`
  - `facts_prod_dim_playback`
  - `facts_prod_dim_device`
  - `facts_prod_dim_country`
  - `facts_prod_dim_store`
  - `facts_prod_dim_feed`
  - `int_dev_skeels_youtube_channel_mappings`

#### youtube_insights_dashboard
- **Includes:** 3 views
- **Views:**
  - `youtube_insights_genre_analytics_pt2`
  - `/**/*`
  - `my_dashboard.dashboard.lookml`

#### youtube_insights_dashboard_full
- **Includes:** 3 views
- **Views:**
  - `youtube_insights_genre_analytics_pt2_v2`
  - `/**/*`
  - `my_dashboard.dashboard.lookml`

#### youtube_monthly_financial_reports
- **Includes:** 15 views
- **Views:**
  - `facts_prod_youtube_monthly_ad_enabled`
  - `orch_app_ar_track`
  - `orch_app_ar_releases`
  - `orch_app_ar_artist_info`
  - `orch_app_ar_vendor`
  - `orch_app_ar_subaccount`
  - `facts_prod_dim_country`
  - `facts_prod_dim_youtube_channel_names`
  - `int_dbt_prod_youtube_subscription`
  - `int_dbt_prod_youtube_monthly_ads_adjustment`
  - `int_dbt_prod_awal_tier_groups`
  - `int_dbt_prod_youtube_ads_adjustment_legacy`
  - `int_dbt_prod_youtube_subscription_adjustment`
  - `facts_prod_dim_release`
  - `facts_prod_staging_raw_youtube_asset_report`

#### youtube_multi_asset_isrc_videos
- **Includes:** 4 views
- **Views:**
  - `facts_prod_staging_raw_youtube_monthly_claim`
  - `dt_youtube_multi_asset_isrc_join`
  - `orch_app_ar_releases`
  - `orch_app_ar_track`

#### youtube_reports
- **Includes:** 25 views
- **Views:**
  - `facts_prod_staging_raw_youtube_asset_report`
  - `int_dev_jlafyatis_youtube_asset_mapping`
  - `orch_app_ar_track`
  - `orch_app_ar_releases`
  - `orch_app_ar_artist_info`
  - `orch_app_ar_vendor`
  - `facts_prod_registry`
  - `orch_app_ar_genre`
  - `int_dbt_prod_awal_tier_groups`
  - `facts_prod_staging_raw_youtube_claim`
  - `orch_app_ar_subaccount`
  - `orch_app_ar_orchadmin_users`
  - `facts_prod_fact_conflict`
  - `dt_registry`
  - `facts_prod_staging_raw_youtube_video_report`
  - `facts_prod_dim_track`
  - `facts_prod_dim_release`
  - `orch_app_ar_youtube_channel`
  - `facts_prod_dim_artist`
  - `facts_prod_dim_label`
  - `facts_prod_dim_country`
  - `facts_prod_dim_subaccount`
  - `orch_app_ar_youtube_channel_video_status`
  - `int_dbt_prod_youtube_shorts`
  - `facts_prod_dim_device`

#### youtube_shorts_v2
- **Includes:** 4 views
- **Views:**
  - `yt_claim_facts_prod_staging_raw_youtube_claim`
  - `int_dbt_prod_youtube_shorts`
  - `/**/*`
  - `my_dashboard.dashboard.lookml`

#### youtube_useractivity_intermediate
- **Includes:** 3 views
- **Views:**
  - `prod_yt_reports_api_useractivity_intermediate`
  - `/**/*`
  - `my_dashboard.dashboard.lookml`

## View Dependencies

### Views by Data Source

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

**"DBT_NHOMCHOWDHURY"."YOUTUBE_INSIGHTS_GENRE_ANALYTICS_PT2"**
- Used by 1 views: `youtube_insights_genre_analytics_pt2`


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


**DBT_PROD.DT_ISRC_REGISTRY**
- Used by 1 views: `dt_isrc_registry`


**DBT_PROD.DT_REGISTRY**
- Used by 1 views: `dt_registry`


**DBT_PROD.DT_TRACK_ARTIST_BY_TYPE**
- Used by 1 views: `dt_track_artist_by_type`


**DBT_PROD.YOUTUBE_ADS_ADJUSTMENT_LEGACY**
- Used by 1 views: `int_dbt_prod_youtube_ads_adjustment_legacy`


**DBT_PROD.YOUTUBE_ADS_ADJUSTMENT_V2_MRR_UPDATE**
- Used by 1 views: `int_dbt_prod_youtube_monthly_ads_adjustment`


**DBT_PROD.YOUTUBE_AD_SUPPORTED_MRR_UPDATE**
- Used by 2 views: `facts_prod_youtube_monthly_ad_enabled`, `yt_avod_revenue_views`


**DBT_PROD.YOUTUBE_INSIGHTS_GENRE_ANALYTICS_PT2_V2**
- Used by 1 views: `youtube_insights_genre_analytics_pt2_v2`


**DBT_PROD.YOUTUBE_SHORTS**
- Used by 1 views: `int_dbt_prod_youtube_shorts`


**DBT_PROD.YOUTUBE_SUBSCRIPTIONS**
- Used by 1 views: `facts_prod_youtube_monthly_subscriptions`


**DBT_PROD.YOUTUBE_SUBSCRIPTION_ADJUSTMENT_MRR_UPDATE**
- Used by 1 views: `int_dbt_prod_youtube_subscription_adjustment`


**DBT_PROD.YOUTUBE_SUBSCRIPTION_MRR_UPDATE**
- Used by 2 views: `int_dbt_prod_youtube_subscription`, `yt_svod_revenue_views`


**QA_YOUTUBE_AUDIT_YOUTUBE_AUDIT.AUDITS**
- Used by 1 views: `AUDITS`


**QA_YOUTUBE_AUDIT_YOUTUBE_AUDIT.AUDITS_FLAGS**
- Used by 1 views: `AUDITS_FLAGS`


**QA_YOUTUBE_AUDIT_YOUTUBE_AUDIT.AUDITS_GROUPS**
- Used by 1 views: `AUDITS_GROUPS`


**QA_YOUTUBE_AUDIT_YOUTUBE_AUDIT.AUDITS_LOG**
- Used by 1 views: `AUDITS_LOG`


**QA_YOUTUBE_AUDIT_YOUTUBE_AUDIT.AUDITS_META**
- Used by 1 views: `AUDITS_META`


**QA_YOUTUBE_AUDIT_YOUTUBE_AUDIT.AUDITS_ROWS**
- Used by 1 views: `AUDITS_ROWS`


**QA_YOUTUBE_AUDIT_YOUTUBE_AUDIT.AUDITS_ROWS_ROWTYPES**
- Used by 1 views: `AUDITS_ROWS_ROWTYPES`


**QA_YOUTUBE_AUDIT_YOUTUBE_AUDIT.AUDITS_ROWTYPES**
- Used by 1 views: `AUDITS_ROWTYPES`


**QA_YOUTUBE_AUDIT_YOUTUBE_AUDIT.USERS**
- Used by 1 views: `USERS`


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


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


**art_relations_prod_art_relations.orchadmin_users**
- Used by 1 views: `orch_app_ar_orchadmin_users`


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


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


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


**art_relations_prod_art_relations.youtube_channel_video_status**
- Used by 1 views: `orch_app_ar_youtube_channel_video_status`


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


**dev_jlafyatis.youtube_asset_mapping**
- Used by 1 views: `int_dev_jlafyatis_youtube_asset_mapping`


**dev_skeels.yt_channel_mapping**
- Used by 1 views: `int_dev_skeels_youtube_channel_mappings`


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


**prod.DIM_LABEL**
- Used by 2 views: `facts_prod_dim_label`, `dim_label`


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


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


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


**prod.REGISTRY**
- Used by 1 views: `facts_prod_registry`


**prod.STAGING_RAW_YOUTUBE_CLAIM**
- Used by 2 views: `yt_claim_facts_prod_staging_raw_youtube_claim`, `facts_prod_staging_raw_youtube_claim`


**prod.action**
- Used by 1 views: `ows_conflict_manager_prod_action`


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


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


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


**prod.dim_device**
- Used by 1 views: `facts_prod_dim_device`


**prod.dim_feed**
- Used by 1 views: `facts_prod_dim_feed`


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


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


**prod.dim_licensor**
- Used by 1 views: `facts_prod_dim_licensor`


**prod.dim_os**
- Used by 1 views: `facts_prod_dim_os`


**prod.dim_playback**
- Used by 1 views: `facts_prod_dim_playback`


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


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


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


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


**prod.dim_trafficsource**
- Used by 1 views: `facts_prod_dim_trafficsource`


**prod.dim_youtube_channel_names**
- Used by 1 views: `facts_prod_dim_youtube_channel_names`


**prod.fact_conflict**
- Used by 2 views: `facts_prod_fact_conflict`, `yt_conflict_report_final`


**prod.fact_youtube_asset_analytics**
- Used by 1 views: `facts_prod_fact_youtube_asset_analytics`


**prod.fact_youtube_asset_demographics**
- Used by 1 views: `facts_prod_fact_youtube_asset_demographics`


**prod.fact_youtube_video_analytics**
- Used by 1 views: `facts_prod_fact_youtube_video_analytics`


**prod.fact_youtube_video_demographics**
- Used by 1 views: `facts_prod_fact_youtube_video_demographics`


**prod.staging_raw_youtube_asset_conflict**
- Used by 2 views: `facts_prod_staging_raw_youtube_asset_conflict`, `yt_assets_conflict_new`


**prod.staging_raw_youtube_asset_report**
- Used by 1 views: `facts_prod_staging_raw_youtube_asset_report`


**prod.staging_raw_youtube_monthly_claim_raw_v1_1**
- Used by 1 views: `facts_prod_staging_raw_youtube_monthly_claim`


**prod.staging_raw_youtube_video_report**
- Used by 1 views: `facts_prod_staging_raw_youtube_video_report`


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


**tiktok.staging_raw_tiktok_openescrow**
- Used by 1 views: `staging_raw_tiktok_openescrow`


**yt_reports_api.useractivity_intermediate**
- Used by 1 views: `prod_yt_reports_api_useractivity_intermediate`


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

Total: 50 views

| View | Lines of Code | Source Tables |
|------|---------------|---------------|
| `content_review_sla` | 1232 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `cr_team_members` | 881 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `completion_reasons_separated` | 779 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `review_volume` | 775 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `validation_codes` | 772 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `team_volume_speed` | 719 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `dt_account_termination` | 579 |  Art_Relations_Prod_Art_Relations.Project, Art_... |
| `dt_incomplete_reviews` | 337 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `dt_Third_Party_Publishing_Claims` | 303 |  Art_Relations_Prod_Art_Relations.Youtube_Chann... |
| `dt_youtube_dashboard` | 279 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `review_approval_history` | 276 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `no_tiktok_carveout_no_monetization` | 269 |  Art_Relations_Prod_Art_Relations.Orchadmin_Use... |
| `territory_carveout_missing_monetization` | 266 |  Art_Relations_Prod_Art_Relations.Orchadmin_Use... |
| `approvals` | 262 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `potential_audio_infringement_audit_history` | 251 |  Art_Relations_Prod_Art_Relations.Orchadmin_Use... |
| `tiktok_carveout_monetization` | 250 |  Art_Relations_Prod_Art_Relations.Orchadmin_Use... |
| `review_session_history` | 242 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `validation_history` | 209 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |
| `assigned_reviewer_change_log` | 206 |  Art_Relations_Prod_Art_Relations_Log.Vendor_Lo... |
| `review_history` | 199 |  Art_Relations_Prod_Art_Relations.Artist_Info, ... |

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


## Explore Relationships

### Explores and Their Dependencies

#### Model: periscope_migration

**potential_audio_infringement_audit_history** (Content - Potential Audio Infringement Audit History)
- Base View: `potential_audio_infringement_audit_history`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Orchadmin_Users, Cr_Completed_Ign...

**review_history** (Review History)
- Base View: `review_history`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**approvals** (Review Product History - Approvals)
- Base View: `approvals`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**rejections** (Review Product History - Rejections)
- Base View: `rejections`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**queue_move_history_escalations** (Queue Move History - Escalations)
- Base View: `queue_move_history_escalations`
- View Type: Derived Table
- Data Source: Derived from: Cr_Completed_Reviews_With_Vendor_Data

**queue_move_history** (Queue Move History)
- Base View: `queue_move_history`
- View Type: Derived Table
- Data Source: Derived from: Cr_Completed_Reviews_With_Vendor_Data

**validation_history** (Validation History)
- Base View: `validation_history`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**review_approval_history** (Review Approval History)
- Base View: `review_approval_history`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**assigned_reviewer_change_log** (Assigned Reviewer Change Log)
- Base View: `assigned_reviewer_change_log`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations_Log.Vendor_Log, Orchard_App_Repor...

**content_review_sla** (Content Review Analytics)
- Base View: `content_review_sla`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**content_deliveries** (Content Deliveries)
- Base View: `content_deliveries`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Delivery_History, Art_Relations_P...

**team_volume_speed** (Team Volume & Speed)
- Base View: `team_volume_speed`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**review_session_history** (Review Session History)
- Base View: `review_session_history`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**review_volume** (Review Volume)
- Base View: `review_volume`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**validation_codes** (Validation Codes)
- Base View: `validation_codes`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**completion_reasons_separated** (Completion Reasons Separated)
- Base View: `completion_reasons_separated`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

#### Model: rights_mgmt_content_int

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

**dt_avod_svod_join** (AVOD/SVOD)
- Base View: `dt_avod_svod_join`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ad_Supported_Mrr_Updat...

**dt_yt_conflicts** (YouTube Conflicts)
- Base View: `dt_yt_conflicts`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ads_Adjustment_Legacy,...

**dt_isrc_assignment_history** (ISRC Assignment History)
- Base View: `dt_isrc_assignment_history`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Isrcs, Orchard_App_Reporting_V2, ...

**dt_account_termination** (Account Termination)
- Base View: `dt_account_termination`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Project, Art_Relations_Prod_Art_R...

**month_year** (Month/Year)
- Base View: `month_year`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Youtube_Ad_Supported_Mrr_Update, Intelligence.Dbt_Prod

**total_revenue_views** (Total Revenue/Views)
- Base View: `total_revenue_views`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ad_Supported_Mrr_Updat...

**avod_revenue_views** (AVOD Revenue/Views)
- Base View: `avod_revenue_views`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ad_Supported_Mrr_Updat...

**svod_revenue_views** (SVOD Revenue/Views)
- Base View: `svod_revenue_views`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Subscription_Mrr_Updat...

**ugc_revenue_views** (UGC Revenue/Views)
- Base View: `ugc_revenue_views`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ad_Supported_Mrr_Updat...

**premium_revenue_views** (Premium Revenue/Views)
- Base View: `premium_revenue_views`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ad_Supported_Mrr_Updat...

**art_tracks_revenue_views** (Art Tracks Revenue/Views)
- Base View: `art_tracks_revenue_views`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ad_Supported_Mrr_Updat...

**cpm** (CPM)
- Base View: `cpm`
- View Type: Derived Table
- Data Source: Derived from: Latest_Month, Prod.Fact_Youtube_Video_Analytics

**cpm_fill_rate** (CPM Fill Rate)
- Base View: `cpm_fill_rate`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Youtube_Channel, Dbt_Prod.Awal_Ti...

**revenue_pie_chart** (Revenue Pie Chart)
- Base View: `revenue_pie_chart`
- View Type: Derived Table
- Data Source: Derived from: Art_Tracks, Dbt_Prod.Youtube_Ad_Supported_Mrr_Update, Dbt_Prod.You...

**rpm_timeline** (RPM Timeline)
- Base View: `rpm_timeline`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ad_Supported_Mrr_Updat...

**views_pie_chart** (Views Pie Chart)
- Base View: `views_pie_chart`
- View Type: Derived Table
- Data Source: Derived from: Art_Tracks, Dbt_Prod.Youtube_Ad_Supported_Mrr_Update, Dbt_Prod.You...

**dt_apple_lyrics_breakdown** (Apple Lyrics Breakdown)
- Base View: `dt_apple_lyrics_breakdown`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**content_type_combined** (Content Type Combined)
- Base View: `content_type_combined`
- View Type: Derived Table
- Data Source: Derived from: Art_Tracks, Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ad_Support...

**top_ten_countries** (Top Ten Countries)
- Base View: `top_ten_countries`
- View Type: Derived Table
- Data Source: Derived from: Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ad_Supported_Mrr_Updat...

**dt_incomplete_reviews** (Incomplete Reviews)
- Base View: `dt_incomplete_reviews`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**fiscal_yr_comparison** (Fiscal Year Comparison)
- Base View: `fiscal_yr_comparison`
- View Type: Derived Table
- Data Source: Derived from: Current_Date, Dbt_Prod.Awal_Tier_Groups, Dbt_Prod.Youtube_Ad_Suppo...

**dt_registry_territory_match** (Registry Territory Match)
- Base View: `dt_registry_territory_match`
- View Type: Derived Table
- Data Source: Derived from: Asset_Report, Prod.Staging_Raw_Youtube_Asset_Report, Status_Calc

**tiktok_carveout_monetization** (TikTok Carveout with Monetization)
- Base View: `tiktok_carveout_monetization`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Orchadmin_Users, Art_Relations_Pr...

**no_tiktok_carveout_no_monetization** (No TikTok Carveout with Missing Monetization)
- Base View: `no_tiktok_carveout_no_monetization`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Orchadmin_Users, Art_Relations_Pr...

**territory_carveout_missing_monetization** (Territory Carveout with No Matching Monetization)
- Base View: `territory_carveout_missing_monetization`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Orchadmin_Users, Art_Relations_Pr...

**dt_third_party_publishing_claims** (Third Party Publishing Claims)
- Base View: `dt_third_party_publishing_claims`
- View Type: Direct Table
- Data Source: Unknown

**dt_tier_change_log** (Tier Change Log)
- Base View: `dt_tier_change_log`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Orchadmin_Users, Art_Relations_Pr...

**dt_gross_revenue_active_products** (Label Gross Revenue vs. Active Products)
- Base View: `dt_gross_revenue_active_products`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

**staging_raw_tiktok_openescrow** (SR Registry)
- Base View: `staging_raw_tiktok_openescrow`
- View Type: Direct Table
- Data Source: conflict_reporting.tiktok.staging_raw_tiktok_openescrow

**cr_team_members** (CR Team Members)
- Base View: `cr_team_members`
- View Type: Derived Table
- Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A...

#### Model: youtube_asset_conflict

**facts_prod_staging_raw_youtube_asset_conflict** (YouTube Asset Conflict)
- Base View: `facts_prod_staging_raw_youtube_asset_conflict`
- View Type: Direct Table
- Data Source: facts.prod.staging_raw_youtube_asset_conflict

#### Model: youtube_assets

**yt_registry_report_simple** (Master Rights Registry (No Joins))
- Base View: `yt_registry_report_simple`
- View Type: Direct Table
- Data Source: Unknown

**yt_registry_report** (YouTube Registry Report with Fact Sales Metadata)
- Base View: `yt_registry_report`
- View Type: Direct Table
- Data Source: Unknown

**yt_asset_report_simple** (YouTube Asset Report (No Joins))
- Base View: `yt_asset_report_simple`
- View Type: Direct Table
- Data Source: Unknown

**yt_asset_report** (YouTube Asset Report with Fact Sales Metadata)
- Base View: `yt_asset_report`
- View Type: Direct Table
- Data Source: Unknown

**yt_registry_asset_report** (YouTube Registry Report with YouTube Asset Report and Fact Sales Metadata)
- Base View: `yt_registry_asset_report`
- View Type: Direct Table
- Data Source: Unknown

**yt_registry_asset_report_sound_recording_only** (YouTube Registry Report with YouTube Asset Report and Fact Sales Metadata (Sound Recordings only))
- Base View: `yt_registry_asset_report_sound_recording_only`
- View Type: Direct Table
- Data Source: Unknown

**yt_claim_report** (YouTube Claim Report with Fact Sales Metadata)
- Base View: `yt_claim_report`
- View Type: Direct Table
- Data Source: Unknown

**yt_conflict_report** (Master Rights Conflict Report with Fact Sales Metadata)
- Base View: `yt_conflict_report`
- View Type: Direct Table
- Data Source: Unknown

#### Model: youtube_audit_tool

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

#### Model: youtube_fact_asset_analytics

**facts_prod_fact_youtube_asset_analytics** (Assets)
- Base View: `facts_prod_fact_youtube_asset_analytics`
- View Type: Direct Table
- Data Source: facts.prod.fact_youtube_asset_analytics

#### Model: youtube_fact_asset_demographics

**facts_prod_fact_youtube_asset_demographics** (Assets)
- Base View: `facts_prod_fact_youtube_asset_demographics`
- View Type: Direct Table
- Data Source: facts.prod.fact_youtube_asset_demographics

#### Model: youtube_fact_video_analytics

**facts_prod_fact_youtube_video_analytics** (Videos)
- Base View: `facts_prod_fact_youtube_video_analytics`
- View Type: Direct Table
- Data Source: facts.prod.fact_youtube_video_analytics

#### Model: youtube_fact_video_demographics

**facts_prod_fact_youtube_video_demographics** (Video)
- Base View: `facts_prod_fact_youtube_video_demographics`
- View Type: Direct Table
- Data Source: facts.prod.fact_youtube_video_demographics

#### Model: youtube_insights_dashboard

**youtube_insights_genre_analytics_pt2** (YouTube Insights High-Level)
- Base View: `youtube_insights_genre_analytics_pt2`
- View Type: Direct Table
- Data Source: "DBT_NHOMCHOWDHURY"."YOUTUBE_INSIGHTS_GENRE_ANALYTICS_PT2"

#### Model: youtube_insights_dashboard_full

**youtube_insights_genre_analytics_pt2_v2** (YouTube Insights High-Level)
- Base View: `youtube_insights_genre_analytics_pt2_v2`
- View Type: Direct Table
- Data Source: INTELLIGENCE.DBT_PROD.YOUTUBE_INSIGHTS_GENRE_ANALYTICS_PT2_V2

#### Model: youtube_monthly_financial_reports

**facts_prod_youtube_monthly_ad_enabled** (Metadata)
- Base View: `facts_prod_youtube_monthly_ad_enabled`
- View Type: Direct Table
- Data Source: INTELLIGENCE.DBT_PROD.YOUTUBE_AD_SUPPORTED_MRR_UPDATE

**int_dbt_prod_youtube_subscription** (Metadata)
- Base View: `int_dbt_prod_youtube_subscription`
- View Type: Direct Table
- Data Source: INTELLIGENCE.DBT_PROD.YOUTUBE_SUBSCRIPTION_MRR_UPDATE

**int_dbt_prod_youtube_monthly_ads_adjustment** (Track)
- Base View: `int_dbt_prod_youtube_monthly_ads_adjustment`
- View Type: Direct Table
- Data Source: INTELLIGENCE.DBT_PROD.YOUTUBE_ADS_ADJUSTMENT_V2_MRR_UPDATE

**int_dbt_prod_youtube_ads_adjustment_legacy** (Track)
- Base View: `int_dbt_prod_youtube_ads_adjustment_legacy`
- View Type: Direct Table
- Data Source: INTELLIGENCE.DBT_PROD.YOUTUBE_ADS_ADJUSTMENT_LEGACY

**int_dbt_prod_youtube_subscription_adjustment** (Metadata)
- Base View: `int_dbt_prod_youtube_subscription_adjustment`
- View Type: Direct Table
- Data Source: INTELLIGENCE.DBT_PROD.YOUTUBE_SUBSCRIPTION_ADJUSTMENT_MRR_UPDATE

#### Model: youtube_multi_asset_isrc_videos

**facts_prod_staging_raw_youtube_monthly_claim** (Metadata)
- Base View: `facts_prod_staging_raw_youtube_monthly_claim`
- View Type: Direct Table
- Data Source: facts.prod.staging_raw_youtube_monthly_claim_raw_v1_1

**dt_youtube_multi_asset_isrc_join** (Release)
- Base View: `dt_youtube_multi_asset_isrc_join`
- View Type: Derived Table
- Data Source: Derived from: Prod.Staging_Raw_Youtube_Monthly_Claim_Raw_V1_1

#### Model: youtube_reports

**facts_prod_staging_raw_youtube_asset_report** (YouTube Asset Report)
- Base View: `facts_prod_staging_raw_youtube_asset_report`
- View Type: Direct Table
- Data Source: facts.prod.staging_raw_youtube_asset_report

**facts_prod_staging_raw_youtube_claim** (Claim Report)
- Base View: `facts_prod_staging_raw_youtube_claim`
- View Type: Direct Table
- Data Source: facts.prod.STAGING_RAW_YOUTUBE_CLAIM

**facts_prod_fact_conflict** (YouTube Conflict Report)
- Base View: `facts_prod_fact_conflict`
- View Type: Direct Table
- Data Source: facts.prod.fact_conflict

**facts_prod_staging_raw_youtube_video_report** (Video Report)
- Base View: `facts_prod_staging_raw_youtube_video_report`
- View Type: Direct Table
- Data Source: facts.prod.staging_raw_youtube_video_report

**int_dbt_prod_youtube_shorts** (YouTube Shorts)
- Base View: `int_dbt_prod_youtube_shorts`
- View Type: Direct Table
- Data Source: INTELLIGENCE.DBT_PROD.YOUTUBE_SHORTS

#### Model: youtube_shorts_v2

**yt_claim_facts_prod_staging_raw_youtube_claim** (YouTube Shorts v2)
- Base View: `yt_claim_facts_prod_staging_raw_youtube_claim`
- View Type: Direct Table
- Data Source: facts.prod.STAGING_RAW_YOUTUBE_CLAIM

#### Model: youtube_useractivity_intermediate

**prod_yt_reports_api_useractivity_intermediate** (User Activity Intermediate)
- Base View: `prod_yt_reports_api_useractivity_intermediate`
- View Type: Direct Table
- Data Source: prod.yt_reports_api.useractivity_intermediate

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