# Data Lineage & Dependencies Generated on: 2026-04-15 09:16:02 This document shows the relationships and dependencies between models, views, and data sources. ## Overview - **Total Models:** 17 - **Total Views:** 67 - **Derived Views:** 15 - **Direct Table Views:** 52 ## Model Dependencies ### Models and Their Views #### Awal_Opportunities - **Includes:** 4 views - **Views:** - `awal_sax_salesforce_opportunities` - `awal_sax_salesforce_account` - `/**/*` - `my_dashboard.dashboard.lookml` #### Lauv_catalogue_report - **Includes:** 1 views - **Views:** - `/DOSC/Detailed_catalogue_reportLauv_catalogue_report` #### applications_data - **Includes:** 7 views - **Views:** - `/DOSC/Community_Support/applications_datasony_applications_data` - `/DOSC/Community_Support/applications_datasony_applications_data_leads` - `/DOSC/Community_Support/applications_datasony_applications_data_approval` - `/DOSC/Community_Support/applications_datasony_applications_data_unqualified` - `/DOSC/Community_Support/applications_datasony_applications_data_submit` - `/DOSC/Community_Support/applications_datasony_applications_data_signup` - `/DOSC/Community_Support/applications_datasax_applications_data` #### awal_historical_data_sets - **Includes:** 1 views - **Views:** - `/*` #### awal_orchard_client_id - **Includes:** 1 views - **Views:** - `awal_sax_sax_delservers_orchard_clidnt_ids` #### awal_recordings_recoup_rev_fpadb - **Includes:** 1 views - **Views:** - `/*` #### awal_salesforce - **Includes:** 1 views - **Views:** - `awal_salesforce_opportunities` #### awal_summary_streams_separation - **Includes:** 12 views - **Views:** - `/DOSC/Financial_Team/awal_summary_streams_separationawal_int_dbt_prod_summary_streams` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_playlist` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_label` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_country` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_release` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_track` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_artist` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_orch_app_ar_releases` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_orch_app_ar_country` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_orch_app_ar_genre` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_metadata_simplified` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_int_dbt_prod_awal_tier_groups` #### awal_summary_streams_separation_mondayweek - **Includes:** 12 views - **Views:** - `/DOSC/Financial_Team/awal_summary_streams_separationawal_int_dbt_prod_summary_streams` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_playlist` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_label` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_country` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_release` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_track` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_facts_prod_dim_artist` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_orch_app_ar_releases` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_orch_app_ar_country` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_orch_app_ar_genre` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_metadata_simplified` - `/DOSC/Financial_Team/awal_summary_streams_separationawal_int_dbt_prod_awal_tier_groups` #### awal_workstation_gcp_priorities - **Includes:** 1 views - **Views:** - `*` #### bi_riaa_certification - **Includes:** 1 views - **Views:** - `/DOSC/BI/riaa_certificationbi_riaa_certification` #### bi_riaa_certification_summary - **Includes:** 1 views - **Views:** - `/DOSC/BI/riaa_certificationbi_riaa_certification` #### detailed_catalogue_report - **Includes:** 1 views - **Views:** - `/DOSC/Detailed_catalogue_reportdetailed_catalogue_report` #### gda - **Includes:** 1 views - **Views:** - `/*` #### statements - **Includes:** 1 views - **Views:** - `/DOSC/Client_Admin/statementsstatements` #### streaming_data_details - **Includes:** 1 views - **Views:** - `/DOSC/Financial_Team/streaming_data_detailsstreaming_data_details` #### upc_remap - **Includes:** 1 views - **Views:** - `/DOSC/upc_remapupc_remap` ## View Dependencies ### Views by Data Source #### Direct Database Tables Views that directly reference database tables: **AWAL.OPPORTUNITY** - Used by 1 views: `awal_salesforce_opportunities` **AWAL_FINANCE.AWAL_ALL_POS** - Used by 1 views: `int_dbt_prod_awal_all_pos_model` **AWAL_FINANCE.AWAL_APPLICATIONS** - Used by 1 views: `int_dbt_prod_awal_applications_model` **AWAL_FINANCE.AWAL_BASIC_TAKEDOWNS** - Used by 1 views: `int_dbt_prod_awal_basic_takedowns_model` **AWAL_FINANCE.AWAL_GROUP_AGR_NR** - Used by 1 views: `int_dbt_prod_awal_agr_nr_model` **AWAL_FINANCE.AWAL_GROUP_AGR_RECORDINGS** - Used by 1 views: `int_dbt_prod_awal_groups_agr_recordings_model` **AWAL_FINANCE.AWAL_INVOICE_PMTS** - Used by 1 views: `int_awal_historical_datasets_temp_awal_invoice_pmts` **AWAL_FINANCE.AWAL_INVOICE_PMTS_REVISED** - Used by 1 views: `int_awal_historical_datasets_temp_awal_invoice_pmts_revised` **AWAL_FINANCE.AWAL_ITUNES_DOWNLOADS** - Used by 1 views: `int_awal_historical_datasets_temp_awal_itunes_downloads` **AWAL_FINANCE.AWAL_NEW_CLIENT_LIST** - Used by 1 views: `int_dbt_prod_awal_new_client_list_model` **AWAL_FINANCE.AWAL_NUM_ACTIVE_ARTISTS** - Used by 1 views: `int_dbt_prod_awal_num_active_artists_model` **AWAL_FINANCE.AWAL_OUTSTANDING_INVOICES_DASHBOARD** - Used by 1 views: `int_awal_historical_datasets_temp_awal_outstanding_invoices_dashboard` **AWAL_FINANCE.AWAL_PAID_AND_FUTURE_ADVANCES** - Used by 1 views: `int_dbt_prod_awal_paid_and_future_advances_model` **AWAL_FINANCE.AWAL_ROYALTIES_DASHBOARD** - Used by 1 views: `awal_awal_finance_awal_royalties_dashboard` **AWAL_FINANCE.AWAL_STREAMING_DATA** - Used by 1 views: `int_awal_historical_datasets_temp_awal_streaming_data` **AWAL_FINANCE.AWAL_STREAMING_DATA_EX_PLATFORM** - Used by 1 views: `int_awal_historical_datasets_temp_awal_streaming_data_ex_platform` **AWAL_FINANCE.AWAL_STREAMING_DATA_INC_PLATFORM** - Used by 1 views: `int_awal_historical_datasets_temp_awal_streaming_data_inc_platform` **AWAL_FINANCE.AWAL_STREAMING_DATA_TERRITORY** - Used by 1 views: `int_awal_historical_datasets_temp_awal_streaming_data_territory` **AWAL_FINANCE.AWAL_STREAMS_PER_RELEASE_SEGMENTS** - Used by 1 views: `int_awal_historical_datasets_temp_awal_streams_per_release_segments` **AWAL_FINANCE.AWAL_TOTAL_STREAMS_SEGMENTS** - Used by 1 views: `int_awal_historical_datasets_temp_awal_total_streams_segments` **AWAL_FINANCE.AWAL_TOTAL_STREAMS_SEGMENTS_YTTEST** - Used by 1 views: `int_awal_historical_datasets_temp_total_stream_segment_yttest` **AWAL_FINANCE.AWAL_WEEKLY_SPOTIFY_PLAYLIST_ADDS** - Used by 1 views: `int_awal_historical_datasets_temp_awal_weekly_spotify_playlist_adds` **AWAL_FINANCE.FPA_PR_AWAL** - Used by 1 views: `awal_awal_finance_fpa_pr_revenue` **AWAL_FINANCE.FPA_PR_NEIGHBOURINGRIGHTS** - Used by 1 views: `awal_awal_finance_fpa_pr_neighboringrights` **AWAL_FINANCE.FPA_RECOUP_REV_AWAL** - Used by 1 views: `int_awal_historical_datasets_temp_fpa_recoup_rev_awal` **AWAL_FINANCE.GROUP_ALL_BU_RECOUPMENT** - Used by 1 views: `int_awal_historical_datasets_temp_group_all_bu_recoupment` **AWAL_FINANCE.NUM_NEW_RELEASES** - Used by 1 views: `int_awal_historical_datasets_temp_awal_num_new_releases` **AWAL_FINANCE.RD_AWAL_USAGE** - Used by 1 views: `int_awal_historical_datasets_temp_rd_awal_usage` **AWAL_FINANCE.RD_AWAL_USAGE_LIVE** - Used by 1 views: `int_awal_historical_datasets_temp_rd_awal_usage_live` **AWAL_FINANCE.RPD_AWAL_USAGE_CLIENT_EX_PLATFORM** - Used by 1 views: `int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform` **AWAL_FINANCE.RPD_AWAL_USAGE_CLIENT_EX_PLATFORM_B2B_ALD** - Used by 1 views: `int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform_b2b_ald` **AWAL_FINANCE.RPD_AWAL_USAGE_CLIENT_EX_PLATFORM_DSP_REVENUE** - Used by 1 views: `int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform_dsp_revenue` **AWAL_FINANCE.RPD_NR_USAGE_EXTRACT** - Used by 1 views: `awal_awal_finance_rpd_nr_usage_extract` **AWAL_FINANCE.rpd_awal_usage_client_all_segments_live** - Used by 1 views: `awal_awal_finance_rpd_awal_usage_client_all_segments_live` **AWAL_HISTORICAL_DATASETS_TEMP.RPD_AWAL_USAGE_IP616280** - Used by 1 views: `int_awal_historical_datasets_temp_rpd_awal_usage_ip616280` **DBT_PROD.AWAL_TIER_GROUPS** - Used by 2 views: `int_dbt_prod_awal_tier_groups`, `awal_int_dbt_prod_awal_tier_groups` **DBT_PROD.SUMMARY_STREAMS** - Used by 1 views: `awal_int_dbt_prod_summary_streams` **PROD.GDA_LEADS** - Used by 1 views: `facts_prod_gda_leads` **SALESFORCE.ACCOUNT** - Used by 1 views: `awal_sax_salesforce_account` **SALESFORCE.OPPORTUNITY** - Used by 1 views: `awal_sax_salesforce_opportunities` **SAX_DELSERVERS.ORCHARD_CLIENT_IDS** - Used by 1 views: `awal_sax_sax_delservers_orchard_clidnt_ids` **art_relations_prod_art_relations.country** - Used by 1 views: `awal_orch_app_ar_country` **art_relations_prod_art_relations.genre** - Used by 1 views: `awal_orch_app_ar_genre` **art_relations_prod_art_relations.releases** - Used by 1 views: `awal_orch_app_ar_releases` **dbt_prod.base_dim_playlist** - Used by 1 views: `awal_facts_prod_dim_playlist` **prod.dim_artist** - Used by 1 views: `awal_facts_prod_dim_artist` **prod.dim_country** - Used by 1 views: `awal_facts_prod_dim_country` **prod.dim_label** - Used by 1 views: `awal_facts_prod_dim_label` **prod.dim_release** - Used by 1 views: `awal_facts_prod_dim_release` **prod.dim_track** - Used by 1 views: `awal_facts_prod_dim_track` **prod_ddex_ingester_ddex_ingester.upc_remap** - Used by 1 views: `upc_remap` #### Derived Tables Views with custom SQL (complex transformations): Total: 15 views | View | Lines of Code | Source Tables | |------|---------------|---------------| | `sony_applications_data` | 441 | Art_Relations_Prod_Art_Relations.Vendor, Awal_... | | `detailed_catalogue_report` | 363 | Sax.Exp_Version_Owners, Sax.Exp_Versions, Sax.... | | `sax_applications_data` | 286 | Sax.Awal_Api_Services, Sax.Awal_App_Srv_Histor... | | `sony_applications_data_signup` | 246 | Prod.Audit_Event_Gda_Signup | | `awal_workstation_gcp_priorities` | 226 | Art_Relations_Prod_Art_Relations.Artist_Info, ... | | `sony_applications_data_approval` | 204 | Prod.Audit_Event_Gda_Approval | | `sony_applications_data_submit` | 196 | Prod.Audit_Event_Gda_Submit_Application | | `sony_applications_data_leads` | 166 | Awal_Sax, Awal_Sax.Sax, Prod.Audit_Event_Gda_Leads | | `awal_metadata_simplified` | 164 | Dbt_Prod.Metadata_Simplified, Intelligence.Dbt_Prod | | `bi_riaa_certification` | 164 | Awal_Sax, Awal_Sax.Sax, Sax.Exp_Versions, Sax.... | | `sony_applications_data_unqualified` | 114 | Prod.Audit_Event_Gda_Unqualified_Leads | | `statements` | 108 | Awal_Sax, Awal_Sax.Sax, Sax.Interested_Parties... | | `streaming_data_details` | 106 | Awal.Awal_Finance, Awal_Finance.Awal_Streaming_Data_Lite | | `test_view` | 69 | Custom SQL | | `Lauv_catalogue_report` | 53 | Awal_Sax, Awal_Sax.Sax, Sax.Exp_Version_Record... | ## Explore Relationships ### Explores and Their Dependencies #### Model: Awal_Opportunities **awal_sax_salesforce_opportunities** (AWAL Opportunities) - Base View: `awal_sax_salesforce_opportunities` - View Type: Direct Table - Data Source: AWAL_SAX.SALESFORCE.OPPORTUNITY #### Model: Lauv_catalogue_report **Lauv_catalogue_report** (Lauv Products) - Base View: `Lauv_catalogue_report` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Exp_Version_Recordings, Sax.Exp_Versio... #### Model: applications_data **sony_applications_data** (SONY Applications Data) - Base View: `sony_applications_data` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Vendor, Awal_Sax, Awal_Sax.Sax, O... **sony_applications_data_leads** (SONY Raw Applications Data) - Base View: `sony_applications_data_leads` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Prod.Audit_Event_Gda_Leads **sax_applications_data** (SAX Applications Data) - Base View: `sax_applications_data` - View Type: Derived Table - Data Source: Derived from: Sax.Awal_Api_Services, Sax.Awal_App_Srv_History, Sax.Awal_Applicat... #### Model: awal_historical_data_sets **int_awal_historical_datasets_temp_awal_invoice_pmts** (AWAL Invoice PMTS) - Base View: `int_awal_historical_datasets_temp_awal_invoice_pmts` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_INVOICE_PMTS **awal_awal_finance_fpa_pr_revenue** (FPA PR Revenue) - Base View: `awal_awal_finance_fpa_pr_revenue` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.FPA_PR_AWAL **awal_awal_finance_awal_royalties_dashboard** (AWAL Royalties Dashboard) - Base View: `awal_awal_finance_awal_royalties_dashboard` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_ROYALTIES_DASHBOARD **awal_awal_finance_rpd_nr_usage_extract** (AWAL RPD NR Usage Extract) - Base View: `awal_awal_finance_rpd_nr_usage_extract` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.RPD_NR_USAGE_EXTRACT **awal_awal_finance_fpa_pr_neighboringrights** (AWAL FPA PR Neighboring Rights) - Base View: `awal_awal_finance_fpa_pr_neighboringrights` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.FPA_PR_NEIGHBOURINGRIGHTS **int_awal_historical_datasets_temp_awal_invoice_pmts_revised** (AWAL Invoice PMTS Revised) - Base View: `int_awal_historical_datasets_temp_awal_invoice_pmts_revised` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_INVOICE_PMTS_REVISED **int_awal_historical_datasets_temp_awal_itunes_downloads** (AWAL iTunes Download) - Base View: `int_awal_historical_datasets_temp_awal_itunes_downloads` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_ITUNES_DOWNLOADS **int_awal_historical_datasets_temp_awal_num_new_releases** (AWAL Num New Releases) - Base View: `int_awal_historical_datasets_temp_awal_num_new_releases` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.NUM_NEW_RELEASES **int_awal_historical_datasets_temp_awal_outstanding_invoices_dashboard** (AWAL Outstanding Invoices Dashboard) - Base View: `int_awal_historical_datasets_temp_awal_outstanding_invoices_dashboard` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_OUTSTANDING_INVOICES_DASHBOARD **int_awal_historical_datasets_temp_awal_streaming_data** (AWAL Streaming Data) - Base View: `int_awal_historical_datasets_temp_awal_streaming_data` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_STREAMING_DATA **int_awal_historical_datasets_temp_awal_streaming_data_ex_platform** (AWAL Streaming Data Ex Platform) - Base View: `int_awal_historical_datasets_temp_awal_streaming_data_ex_platform` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_STREAMING_DATA_EX_PLATFORM **int_awal_historical_datasets_temp_awal_streaming_data_inc_platform** (AWAL Streaming Data Inc Platform) - Base View: `int_awal_historical_datasets_temp_awal_streaming_data_inc_platform` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_STREAMING_DATA_INC_PLATFORM **int_awal_historical_datasets_temp_awal_streaming_data_territory** (AWAL Streaming Data Territory) - Base View: `int_awal_historical_datasets_temp_awal_streaming_data_territory` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_STREAMING_DATA_TERRITORY **int_awal_historical_datasets_temp_awal_streams_per_release_segments** (AWAL Stream Per Release Segment) - Base View: `int_awal_historical_datasets_temp_awal_streams_per_release_segments` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_STREAMS_PER_RELEASE_SEGMENTS **int_awal_historical_datasets_temp_awal_total_streams_segments** (AWAL Total Stream Segment) - Base View: `int_awal_historical_datasets_temp_awal_total_streams_segments` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_TOTAL_STREAMS_SEGMENTS **int_awal_historical_datasets_temp_awal_weekly_spotify_playlist_adds** (AWAL Weekly Spotify Playlist Adds) - Base View: `int_awal_historical_datasets_temp_awal_weekly_spotify_playlist_adds` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_WEEKLY_SPOTIFY_PLAYLIST_ADDS **int_awal_historical_datasets_temp_fpa_recoup_rev_awal** (FPA Recoup Rev AWAL) - Base View: `int_awal_historical_datasets_temp_fpa_recoup_rev_awal` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.FPA_RECOUP_REV_AWAL **int_awal_historical_datasets_temp_group_all_bu_recoupment** (Group All BU Recoupment) - Base View: `int_awal_historical_datasets_temp_group_all_bu_recoupment` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.GROUP_ALL_BU_RECOUPMENT **int_awal_historical_datasets_temp_rd_awal_usage** (RD AWAL Usage) - Base View: `int_awal_historical_datasets_temp_rd_awal_usage` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.RD_AWAL_USAGE **awal_awal_finance_rpd_awal_usage_client_all_segments_live** (RD AWAL Usage Client All Segments Live) - Base View: `awal_awal_finance_rpd_awal_usage_client_all_segments_live` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.rpd_awal_usage_client_all_segments_live **int_awal_historical_datasets_temp_rd_awal_usage_live** (RD AWAL Usage Live) - Base View: `int_awal_historical_datasets_temp_rd_awal_usage_live` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.RD_AWAL_USAGE_LIVE **int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform** (RPD AWAL Usage Client Ex Platform) - Base View: `int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.RPD_AWAL_USAGE_CLIENT_EX_PLATFORM **int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform_b2b_ald** (RPD AWAL Usage Client Ex Platform B2B Ald) - Base View: `int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform_b2b_ald` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.RPD_AWAL_USAGE_CLIENT_EX_PLATFORM_B2B_ALD **int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform_dsp_revenue** (RPD AWAL Usage Client Ex Platform DSP Revenue) - Base View: `int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform_dsp_revenue` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.RPD_AWAL_USAGE_CLIENT_EX_PLATFORM_DSP_REVENUE **int_awal_historical_datasets_temp_rpd_awal_usage_ip616280** (RPD AWAL Usage IP616280) - Base View: `int_awal_historical_datasets_temp_rpd_awal_usage_ip616280` - View Type: Direct Table - Data Source: INTELLIGENCE.AWAL_HISTORICAL_DATASETS_TEMP.RPD_AWAL_USAGE_IP616280 **int_awal_historical_datasets_temp_total_stream_segment_yttest** (Total Stream Segment YTTest) - Base View: `int_awal_historical_datasets_temp_total_stream_segment_yttest` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_TOTAL_STREAMS_SEGMENTS_YTTEST **int_dbt_prod_awal_all_pos_model** (AWAL All POS Model) - Base View: `int_dbt_prod_awal_all_pos_model` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_ALL_POS **int_dbt_prod_awal_applications_model** (AWAL Application Model) - Base View: `int_dbt_prod_awal_applications_model` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_APPLICATIONS **int_dbt_prod_awal_basic_takedowns_model** (AWAL Basic Takedown Model) - Base View: `int_dbt_prod_awal_basic_takedowns_model` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_BASIC_TAKEDOWNS **int_dbt_prod_awal_groups_agr_recordings_model** (AWAL Group AGR Recordings Model) - Base View: `int_dbt_prod_awal_groups_agr_recordings_model` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_GROUP_AGR_RECORDINGS **int_dbt_prod_awal_new_client_list_model** (AWAL New Client List Model) - Base View: `int_dbt_prod_awal_new_client_list_model` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_NEW_CLIENT_LIST **int_dbt_prod_awal_num_active_artists_model** (AWAL Num Active Artist Model) - Base View: `int_dbt_prod_awal_num_active_artists_model` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_NUM_ACTIVE_ARTISTS **int_dbt_prod_awal_paid_and_future_advances_model** (AWAL Paid and Future Advanmces Model) - Base View: `int_dbt_prod_awal_paid_and_future_advances_model` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_PAID_AND_FUTURE_ADVANCES **int_dbt_prod_awal_tier_groups** (AWAL Tier Groups) - Base View: `int_dbt_prod_awal_tier_groups` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.AWAL_TIER_GROUPS **int_dbt_prod_awal_agr_nr_model** (AWAL Agr NR Model) - Base View: `int_dbt_prod_awal_agr_nr_model` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_GROUP_AGR_NR #### Model: awal_orchard_client_id **awal_sax_sax_delservers_orchard_clidnt_ids** (awal_sax_sax_delservers_orchard_clidnt_ids) - Base View: `awal_sax_sax_delservers_orchard_clidnt_ids` - View Type: Direct Table - Data Source: AWAL_SAX.SAX_DELSERVERS.ORCHARD_CLIENT_IDS #### Model: awal_recordings_recoup_rev_fpadb **int_dbt_prod_awal_groups_agr_recordings_model** (TEST) - Base View: `int_dbt_prod_awal_groups_agr_recordings_model` - View Type: Direct Table - Data Source: AWAL.AWAL_FINANCE.AWAL_GROUP_AGR_RECORDINGS #### Model: awal_salesforce **awal_salesforce_opportunities** (AWAL Salesforce Opportunities) - Base View: `awal_salesforce_opportunities` - View Type: Direct Table - Data Source: BUSINESS_SYSTEMS_SALESFORCE_DATA.AWAL.OPPORTUNITY #### Model: awal_summary_streams_separation **awal_int_dbt_prod_summary_streams** (AWAL Summary Streams Model) - Base View: `awal_int_dbt_prod_summary_streams` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS **awal_metadata_simplified** (awal_metadata_simplified) - Base View: `awal_metadata_simplified` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Metadata_Simplified, Intelligence.Dbt_Prod #### Model: awal_summary_streams_separation_mondayweek **awal_int_dbt_prod_summary_streams** (AWAL Summary Streams Model Monday) - Base View: `awal_int_dbt_prod_summary_streams` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS **awal_metadata_simplified** (awal_metadata_simplified) - Base View: `awal_metadata_simplified` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod.Metadata_Simplified, Intelligence.Dbt_Prod #### Model: awal_workstation_gcp_priorities **awal_workstation_gcp_priorities** (Release Priorities) - Base View: `awal_workstation_gcp_priorities` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A... #### Model: bi_riaa_certification **bi_riaa_certification** (RIAA Certification) - Base View: `bi_riaa_certification` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Exp_Versions, Sax.Exploitation_Formats... #### Model: bi_riaa_certification_summary **bi_riaa_certification** (RIAA Certification) - Base View: `bi_riaa_certification` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Exp_Versions, Sax.Exploitation_Formats... #### Model: detailed_catalogue_report **detailed_catalogue_report** (Detailed Catalogue Report) - Base View: `detailed_catalogue_report` - View Type: Derived Table - Data Source: Derived from: Sax.Exp_Version_Owners, Sax.Exp_Versions, Sax.Expv_Configuration_T... #### Model: gda **facts_prod_gda_leads** (facts_prod_gda_leads) - Base View: `facts_prod_gda_leads` - View Type: Direct Table - Data Source: FACTS.PROD.GDA_LEADS #### Model: statements **statements** (SAX IP Statements) - Base View: `statements` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Interested_Parties, Sax.Ip_Statements #### Model: streaming_data_details **streaming_data_details** (Streaming Data Details) - Base View: `streaming_data_details` - View Type: Derived Table - Data Source: Derived from: Awal.Awal_Finance, Awal_Finance.Awal_Streaming_Data_Lite #### Model: upc_remap **upc_remap** (UPC Remap SAX-The Orchard) - Base View: `upc_remap` - View Type: Direct Table - Data Source: orchard_app_reporting_v2.prod_ddex_ingester_ddex_ingester.upc_remap ## 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