# Data Lineage & Dependencies Generated on: 2026-07-03 09:37:09 This document shows the relationships and dependencies between models, views, and data sources. ## Overview - **Total Models:** 53 - **Total Views:** 147 - **Derived Views:** 101 - **Direct Table Views:** 46 ## Model Dependencies ### Models and Their Views #### AWAL_NR_Royalties - **Includes:** 1 views - **Views:** - `awal_nr_royalties` #### Abacus_Contract_Terms - **Includes:** 1 views - **Views:** - `abacus_contract_terms` #### Abacus_Contracts_Linked_To_Contributors - **Includes:** 1 views - **Views:** - `abacus_contracts_linked_to_contributors` #### All_Rights_Blocks - **Includes:** 1 views - **Views:** - `all_rights_blocks` #### All_Schedules - **Includes:** 1 views - **Views:** - `all_schedules` #### Content_Master_Exporter - **Includes:** 13 views - **Views:** - `Content_Master_Exporter` - `Content_Owner_Master_Exporter` - `Content_Owner_No_Contributor` - `Content_Master_ChartMetric` - `ChartMetric_Artist_Lookup` - `ChartMetric_UUID_Lookup` - `ChartMetric_Content_Match` - `ChartMetric_New_Releases` - `Content_Owner_Master_Exporter_May2025` - `OA_Ingested_Content_With_Collections` - `Content_QA_Owner_Master_Exporter_May2025` - `ChartMetric_Label_Content_Match` - `ChartMetric_WatchList` #### Current_Balance - **Includes:** 3 views - **Views:** - `current_balance_performers` - `current_balance_labels` - `current_balance_all_accounts_Feb24` #### Delivery_App - **Includes:** 5 views - **Views:** - `Delivery_App_Claims_Status` - `Delivery_App_Queue_Status` - `Delivery_App_Queue_Status_Count` - `Delivery_App_Jobs_Status` - `Deliver_Owner_SENA` #### Discography_Export - **Includes:** 3 views - **Views:** - `master_discography_export` - `failed_exports` - `master_discography_export_reduced` #### Finance_Reports - **Includes:** 1 views - **Views:** - `Finance_Team_Performer_Royalties` #### Generated_Income_Summary - **Includes:** 2 views - **Views:** - `generated_income_summary` - `generated_income_summary_sum_function` #### Historic_Generated_Income_Report_Correct - **Includes:** 3 views - **Views:** - `historic_gis_acc_ccy` - `historic_gis_usd` - `historic_gis_sum` #### Historic_Generated_Income_Summary - **Includes:** 7 views - **Views:** - `generated_income_summary` - `generated_income_summary_3` - `historic_generated_income_summary_working` - `historic_gis_correct` - `historic_gis_performers_Blanka` - `historic_gis_labels_Blanka` - `historic_generated_income_abacus_format` #### KNR_Ownership_Run - **Includes:** 7 views - **Views:** - `KNR_Ownership_Run_CheckSums` - `KNR_Ownership_Run_Delivered_Societies` - `KNR_Ownership_Run_Prod_PreApproval_Summary` - `KNR_Ownership_Run_Prod_PostApproval_Summary` - `KNR_Ownership_Run_Prod_PreApproval` - `KNR_Ownership_Run_Prod_PostApproval` - `KNR_Ownership_Prod_PostApproval_Doublebooking` #### KNR_Performer_Run - **Includes:** 10 views - **Views:** - `KNR_Performer_Run_Prod_Unallocated` - `KNR_Performer_Run_Prod_PreApproval` - `KNR_Performer_Run_Prod_PreApproval_Summary` - `KNR_Performer_Run_Prod_PostApproval` - `KNR_Performer_Run_Prod_PostApproval_Summary` - `KNR_Performer_Run_CheckSums` - `KNR_Performer_Run_Delivered_Societies` - `KNR_Performer_Run_Delivered_Contributors` - `KNR_Performer_Run_Reported_Contributor_Names` - `KNR_Performer_Run_Exchange_Rates` #### KNR_VAT_Applied - **Includes:** 1 views - **Views:** - `knr_vat_applied` #### Label_Royalties - **Includes:** 1 views - **Views:** - `label_royalties` #### MXM_Reports - **Includes:** 2 views - **Views:** - `mxm_query` - `mxm_report` #### New_Income_Summary - **Includes:** 6 views - **Views:** - `New_Income_Summary` - `New_Income_Summary_Labels` - `New_Income_Performers_Blanka` - `New_Income_Summary_AWAL_NR` - `New_Income_Summary_Test` - `New_Income_Summary_Label_Test` #### Ownership_OA - **Includes:** 1 views - **Views:** - `ownership_OA_full_delivery_history` #### Performer_Royalties - **Includes:** 2 views - **Views:** - `performer_royalties` - `performer_quarterly_report` #### Pre_Label_Prod_Applied_Adjustments - **Includes:** 1 views - **Views:** - `pre_label_prod_aa` #### Residency_and_Tax - **Includes:** 2 views - **Views:** - `residency_and_tax` - `citizenship_and_residency` #### Societies - **Includes:** 3 views - **Views:** - `historic_usd_societies` - `new_societies_usd` - `new_societies_usd_labels` #### Societies_registrations - **Includes:** 2 views - **Views:** - `societies_registrations` - `societies_registrations_graph` #### VAT_Applied - **Includes:** 1 views - **Views:** - `vat_applied` #### _NEW_abacus_fact_sales_nr_salesforce - **Includes:** 4 views - **Views:** - `performer_salesforce_society` - `performer_salesforce_contributor` - `nr_contributor` - `//abacus-looker/**/*` #### _NEW_chartmetric+ownership_content - **Includes:** 16 views - **Views:** - `chartmetric_airplay` - `chartmetric_recordings` - `global_countries` - `content_nr_ownership_carveout` - `content_nr_ownership_contributions` - `content_nr_ownership_contributor` - `content_nr_ownership_monetizable` - `content_nr_ownership_participant` - `content_nr_ownership_product_has_featured_artist_nr_participant` - `content_nr_ownership_product_has_primary_artist_nr_participant` - `content_nr_ownership_products` - `content_nr_ownership_service` - `content_nr_ownership_sound_recording` - `content_nr_ownership_track` - `content_nr_ownership_track_on_product` - `content_nr_ownership_track_on_soundrecording` #### _NEW_chartmetric+performer_content - **Includes:** 11 views - **Views:** - `chartmetric_airplay` - `chartmetric_recordings` - `global_countries` - `performance_nr_contribution` - `performance_nr_contributor` - `performance_nr_particpant` - `performance_nr_sound_recording` - `nr_sound_recording_has_featured_artist_nr_participant` - `nr_sound_recording_has_primary_artist_nr_participant` - `nr_contribution_contributed_to_nr_sound_recording` - `nr_contribution_type` #### _NEW_chartmetric_airplay - **Includes:** 3 views - **Views:** - `chartmetric_airplay` - `chartmetric_recordings` - `global_countries` #### _NEW_chartmetric_itunes - **Includes:** 3 views - **Views:** - `chartmetric_itunes` - `chartmetric_recordings` - `global_countries` #### _NEW_chartmetric_new_releases - **Includes:** 13 views - **Views:** - `chartmetric_recordings` - `chartmetric_spotify` - `chartmetric_spotify_playlists` - `chartmetric_itunes` - `global_countries` - `performance_nr_contribution` - `performance_nr_contributor` - `performance_nr_particpant` - `performance_nr_sound_recording` - `nr_sound_recording_has_featured_artist_nr_participant` - `nr_sound_recording_has_primary_artist_nr_participant` - `nr_contribution_contributed_to_nr_sound_recording` - `nr_contribution_type` #### _NEW_chartmetric_spotify - **Includes:** 4 views - **Views:** - `chartmetric_spotify` - `chartmetric_spotify_playlists` - `chartmetric_recordings` - `global_countries` #### _NEW_content_combined - **Includes:** 6 views - **Views:** - `nr_contribution` - `nr_contribution_type` - `nr_contributor` - `nr_sound_recording_has_featured_artist_nr_participant` - `nr_sound_recording_has_primary_artist_nr_participant` - `nr_contribution_contributed_to_nr_sound_recording` #### _NEW_ownership_content - **Includes:** 13 views - **Views:** - `content_nr_ownership_carveout` - `content_nr_ownership_contributions` - `content_nr_ownership_contributor` - `content_nr_ownership_monetizable` - `content_nr_ownership_participant` - `content_nr_ownership_product_has_featured_artist_nr_participant` - `content_nr_ownership_product_has_primary_artist_nr_participant` - `content_nr_ownership_products` - `content_nr_ownership_service` - `content_nr_ownership_sound_recording` - `content_nr_ownership_track` - `content_nr_ownership_track_on_product` - `content_nr_ownership_track_on_soundrecording` #### _NEW_ownership_delivery - **Includes:** 3 views - **Views:** - `*` - `/**/*` - `my_dashboard.dashboard.lookml` #### _NEW_performer_content - **Includes:** 9 views - **Views:** - `performance_nr_contribution` - `performance_nr_contributor` - `performance_nr_particpant` - `performance_nr_sound_recording` - `nr_sound_recording_has_featured_artist_nr_participant` - `nr_sound_recording_has_primary_artist_nr_participant` - `nr_contribution_contributed_to_nr_sound_recording` - `nr_contribution_type` - `nr_contribution_instruments_multi_row` #### _NEW_performer_content_salesforce - **Includes:** 10 views - **Views:** - `performance_nr_contribution` - `performance_nr_contributor` - `performance_nr_particpant` - `performance_nr_sound_recording` - `nr_sound_recording_has_featured_artist_nr_participant` - `nr_sound_recording_has_primary_artist_nr_participant` - `nr_contribution_contributed_to_nr_sound_recording` - `nr_contribution_type` - `nr_contribution_instruments_multi_row` - `performer_salesforce_contributor` #### _NEW_performer_delivery - **Includes:** 14 views - **Views:** - `customer_master_master` - `global_countries` - `performance_delivery_claiming_order` - `performance_delivery_claiming_job` - `performance_delivery_claims` - `performance_delivery_queue` - `performance_nr_contribution` - `performance_nr_contributor` - `performance_nr_particpant` - `performance_nr_sound_recording` - `nr_sound_recording_has_featured_artist_nr_participant` - `nr_sound_recording_has_primary_artist_nr_participant` - `nr_contribution_contributed_to_nr_sound_recording` - `nr_contribution_type` #### _NEW_performer_delivery_queue - **Includes:** 1 views - **Views:** - `performance_delivery_queue` #### _NEW_salesforce_performer - **Includes:** 2 views - **Views:** - `performer_salesforce_contributor` - `nr_contributor` #### _NEW_salesforce_society - **Includes:** 3 views - **Views:** - `performer_salesforce_society` - `performer_salesforce_contributor` - `nr_contributor` #### _NEW_sax_model - **Includes:** 17 views - **Views:** - `Income_by_client_Roys_and_Roy_Adj` - `all_rights_blocks` - `all_schedules` - `citizenship_and_residency` - `client_overview_full` - `failed_exports` - `historic_generated_income_abacus_format` - `historic_gis_acc_ccy` - `historic_gis_usd` - `mxm_report` - `nr_dupes` - `nr_queries` - `nr_queries_graphs` - `residency_and_tax` - `societies_registrations` - `societies_registrations_graph` - `test_rlr` #### _NEW_unified_income_summary_performer - **Includes:** 1 views - **Views:** - `unified_income_summary_performer` #### chartmetric - **Includes:** 3 views - **Views:** - `chartmetric_perf_content_income` - `chartmetric_perf_marketshare` - `chartmetric_top_n_tracks` #### chartmetric_marketshare - **Includes:** 3 views - **Views:** - `chartmetric_perf_content_income` - `chartmetric_perf_marketshare` - `chartmetric_top_n_tracks` #### client_overview_full - **Includes:** 2 views - **Views:** - `client_overview_full` - `Vendor_Emails` #### labels_database - **Includes:** 1 views - **Views:** - `labels_database` #### nr_dupes - **Includes:** 1 views - **Views:** - `nr_dupes` #### nr_queries - **Includes:** 2 views - **Views:** - `nr_queries` - `nr_queries_graphs` #### performer_salesforce - **Includes:** 3 views - **Views:** - `performer_salesforce_contributor` - `performer_salesforce_society` - `performer_salesforce_combined` #### statement_email_recipients - **Includes:** 1 views - **Views:** - `int_dbt_prod_knr_statement_emails` #### test_rlr - **Includes:** 1 views - **Views:** - `test_rlr` ## View Dependencies ### Views by Data Source #### Direct Database Tables Views that directly reference database tables: **ART_RELATIONS_PROD_ART_RELATIONS.COUNTRY** - Used by 1 views: `global_countries` **ART_RELATIONS_PROD_ART_RELATIONS.CUSTOMER_MASTER_MASTER** - Used by 2 views: `global_stores`, `customer_master_master` **DBT_PROD_KNR.HISTORIC_GENERATED_INCOME_SUMMARY_ACCOUNT_CURRENCY** - Used by 1 views: `historic_gis_acc_ccy` **DBT_PROD_KNR.HISTORIC_GENERATED_INCOME_SUMMARY_USD** - Used by 1 views: `historic_gis_usd` **DBT_PROD_KNR.MXM_REPORT** - Used by 1 views: `mxm_report` **KNR.OWNERSHIP_DELIVERY_HISTORY_AGGREGATED** - Used by 1 views: `ownership_oa_delivery_history` **NR.CONTRIBUTOR_C** - Used by 1 views: `performer_salesforce_contributor` **NR.SOCIETY_C** - Used by 1 views: `performer_salesforce_society` **PROD.NR_CONTRIBUTION_CONTRIBUTED_TO_NR_SOUND_RECORDING** - Used by 1 views: `nr_contribution_contributed_to_nr_sound_recording` **PROD.NR_CONTRIBUTION_TYPE** - Used by 1 views: `nr_contribution_type` **PROD.NR_CONTRIBUTOR** - Used by 1 views: `nr_contributor` **PROD.NR_OWNERSHIP_PRODUCT** - Used by 1 views: `content_nr_ownership_products` **PROD.NR_OWNERSHIP_PRODUCT_HAS_FEATURED_ARTIST_NR_PARTICIPANT** - Used by 1 views: `content_nr_ownership_product_has_featured_artist_nr_participant` **PROD.NR_OWNERSHIP_PRODUCT_HAS_PRIMARY_ARTIST_NR_PARTICIPANT** - Used by 1 views: `content_nr_ownership_product_has_primary_artist_nr_participant` **PROD.NR_OWNERSHIP_SERVICE** - Used by 1 views: `content_nr_ownership_service` **PROD.NR_OWNERSHIP_TRACK** - Used by 1 views: `content_nr_ownership_track` **PROD.NR_PARTICIPANT** - Used by 1 views: `nr_participant` **PROD.NR_PRODUCT_INCLUDES_NR_TRACK** - Used by 1 views: `content_nr_ownership_track_on_product` **PROD.NR_SOUND_RECORDING** - Used by 1 views: `nr_sound_recording` **PROD.NR_SOUND_RECORDING_HAS_CARVEOUT_RULE_OWNERSHIP_SERVICE** - Used by 1 views: `content_nr_ownership_carveout` **PROD.NR_SOUND_RECORDING_HAS_FEATURED_ARTIST_NR_PARTICIPANT** - Used by 1 views: `nr_sound_recording_has_featured_artist_nr_participant` **PROD.NR_SOUND_RECORDING_HAS_MONETIZE_RULE_OWNERSHIP_SERVICE** - Used by 1 views: `content_nr_ownership_monetizable` **PROD.NR_SOUND_RECORDING_HAS_PRIMARY_ARTIST_NR_PARTICIPANT** - Used by 1 views: `nr_sound_recording_has_primary_artist_nr_participant` **PROD.NR_TRACK_IS_PLACEMENT_OF_NR_SOUND_RECORDING** - Used by 1 views: `content_nr_ownership_track_on_soundrecording` **PROD.OWNERSHIP_NR_CONTRIBUTION** - Used by 1 views: `content_nr_ownership_contributions` **PROD.OWNERSHIP_NR_CONTRIBUTOR** - Used by 1 views: `content_nr_ownership_contributor` **PROD.OWNERSHIP_NR_PARTICIPANT** - Used by 1 views: `content_nr_ownership_participant` **PROD.OWNERSHIP_NR_SOUND_RECORDING** - Used by 1 views: `content_nr_ownership_sound_recording` **PROD.PERFORMANCE_NR_CONTRIBUTION** - Used by 1 views: `performance_nr_contribution` **PROD.PERFORMANCE_NR_CONTRIBUTOR** - Used by 1 views: `performance_nr_contributor` **PROD.PERFORMANCE_NR_PARTICIPANT** - Used by 1 views: `performance_nr_particpant` **PROD.PERFORMANCE_NR_SOUND_RECORDING** - Used by 1 views: `performance_nr_sound_recording` **PROD_NR_OWNERSHIP_DELIVERY_NEIGHBOURING_RIGHTS_OWNERSHIP_DELIVERY.JOBS** - Used by 1 views: `ownership_delivery_jobs` **PROD_NR_OWNERSHIP_DELIVERY_NEIGHBOURING_RIGHTS_OWNERSHIP_DELIVERY.JOB_CONTENTS** - Used by 1 views: `ownership_delivery_job_contents` **PROD_NR_OWNERSHIP_DELIVERY_NEIGHBOURING_RIGHTS_OWNERSHIP_DELIVERY.ORDERS** - Used by 1 views: `ownership_delivery_orders` **PROD_NR_OWNERSHIP_DELIVERY_NEIGHBOURING_RIGHTS_OWNERSHIP_DELIVERY.ORDER_CONTENTS** - Used by 1 views: `ownership_delivery_order_contents` **PROD_NR_OWNERSHIP_DELIVERY_NEIGHBOURING_RIGHTS_OWNERSHIP_DELIVERY.TERRITORIES** - Used by 1 views: `ownership_delivery_territories` **PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY.CLAIMING_JOB** - Used by 1 views: `performance_delivery_claiming_job` **PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY.CLAIMING_ORDER** - Used by 1 views: `performance_delivery_claiming_order` **PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY.CLAIMS** - Used by 1 views: `performance_delivery_claims` **PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY.DELIVERY_QUEUE** - Used by 1 views: `performance_delivery_queue` **RAW_DATA.L_SPOTIFY_PLAYLIST_STAT** - Used by 1 views: `chartmetric_spotify_playlist_stats` **dbt_hstanhope_knr.chartmetric_perf_content_income** - Used by 1 views: `chartmetric_perf_content_income` **dbt_prod_knr.knr_account_payment_email_list** - Used by 1 views: `int_dbt_prod_knr_statement_emails` **prod.nr_contribution** - Used by 1 views: `nr_contribution` #### Derived Tables Views with custom SQL (complex transformations): Total: 101 views | View | Lines of Code | Source Tables | |------|---------------|---------------| | `performer_salesforce_combined` | 1516 | Business_Systems_Salesforce_Data, Business_Sys... | | `Content_QA_Owner_Master_Exporter_May2025` | 605 | Qa.Nr_Contribution_Contributed_To_Nr_Sound_Rec... | | `OA_Ingested_Content_With_Collections` | 545 | Art_Relations_Prod_Art_Relations.Artist_Info, ... | | `Content_Owner_Master_Exporter_May2025` | 473 | Prod.Nr_Contribution_Contributed_To_Nr_Sound_R... | | `Content_Owner_Master_Exporter` | 396 | Prod.Nr_Ownership_Product_Has_Featured_Artist_... | | `Deliver_Owner_SENA` | 377 | Prod.Nr_Contribution_Contributed_To_Nr_Sound_R... | | `master_discography_export` | 375 | Prod.Nr_Contribution_Contributed_To_Nr_Sound_R... | | `Content_Master_ChartMetric` | 364 | Art_Relations_Prod_Art_Relations.Country, Prod... | | `chartmetric_itunes` | 357 | Chartmetric.Raw_Data, Raw_Data.Itunes, Raw_Dat... | | `KNR_Performer_Run_Prod_PostApproval` | 353 | Prod.Accounting_Run_Results_Nr, Prod.Contract_... | | `KNR_Performer_Run_Prod_PreApproval` | 352 | Prod.Accounting_Run_Results_Nr_Staging, Prod.C... | | `unified_income_summary_performer` | 349 | Dbt_Prod_Knr.Historic_Generated_Income_Summary... | | `chartmetric_recordings` | 345 | Chartmetric.Raw_Data, Raw_Data.Cm_Album, Raw_D... | | `client_overview_full` | 339 | Sax.Agreement_Outgoing_Types, Sax.Agreement_Pe... | | `historic_generated_income_summary_working` | 336 | Custom SQL | | `New_Income_Summary_Labels` | 325 | Art_Relations_Prod_Art_Relations.Track_Artist,... | | `Content_Owner_No_Contributor` | 318 | Prod.Nr_Ownership_Product_Has_Featured_Artist_... | | `chartmetric_airplay` | 311 | Chartmetric.Raw_Data, Raw_Data.Acr_Channel, Ra... | | `ChartMetric_Content_Match` | 302 | Art_Relations_Prod_Art_Relations.Country, Prod... | | `New_Income_Summary_Label_Test` | 301 | Art_Relations_Prod_Art_Relations.Track_Artist,... | *Showing top 20 most complex derived views. Total: 101* ## Explore Relationships ### Explores and Their Dependencies #### Model: AWAL_NR_Royalties **awal_nr_royalties** (AWAL NR Royalties) - Base View: `awal_nr_royalties` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Distro, Prod.Contract_Transaction_Stag... #### Model: Abacus_Contract_Terms **abacus_contract_terms** (Abacus Contract Terms) - Base View: `abacus_contract_terms` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Prod.Dim_Transactiontype... #### Model: Abacus_Contracts_Linked_To_Contributors **abacus_contracts_linked_to_contributors** (Abacus Contracts Linked To Contributors) - Base View: `abacus_contracts_linked_to_contributors` - View Type: Derived Table - Data Source: Derived from: Prod.Nr_Contribution_Type, Prod.Performance_Nr_Contribution, Prod.... #### Model: All_Rights_Blocks **all_rights_blocks** (All Rights Blocks) - Base View: `all_rights_blocks` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax #### Model: All_Schedules **all_schedules** (All Schedules) - Base View: `all_schedules` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax #### Model: Content_Master_Exporter **content_master_exporter** (Content Master Exporter) - Base View: `content_master_exporter` - View Type: Direct Table - Data Source: Unknown **Content_Owner_Master_Exporter** (Content_Owner_Master_Exporter) - Base View: `Content_Owner_Master_Exporter` - View Type: Derived Table - Data Source: Derived from: Prod.Nr_Ownership_Product_Has_Featured_Artist_Nr_Participant, Prod... **Content_Owner_No_Contributor** (Content_Owner_No_Contributor) - Base View: `Content_Owner_No_Contributor` - View Type: Derived Table - Data Source: Derived from: Prod.Nr_Ownership_Product_Has_Featured_Artist_Nr_Participant, Prod... **content_master_chartmetric** (Content Master Chartmetric) - Base View: `content_master_chartmetric` - View Type: Direct Table - Data Source: Unknown **chartmetric_artist_lookup** (ChartMetric Artist Lookup) - Base View: `chartmetric_artist_lookup` - View Type: Direct Table - Data Source: Unknown **chartmetric_uuid_lookup** (ChartMetric UUID Lookup) - Base View: `chartmetric_uuid_lookup` - View Type: Direct Table - Data Source: Unknown **chartmetric_content_match** (ChartMetric Content Match) - Base View: `chartmetric_content_match` - View Type: Direct Table - Data Source: Unknown **chartmetric_label_content_match** (ChartMetric Label Content Match) - Base View: `chartmetric_label_content_match` - View Type: Direct Table - Data Source: Unknown **chartmetric_new_releases** (chartmetric_new_releases) - Base View: `chartmetric_new_releases` - View Type: Direct Table - Data Source: Unknown **content_owner_master_exporter_may2025** (content_owner_master_exporter_may2025) - Base View: `content_owner_master_exporter_may2025` - View Type: Direct Table - Data Source: Unknown **oa_ingested_content_with_collections** (oa_ingested_content_with_collections) - Base View: `oa_ingested_content_with_collections` - View Type: Direct Table - Data Source: Unknown **content_qa_owner_master_exporter_may2025** (content_qa_owner_master_exporter_may2025) - Base View: `content_qa_owner_master_exporter_may2025` - View Type: Direct Table - Data Source: Unknown **chartmetric_watchlist** (chartmetric_watchlist) - Base View: `chartmetric_watchlist` - View Type: Direct Table - Data Source: Unknown #### Model: Current_Balance **current_balance_performers** (Current Balance - Performers) - Base View: `current_balance_performers` - View Type: Derived Table - Data Source: Derived from: Prod_Royalty_Accounting_Royalty_Accounting.Account, Prod_Royalty_A... **current_balance_labels** (Current Balance - Labels) - Base View: `current_balance_labels` - View Type: Derived Table - Data Source: Derived from: Prod_Royalty_Accounting_Royalty_Accounting.Account, Prod_Royalty_A... **current_balance_all_accounts_Feb24** (Current Balance) - Base View: `current_balance_all_accounts_Feb24` - View Type: Derived Table - Data Source: Derived from: Prod_Royalty_Accounting_Royalty_Accounting.Account, Prod_Royalty_A... #### Model: Delivery_App **Delivery_App_Claims_Status** (Delivery App Claims Status) - Base View: `Delivery_App_Claims_Status` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Customer_Master_Master, Prod.Nr_C... **Delivery_App_Queue_Status** (Delivery App Queue Status) - Base View: `Delivery_App_Queue_Status` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Art_Relations_Prod_Art_R... **Delivery_App_Queue_Status_Count** (Delivery App Queue Status Count) - Base View: `Delivery_App_Queue_Status_Count` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Customer_Master_Master, Orchard_A... **Delivery_App_Jobs_Status** (Delivery App Jobs Status) - Base View: `Delivery_App_Jobs_Status` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Customer_Master_Master, Orchard_A... **deliver_owner_sena** (deliver_owner_sena) - Base View: `deliver_owner_sena` - View Type: Direct Table - Data Source: Unknown #### Model: Discography_Export **master_discography_export** (Master Discography Export) - Base View: `master_discography_export` - View Type: Derived Table - Data Source: Derived from: Prod.Nr_Contribution_Contributed_To_Nr_Sound_Recording, Prod.Nr_Co... **failed_exports** (Failed Exports) - Base View: `failed_exports` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Agreement_Outgoing_Types, Sax.Agreemen... **master_discography_export_reduced** (Master Discography Export (Reduced)) - Base View: `master_discography_export_reduced` - View Type: Derived Table - Data Source: Derived from: Prod.Performance_Nr_Sound_Recording #### Model: Finance_Reports **Finance_Team_Performer_Royalties** (Finance_Team_Performer_Royalties) - Base View: `Finance_Team_Performer_Royalties` - View Type: Derived Table - Data Source: Derived from: Prod.Stmt_Db_Sales_Nr, Prod.Vw_Abacus_Fact_Sales_Nr_V3, Prod.Vw_Di... #### Model: Generated_Income_Summary **generated_income_summary** (generated_income_summary) - Base View: `generated_income_summary` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **generated_income_summary_sum_function** (generated_income_summary_sum_function) - Base View: `generated_income_summary_sum_function` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: Historic_Generated_Income_Report_Correct **historic_gis_acc_ccy** (Historic Generated Income Summary - Account Currency) - Base View: `historic_gis_acc_ccy` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD_KNR.HISTORIC_GENERATED_INCOME_SUMMARY_ACCOUNT_CURRENCY **historic_gis_usd** (Historic Generated Income Summary - USD) - Base View: `historic_gis_usd` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD_KNR.HISTORIC_GENERATED_INCOME_SUMMARY_USD **historic_gis_sum** (Historic_GIS_Sum) - Base View: `historic_gis_sum` - View Type: Derived Table - Data Source: Derived from: Awal_Sax.Sax, Sax.Exchange_Rates, Sax.Interested_Parties, Sax.Reco... #### Model: Historic_Generated_Income_Summary **generated_income_summary_3** (Historic Generated Income Summary 3) - Base View: `generated_income_summary_3` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Interested_Parties **historic_generated_income_summary_working** (Historic Generated Income Summary (Working)) - Base View: `historic_generated_income_summary_working` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **generated_income_summary** (Historic Generated Income Summary 2) - Base View: `generated_income_summary` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **historic_gis_correct** (Historic Generated Income Summary) - Base View: `historic_gis_correct` - View Type: Derived Table - Data Source: Derived from: Awal_Sax.Sax, Sax.Exchange_Rates, Sax.Interested_Parties, Sax.Reco... **historic_gis_performers_Blanka** (Historic GIS USD - Performers) - Base View: `historic_gis_performers_Blanka` - View Type: Derived Table - Data Source: Derived from: Awal_Sax.Sax, Sax.Exchange_Rates, Sax.Interested_Parties, Sax.Reco... **historic_gis_labels_Blanka** (Historic GIS USD - Labels) - Base View: `historic_gis_labels_Blanka` - View Type: Derived Table - Data Source: Derived from: Awal_Sax.Sax, Sax.Exchange_Rates, Sax.Interested_Parties, Sax.Reco... **historic_generated_income_abacus_format** (Historic GIS ACC CCY - Abacus Format) - Base View: `historic_generated_income_abacus_format` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod_Knr.Historic_Generated_Income_Summary_Account_Currency, I... #### Model: KNR_Ownership_Run **KNR_Ownership_Run_CheckSums** (KNR_Ownership_Run_CheckSums) - Base View: `KNR_Ownership_Run_CheckSums` - View Type: Derived Table - Data Source: Derived from: Prod.Stmt_Db_Sales_Distro_Staging, Royalty_Accounting, Royalty_Acc... **KNR_Ownership_Run_Delivered_Societies** (KNR_Ownership_Run_Delivered_Societies) - Base View: `KNR_Ownership_Run_Delivered_Societies` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Art_Relations_Prod_Art_R... **KNR_Ownership_Run_Prod_PreApproval_Summary** (KNR_Ownership_Run_Prod_PreApproval_Summary) - Base View: `KNR_Ownership_Run_Prod_PreApproval_Summary` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Distro_Staging, Prod.Contract_Transact... **KNR_Ownership_Run_Prod_PostApproval_Summary** (KNR_Ownership_Run_Prod_PostApproval_Summary) - Base View: `KNR_Ownership_Run_Prod_PostApproval_Summary` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Distro, Prod.Contract_Transaction_Stag... **KNR_Ownership_Run_Prod_PreApproval** (KNR_Ownership_Run_Prod_PreApproval) - Base View: `KNR_Ownership_Run_Prod_PreApproval` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Distro_Staging, Prod.Contract_Transact... **KNR_Ownership_Run_Prod_PostApproval** (KNR_Ownership_Run_Prod_PostApproval) - Base View: `KNR_Ownership_Run_Prod_PostApproval` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Distro, Prod.Contract_Transaction_Stag... **KNR_Ownership_Prod_PostApproval_Doublebooking** (KNR_Ownership_Prod_PostApproval_Doublebooking) - Base View: `KNR_Ownership_Prod_PostApproval_Doublebooking` - View Type: Derived Table - Data Source: Derived from: Prod.Vw_Abacus_Fact_Sales_Distro_V2, Royalty_Accounting, Royalty_A... #### Model: KNR_Performer_Run **KNR_Performer_Run_Prod_Unallocated** (KNR_Performer_Run_Prod_Unallocated) - Base View: `KNR_Performer_Run_Prod_Unallocated` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Customer_Master_Master, Prod.Acco... **KNR_Performer_Run_Prod_PreApproval** (KNR_Performer_Run_Prod_PreApproval) - Base View: `KNR_Performer_Run_Prod_PreApproval` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Nr_Staging, Prod.Contract_Transaction_... **KNR_Performer_Run_Prod_PreApproval_Summary** (KNR_Performer_Run_Prod_PreApproval_Summary) - Base View: `KNR_Performer_Run_Prod_PreApproval_Summary` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Nr_Staging, Prod.Contract_Transaction_... **KNR_Performer_Run_Prod_PostApproval** (KNR_Performer_Run_Prod_PostApproval) - Base View: `KNR_Performer_Run_Prod_PostApproval` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Nr, Prod.Contract_Transaction_Nr, Prod... **KNR_Performer_Run_Prod_PostApproval_Summary** (KNR_Performer_Run_Prod_PostApproval_Summary) - Base View: `KNR_Performer_Run_Prod_PostApproval_Summary` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Nr, Prod.Contract_Transaction_Nr, Prod... **KNR_Performer_Run_CheckSums** (KNR_Performer_Run_CheckSums) - Base View: `KNR_Performer_Run_CheckSums` - View Type: Derived Table - Data Source: Derived from: Prod.Stmt_Db_Sales_Nr_Staging, Royalty_Accounting, Royalty_Account... **KNR_Performer_Run_Delivered_Societies** (KNR_Performer_Run_Delivered_Societies) - Base View: `KNR_Performer_Run_Delivered_Societies` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Art_Relations_Prod_Art_R... **KNR_Performer_Run_Delivered_Contributors** (KNR_Performer_Run_Delivered_Contributors) - Base View: `KNR_Performer_Run_Delivered_Contributors` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Country, Art_Relations_Prod_Art_R... **KNR_Performer_Run_Reported_Contributor_Names** (KNR_Performer_Run_Reported_Contributor_Names) - Base View: `KNR_Performer_Run_Reported_Contributor_Names` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Nr_Staging, Prod.Contract_Transaction_... **KNR_Performer_Run_Exchange_Rates** (KNR_Performer_Run_Exchange_Rates) - Base View: `KNR_Performer_Run_Exchange_Rates` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Ac... #### Model: KNR_VAT_Applied **knr_vat_applied** (KNR VAT Applied) - Base View: `knr_vat_applied` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2.Prod_Royalty_Accounting_Royalty_Accountin... #### Model: Label_Royalties **label_royalties** (Label Royalties) - Base View: `label_royalties` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Distro, Prod.Contract_Transaction_Stag... #### Model: MXM_Reports **mxm_report** (MXM Report) - Base View: `mxm_report` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD_KNR.MXM_REPORT **mxm_query** (mxm_query) - Base View: `mxm_query` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: New_Income_Summary **new_income_summary** (New Income Summary) - Base View: `new_income_summary` - View Type: Direct Table - Data Source: Unknown **new_income_summary_labels** (New Income Summary - Labels) - Base View: `new_income_summary_labels` - View Type: Direct Table - Data Source: Unknown **New_Income_Performers_Blanka** (New_Income_Performers_Blanka) - Base View: `New_Income_Performers_Blanka` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Nr, Prod.Contract_Transaction_Nr_Stagi... **New_Income_Summary_AWAL_NR** (New Income Summary AWAL_NR) - Base View: `New_Income_Summary_AWAL_NR` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Track_Artist, Prod.Accounting_Run... **New_Income_Summary_Test** (New Income Summary Test) - Base View: `New_Income_Summary_Test` - View Type: Derived Table - Data Source: Derived from: Prod.Stmt_Db_Sales_Nr, Prod.Vw_Abacus_Fact_Sales_Nr_V3, Prod_Royal... **New_Income_Summary_Labels_Test** (New Income Summary Labels Test) - Base View: `New_Income_Summary_Labels_Test` - View Type: Direct Table - Data Source: Unknown #### Model: Ownership_OA **ownership_OA_full_delivery_history** (OA Full Collections Delivery History) - Base View: `ownership_OA_full_delivery_history` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A... #### Model: Performer_Royalties **performer_royalties** (Performer Royalties) - Base View: `performer_royalties` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Nr, Prod.Contract_Transaction_Nr_Stagi... **performer_quarterly_report** (Performer Quarterly Report) - Base View: `performer_quarterly_report` - View Type: Derived Table - Data Source: Derived from: Prod.Nr_Contributor, Prod.Stmt_Db_Sales_Nr, Prod.Vw_Abacus_Fact_Sa... #### Model: Pre_Label_Prod_Applied_Adjustments **pre_label_prod_aa** (Pre & Label - Prod - Applied Adjustments) - Base View: `pre_label_prod_aa` - View Type: Derived Table - Data Source: Derived from: Prod_Royalty_Accounting_Royalty_Accounting.Account, Prod_Royalty_A... #### Model: Residency_and_Tax **residency_and_tax** (Residency And Tax) - Base View: `residency_and_tax` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **citizenship_and_residency** (Citizenship And Residency) - Base View: `citizenship_and_residency` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: Societies **historic_usd_societies** (historic_usd_societies) - Base View: `historic_usd_societies` - View Type: Derived Table - Data Source: Derived from: Awal_Sax.Sax, Sax.Exchange_Rates, Sax.Interested_Parties, Sax.Reco... **new_societies_usd** (new_societies_usd) - Base View: `new_societies_usd` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Nr, Prod.Contract_Transaction_Nr_Stagi... **new_societies_usd_labels** (new_societies_usd_labels) - Base View: `new_societies_usd_labels` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Track_Artist, Prod.Accounting_Run... #### Model: Societies_registrations **societies_registrations** (Societies Registrations) - Base View: `societies_registrations` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax **societies_registrations_graph** (societies_registrations_graph) - Base View: `societies_registrations_graph` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax #### Model: VAT_Applied **vat_applied** (VAT Applied) - Base View: `vat_applied` - View Type: Derived Table - Data Source: Derived from: Prod_Royalty_Accounting_Royalty_Accounting.Abacus_Event, Prod_Roya... #### Model: _NEW_abacus_fact_sales_nr_salesforce **vw_abacus_fact_sales_nr** (Transaction Country) - Base View: `vw_abacus_fact_sales_nr` - View Type: Direct Table - Data Source: Unknown #### Model: _NEW_chartmetric+ownership_content **chartmetric_airplay** (Chartmetric + Ownership Content) - Base View: `chartmetric_airplay` - View Type: Derived Table - Data Source: Derived from: Chartmetric.Raw_Data, Raw_Data.Acr_Channel, Raw_Data.Acr_Track, Ra... #### Model: _NEW_chartmetric+performer_content **chartmetric_airplay** (Chartmetric + Performer Content) - Base View: `chartmetric_airplay` - View Type: Derived Table - Data Source: Derived from: Chartmetric.Raw_Data, Raw_Data.Acr_Channel, Raw_Data.Acr_Track, Ra... #### Model: _NEW_chartmetric_airplay **chartmetric_airplay** (Chartmetric Airplay Analytics) - Base View: `chartmetric_airplay` - View Type: Derived Table - Data Source: Derived from: Chartmetric.Raw_Data, Raw_Data.Acr_Channel, Raw_Data.Acr_Track, Ra... #### Model: _NEW_chartmetric_itunes **chartmetric_itunes** (Chartmetric iTunes Performance) - Base View: `chartmetric_itunes` - View Type: Derived Table - Data Source: Derived from: Chartmetric.Raw_Data, Raw_Data.Itunes, Raw_Data.Itunes_Album, Raw_... #### Model: _NEW_chartmetric_new_releases **chartmetric_recordings** (Chartmetric - New Releases) - Base View: `chartmetric_recordings` - View Type: Derived Table - Data Source: Derived from: Chartmetric.Raw_Data, Raw_Data.Cm_Album, Raw_Data.Cm_Artist, Raw_D... #### Model: _NEW_chartmetric_spotify **chartmetric_spotify** (Chartmetric Spotify Performance) - Base View: `chartmetric_spotify` - View Type: Derived Table - Data Source: Derived from: Chartmetric.Raw_Data, Raw_Data.L_Spotify_Artist, Raw_Data.Spotify,... #### Model: _NEW_content_combined **nr_contribution** (NR Contributions All) - Base View: `nr_contribution` - View Type: Direct Table - Data Source: facts.prod.nr_contribution **nr_contribution_type** (NR Contribution Type All) - Base View: `nr_contribution_type` - View Type: Direct Table - Data Source: FACTS.PROD.NR_CONTRIBUTION_TYPE **nr_contributor** (NR Contributor All) - Base View: `nr_contributor` - View Type: Direct Table - Data Source: FACTS.PROD.NR_CONTRIBUTOR **nr_sound_recording_has_featured_artist_nr_participant** (NR Sound Recording Has Featured Artist NR Participant All) - Base View: `nr_sound_recording_has_featured_artist_nr_participant` - View Type: Direct Table - Data Source: FACTS.PROD.NR_SOUND_RECORDING_HAS_FEATURED_ARTIST_NR_PARTICIPANT **nr_sound_recording_has_primary_artist_nr_participant** (NR Sound Recording Has Primary Artist NR Participant All) - Base View: `nr_sound_recording_has_primary_artist_nr_participant` - View Type: Direct Table - Data Source: FACTS.PROD.NR_SOUND_RECORDING_HAS_PRIMARY_ARTIST_NR_PARTICIPANT **nr_contribution_contributed_to_nr_sound_recording** (NR Contribution Contributed to NR Sound Recording All) - Base View: `nr_contribution_contributed_to_nr_sound_recording` - View Type: Direct Table - Data Source: FACTS.PROD.NR_CONTRIBUTION_CONTRIBUTED_TO_NR_SOUND_RECORDING #### Model: _NEW_ownership_content **content_nr_ownership_track** (Rights & Catalog Management) - Base View: `content_nr_ownership_track` - View Type: Direct Table - Data Source: FACTS.PROD.NR_OWNERSHIP_TRACK #### Model: _NEW_ownership_delivery **order_items** (order_items) - Base View: `order_items` - View Type: Direct Table - Data Source: Unknown #### Model: _NEW_performer_content **performer_content** (Performance NR Contribution) - Base View: `performer_content` - View Type: Direct Table - Data Source: Unknown #### Model: _NEW_performer_content_salesforce **performer_salesforce_matrix** (Performer Content & Salesforce Matrix) - Base View: `performer_salesforce_matrix` - View Type: Direct Table - Data Source: Unknown #### Model: _NEW_performer_delivery **performance_delivery_claiming_order** (Performance Delivery Workflow) - Base View: `performance_delivery_claiming_order` - View Type: Direct Table - Data Source: ORCHARD_APP_REPORTING_V2.PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVE... #### Model: _NEW_performer_delivery_queue **performance_delivery_queue** (Performance Delivery Queue) - Base View: `performance_delivery_queue` - View Type: Direct Table - Data Source: ORCHARD_APP_REPORTING_V2.PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVE... #### Model: _NEW_salesforce_performer **performer_salesforce_contributor** (Performer Salesforce Contributor) - Base View: `performer_salesforce_contributor` - View Type: Direct Table - Data Source: BUSINESS_SYSTEMS_SALESFORCE_DATA.NR.CONTRIBUTOR_C #### Model: _NEW_salesforce_society **performer_salesforce_contributor** (Salesforce Performer Contributor & Society) - Base View: `performer_salesforce_contributor` - View Type: Direct Table - Data Source: BUSINESS_SYSTEMS_SALESFORCE_DATA.NR.CONTRIBUTOR_C #### Model: _NEW_sax_model **income_by_client_Roys_and_Roy_Adj** (Income by Client Roys and Roy Adj) - Base View: `income_by_client_Roys_and_Roy_Adj` - View Type: Direct Table - Data Source: Unknown **historic_generated_income_abacus_format** (Historic Generated Income (Abacus Format)) - Base View: `historic_generated_income_abacus_format` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod_Knr.Historic_Generated_Income_Summary_Account_Currency, I... **historic_gis_acc_ccy** (Historic GIS Account Currency) - Base View: `historic_gis_acc_ccy` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD_KNR.HISTORIC_GENERATED_INCOME_SUMMARY_ACCOUNT_CURRENCY **historic_gis_usd** (Historic GIS USD) - Base View: `historic_gis_usd` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD_KNR.HISTORIC_GENERATED_INCOME_SUMMARY_USD **all_rights_blocks** (All Rights Blocks) - Base View: `all_rights_blocks` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax **all_schedules** (All Schedules) - Base View: `all_schedules` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax **societies_registrations** (Societies Registrations) - Base View: `societies_registrations` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax **societies_registrations_graph** (Societies Registrations Graph) - Base View: `societies_registrations_graph` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax **citizenship_and_residency** (Citizenship and Residency) - Base View: `citizenship_and_residency` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **client_overview_full** (Client Overview Full) - Base View: `client_overview_full` - View Type: Derived Table - Data Source: Derived from: Sax.Agreement_Outgoing_Types, Sax.Agreement_Period_Length_Defs, Sa... **residency_and_tax** (Residency and Tax) - Base View: `residency_and_tax` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **nr_queries** (NR Queries) - Base View: `nr_queries` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Agreement_Outgoing_Types, Sax.Agreemen... **nr_queries_graphs** (NR Queries Graphs) - Base View: `nr_queries_graphs` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Agreement_Outgoing_Types, Sax.Agreemen... **nr_dupes** (NR Dupes) - Base View: `nr_dupes` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) **failed_exports** (Failed Exports) - Base View: `failed_exports` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Agreement_Outgoing_Types, Sax.Agreemen... **mxm_report** (MXM Report) - Base View: `mxm_report` - View Type: Direct Table - Data Source: INTELLIGENCE.DBT_PROD_KNR.MXM_REPORT **test_rlr** (Test RLR) - Base View: `test_rlr` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: _NEW_unified_income_summary_performer **unified_income_summary_performer** (Unified Income Summary - Performer) - Base View: `unified_income_summary_performer` - View Type: Derived Table - Data Source: Derived from: Dbt_Prod_Knr.Historic_Generated_Income_Summary_Account_Currency, D... #### Model: chartmetric **chartmetric_perf_content_income** (Chartmetric Performer Content Income) - Base View: `chartmetric_perf_content_income` - View Type: Direct Table - Data Source: intelligence.dbt_hstanhope_knr.chartmetric_perf_content_income **chartmetric_perf_marketshare** (Chartmetric Performer Market Share) - Base View: `chartmetric_perf_marketshare` - View Type: Derived Table - Data Source: Derived from: Dbt_Hstanhope_Knr.Chartmetric_Perf_Content_Income, Intelligence.Db... **chartmetric_top_n_tracks** (Top N Tracks with Market Share) - Base View: `chartmetric_top_n_tracks` - View Type: Derived Table - Data Source: Derived from: Dbt_Hstanhope_Knr.Chartmetric_Perf_Content_Income, Intelligence.Db... #### Model: chartmetric_marketshare **chartmetric_perf_marketshare** (Market Share) - Base View: `chartmetric_perf_marketshare` - View Type: Derived Table - Data Source: Derived from: Dbt_Hstanhope_Knr.Chartmetric_Perf_Content_Income, Intelligence.Db... #### Model: client_overview_full **client_overview_full** (Client Overview (Full)) - Base View: `client_overview_full` - View Type: Derived Table - Data Source: Derived from: Sax.Agreement_Outgoing_Types, Sax.Agreement_Period_Length_Defs, Sa... **Vendor_Emails** (Vendor Emails) - Base View: `Vendor_Emails` - View Type: Derived Table - Data Source: Derived from: Prod.Company_Brand, Prod.Company_Brand_Has_Label_Vendor, Prod.Has_... #### Model: labels_database **labels_database** (Labels Database) - Base View: `labels_database` - View Type: Derived Table - Data Source: Derived from: Dev_Engineering, Dev_Engineering.Rshield, Rshield.Knr_Data #### Model: nr_dupes **nr_dupes** (NR Dupes) - Base View: `nr_dupes` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) #### Model: nr_queries **nr_queries** (NR Queries) - Base View: `nr_queries` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Agreement_Outgoing_Types, Sax.Agreemen... **nr_queries_graphs** (nr_queries_graphs) - Base View: `nr_queries_graphs` - View Type: Derived Table - Data Source: Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Agreement_Outgoing_Types, Sax.Agreemen... #### Model: performer_salesforce **performer_salesforce_contributor** (Salesforce Contributor) - Base View: `performer_salesforce_contributor` - View Type: Direct Table - Data Source: BUSINESS_SYSTEMS_SALESFORCE_DATA.NR.CONTRIBUTOR_C **performer_salesforce_society** (Salesforce Society) - Base View: `performer_salesforce_society` - View Type: Direct Table - Data Source: BUSINESS_SYSTEMS_SALESFORCE_DATA.NR.SOCIETY_C **performer_salesforce_combined** (Salesforce Combined) - Base View: `performer_salesforce_combined` - View Type: Derived Table - Data Source: Derived from: Business_Systems_Salesforce_Data, Business_Systems_Salesforce_Data... #### Model: statement_email_recipients **int_dbt_prod_knr_statement_emails** (Statement Emails) - Base View: `int_dbt_prod_knr_statement_emails` - View Type: Direct Table - Data Source: intelligence.dbt_prod_knr.knr_account_payment_email_list #### Model: test_rlr **test_rlr** (test_rlr) - Base View: `test_rlr` - View Type: Derived Table - Data Source: Derived Table (Custom SQL) ## Impact Analysis Guide ### Making Changes Safely 1. **Before changing a database table:** - Check "Views by Data Source" section above - Identify all views that use the table - Review explores that depend on those views 2. **Before modifying a view:** - Check which models include the view - Review explores that use the view as base - Consider downstream reporting impact 3. **Before changing a model:** - Review all explores in the model - Check business usage of those explores - Coordinate with report consumers ### Complexity Indicators - **High Line Count Views**: Complex business logic, may need optimization - **Many Source Tables**: Complex joins, potential performance impact - **Multiple Dependencies**: Changes have wide impact, need careful testing