version: 2 sources: - name: base_royalty_accounting database: royalty_accounting schema: prod tables: - name: ABACUS_FACT_SALES_UNIFIED_DBT - name: ACCOUNTING_RUN_RESULTS_DISTRO - name: ACCOUNTING_RUN_RESULTS_DISTRO_MECH - name: ACCOUNTING_RUN_RESULTS_DISTRO_MECH_STAGING - name: ACCOUNTING_RUN_RESULTS_DISTRO_STAGING - name: ACCOUNTING_RUN_RESULTS_NR - name: ACCOUNTING_RUN_RESULTS_NR_STAGING - name: ACCOUNT_STATEMENT_PERIODS_DBT - name: ADJUSTMENTS_BY_TYPE_DBT - name: CDC_SALES_FILE_DELIVERY_DIG_SALES_TESTFILE_ABACUS - name: CDC_SALES_FILE_DELIVERY_NR_SALES_TESTFILE_ABACUS - name: COMBINED_EXPENSES_BY_ARTIST_DBT - name: COMBINED_EXPENSES_BY_IMPRINT_DBT - name: COMBINED_EXPENSES_BY_SUBACCOUNT_DBT - name: COMBINED_EXPENSES_DBT - name: DENORM_CONTRACT_TERM_CONDITION_TRANSACTION_TYPES - name: EXPENSES_BY_IMPRINT_DBT - name: EXPENSES_BY_SUBACCOUNT_DBT - name: MANUFACTURED_UPCS - name: REVENUE_BY_STATEMENT_PERIOD_DBT - name: REVENUE_BY_SUBACCOUNT_DBT - name: COMBINED_PAYMENTS_DBT - name: CONTRACT_DENORMALIZED_NR - name: CONTRACT_TRANSACTION_DISTRO - name: LEDGER_SUMMARY_DBT - name: REVENUE_BY_TRACK_DBT - name: ROLLBACK_ACC_5015 - name: ROLLBACK_WAR_1844_REVENUE_BY_PRODUCT_DISTRO - name: VW_ABACUS_FACT_SALES_DISTRO_LOOKER - name: VW_ABACUS_FACT_SALES_DISTRO_STAGING_20230725 - name: COMBINED_ADVANCES_DBT - name: REVENUE_NR_DBT - name: ROLLBACK_ACC_6421_CONTRACT_TRANSACTION_NR_STAGING - name: ROLLBACK_STMT_DB_SALES_DISTRO_ROLLOVER_313 - name: SNAPSHOT_CONTRACT_TERM_CONDITION_COUNTRY - name: VW_ABACUS_ADJUSTMENTS_V2_20240822 - name: VW_ABACUS_BALANCES_LOOKER - name: VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD - name: VW_CONTRACT_DENORMALIZED_20240509 - name: META_TRACK_DBT - name: REVENUE_BY_ACTIVITY_MONTH_DBT - name: REVENUE_BY_RECORDING_DISTRO_DBT - name: SAX_AGREEMENT_DENORM - name: VW_ABACUS_ADJUSTMENTS_V2_20240501 - name: ROLLBACK_WAR_1844_REVENUE_BY_RECORDING_DISTRO - name: ROLLBACK_WAR_1844_REVENUE_BY_RECORDING_NR - name: ROLLBACK_WAR_1844_REVENUE_BY_TRANSACTION_TYPE - name: ROLLBACK_STMT_DB_SALES_DISTRO_BK_310_ROLLOVER_INT_2097 - name: STMT_DB_SALES_NR_TEMP - name: VW_ABACUS_BALANCES_LOOKER_20230508 - name: VW_ABACUS_FACT_SALES_DISTRO_V3_20250313 - name: VW_ABACUS_FACT_SALES_DISTRO_V3_20250210 - name: VW_DIM_ABACUS_ACCOUNT_20240131 - name: DENORM_CONTRACT_TERM_CONDITION_STORES - name: REVENUE_BY_IMPRINT_DBT - name: ROLLBACK_STMT_DB_SALES_DISTRO_BK_312_AND_311_ROLLOVER_INT_2121 - name: SAX_AGREEMENT_DENORM_20240308 - name: SEQUESTERED_PANDB_SALES_287 - name: VW_ABACUS_FACT_SALES_NR_V3_20240423 - name: VW_CONTRACT_TERM_CONDITION_STORES_HISTORY - name: SEQUESTERED_PANDB_SALES_288 - name: VW_ELIGIBLE_LEGACY_CONTRACT_MIGRATION - name: ACCOUNTING_RUN_RESULTS_PUBLISHING - name: CONTRACT_TRANSACTION_PUBLISHING - name: CONTRACT_TRANSACTION_STAGING - name: DATABASECHANGELOGLOCK - name: SAX_AGREEMENT_DENORM_BASE_20230908 - name: TRANSACTION_CORRECTION_DISTRO - name: CONTRACT_DENORMALIZED_NR_CONTRIB_ONLY - name: ROLLBACK_STMT_DB_SALES_DISTRO_STAGING_SPOTIFY_AND_TEST_P315 - name: CONTRACT_TRANSACTION_NR - name: SNAPSHOT_CONTRACT_TERM_CONDITION_STORE - name: STMT_DB_SALES_DISTRO_TEMP_OLD - name: VWM_CONTRACT - name: VW_ABACUS_ADJUSTMENTS_V2 - name: VW_DIM_ABACUS_ACCOUNT - name: DATABASECHANGELOG - name: REVENUE_BY_COUNTRY_DBT - name: ROLLBACK_ACC_4978 - name: VW_DIM_ABACUS_ACCOUNT_20250609 - name: ROLLBACK_STMT_DB_SALES_DISTRO_BK_313_ROLLOVER_INT_2097 - name: COMBINED_ADJUSTMENTS_BY_TYPE_DBT - name: CONTRACT_DENORMALIZED - name: PAYMENTS_DBT - name: REVENUE_BY_PRODUCT_DISTRO_DBT - name: SNAPSHOT_CONTRACT_PUBLISHING - name: SNAPSHOT_CONTRACT_TERM_CONDITION_TRANSACTION_TYPE - name: VW_ABACUS_BALANCES_LOOKER_20240603 - name: VW_ABACUS_BALANCES_STAGING_20250304 - name: DENORM_CONTRACT_TERM_CONDITION_COUNTRIES - name: DENORM_CONTRACT_TERM_CONDITION_PRODUCTS - name: FACT_SALE_PUBLISHING - name: REVENUE_BY_ARTIST_DBT - name: REVENUE_BY_STORE_DBT - name: ROLLBACK_ACC_5744_ACCOUNTING_RUN_RESULTS_NR - name: ROLLBACK_WAR_1844_REVENUE_BY_STORE - name: SAX_AGREEMENT_DENORM_BASE_20240308 - name: CONTRACT_DENORMALIZED_DISTRO - name: SNAPSHOT_CONTRACT_NR - name: STMT_DB_PUBLISHING - name: STMT_DB_SALES_DISTRO - name: STMT_DB_SALES_DISTRO_TEMP - name: STMT_DB_SALES_NR_STAGING - name: VW_ABACUS_FACT_SALES_DISTRO_STAGING - name: VW_ABACUS_FACT_SALES_DISTRO_STAGING_20240304 - name: VW_ABACUS_FACT_SALES_NR_V3 - name: VW_ABACUS_UNALLOCATED_SALES_DISTRO_ACCOUNTING_PERIOD_20250110 - name: VW_CONTRACT_TERM_CONDITION_TRANSACTION_TYPES_HISTORY_20240322 - name: VW_DIM_ABACUS_CONTRACT_20241004 - name: REVENUE_BY_TRANSACTION_TYPE_DBT - name: SAX_AGREEMENT_DENORM_20230908 - name: SEQUESTERED_SALES_DISTRO - name: TRANSACTION_CORRECTION_NR - name: VW_ABACUS_FACT_SALES_DISTRO_V3 - name: VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD_20250529 - name: VW_CONTRACT_DENORMALIZED - name: VW_CONTRACT_TERM_CONDITION_COUNTRIES_HISTORY - name: VW_DIM_ABACUS_CONTRACT - name: VW_DIM_ABACUS_CONTRACT_20240205 - name: VW_DIM_ABACUS_CONTRACT_20241211 - name: WORKSHEET_CORRECTION_TRANSACTION_DISTRO - name: VW_DENORM_CONTRACT_TERM_CONDITION_STORES - name: SNAPSHOT_CONTRACT_MECHANICAL_DEDUCTION - name: SAX_MIGRATION_ACTIVE_RIGHTS_2022_10_18 - name: VW_ABACUS_FACT_SALES_DISTRO_STAGING_20230508 - name: VW_ABACUS_FACT_SALES_DISTRO_STAGING_20230522 - name: VW_ABACUS_UNALLOCATED_SALES_DISTRO_ACCOUNTING_PERIOD - name: VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD_20250110 - name: VW_DENORM_CONTRACT_TERM_CONDITION_COUNTRIES - name: VW_ABACUS_FACT_SALES_DISTRO_V2_20230724 - name: VW_DENORM_CONTRACT_TERM_CONDITION_PRODUCTS - name: REVENUE_BY_RECORDING_NR_DBT - name: SNAPSHOT_MECHANICAL_TRANSACTION - name: SNAPSHOT_TRANSACTION_PUBLISHING_EXCLUDE - name: TAP_PAYONEER_SYNC_SNAPSHOT - name: VW_ABACUS_BALANCES_STAGING_20231116 - name: VW_ABACUS_FACT_SALES_DISTRO_V2_20230522 - name: VW_ABACUS_FACT_SALES_DISTRO_V3_20240425 - name: VW_ABACUS_FACT_SALES_DISTRO_V3_20240612 - name: VW_ABACUS_FACT_SALES_NR - name: VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD_20230614 - name: VW_DIM_ABACUS_ACCOUNT_20230703 - name: VW_DIM_ABACUS_ACCOUNT_20231213 - name: VW_DIM_ABACUS_CONTRACT_20230519 - name: VW_CONTRACT_TERM_CONDITION_TRANSACTION_TYPES_HISTORY - name: STMT_DB_SALES_DISTRO_STAGING_OLD - name: CONTRACT_DBT - name: EXPENSES_BY_ARTIST_DBT - name: ROLLBACK_ACC_6087_CONTRACT_TRANSACTION_NR_DUPES_2 - name: CURRENCY_MAP - name: ROLLBACK_ACC_5744_ACCOUNTING_RUN_RESULTS_NR_STAGING - name: CONTRACT_TRANSACTION_NR_STAGING - name: ROLLBACK_ACC_5744_CONTRACT_TRANSACTION_NR - name: TEMP_ACC_6087_CONTRACT_TRANSACTION_NR_DUPES_2 - name: VW_ABACUS_ADJUSTMENTS - name: ROLLBACK_STMT_DB_SALES_DISTRO_BK_312_ROLLOVER_INT_2121 - name: SAX_TERRITORY_TO_ORCHARD_ISO - name: SEQUESTERED_TEST_SALES_307 - name: VW_ABACUS_ADJUSTMENTS_V2_20240618 - name: VW_ABACUS_BALANCES_LOOKER_20240627 - name: VW_ABACUS_CONTRACT_TERM - name: VW_ABACUS_FACT_SALES_DISTRO - name: VW_ABACUS_FACT_SALES_DISTRO_V3_20250207 - name: VW_ABACUS_FACT_SALES_PUBLISHING - name: VW_DIM_ABACUS_CONTRACT_20230508 - name: VW_UPC_TO_CONTRACT_MAPPING_20240607 - name: ROLLBACK_ACC_6087_CONTRACT_TRANSACTION_NR_DUPES_1 - name: ROLLBACK_WAR_1844_REVENUE_BY_COUNTRY - name: SAX_AGREEMENT_DENORM_BASE - name: SNAPSHOT_CONTRACT_TERM_SCHEDULE_NR - name: STMT_DB_SALES_DISTRO_OLD - name: TEMP_ACC_6087_CONTRACT_TRANSACTION_NR_DUPES_1 - name: VW_ABACUS_BALANCES_STAGING - name: VW_ABACUS_FACT_SALES_DISTRO_V3_20250211 - name: VW_ABACUS_FACT_SALES_NR_V3_20240229 - name: VW_ABACUS_FACT_SALES_NR_V3_20240612 - name: VW_ABACUS_UNALLOCATED_SALES_DISTRO_UNIQUE_DETAILS - name: WORKSHEET_CORRECTION_TRANSACTION_NR - name: SAX_RIGHT_TYPE_TO_ORCHARD_TRANSACTION_TYPE - name: COMBINED_ADJUSTMENTS_DBT - name: DIM_TRANSACTION_SUBTYPE - name: VW_ABACUS_EXPENSES - name: REVENUE_DISTRO_DBT - name: ROLLBACK_STMT_DB_SALES_DISTRO_BK_313_ROLLOVER_INT_2121 - name: EXPENSES_DBT - name: STMT_DB_SALES_DISTRO_STAGING - name: STMT_DB_SALES_DISTRO_TEMP_250507 - name: VW_ABACUS_BALANCES_STAGING_20231115 - name: VW_CONTRACT_HISTORY - name: VW_CONTRACT_TERM_CONDITION_HISTORY - name: VW_CONTRACT_TERM_HISTORY - name: VW_ABACUS_FACT_SALES_NR_V3_20231109 - name: VW_DENORM_CONTRACT_TERM_CONDITION_TRANSACTION_TYPES - name: VW_DIM_ABACUS_CONTRACT_20230510 - name: VW_ELIGIBLE_LEGACY_CONTRACT_MIGRATION_06062025 - name: ROLLBACK_STMT_DB_SALES_DISTRO_BK_311_ROLLOVER_INT_2097 - name: STMT_DB_SALES_DISTRO_STAGING_250507 - name: STMT_DB_SALES_NR - name: VW_ABACUS_FACT_SALES_DISTRO_V3_20250107 - name: VW_ABACUS_UNALLOCATED_SALES_DISTRO - name: VW_CONTRACT_TERM_SAX_RIGHT_BLOCK - name: VW_FACT_CONTRACT_HISTORY - name: WORKSTATION_FACT_SALES_UNIFIED_DBT - name: VW_ABACUS_FACT_SALES_DISTRO_20230522 - name: VW_DIM_ABACUS_CONTRACT_20231005 - name: VW_UPC_TO_CONTRACT_MAPPING_20240227 - name: STMT_DB_SALES_DISTRO_250507 - name: VW_ABACUS_BALANCES_LOOKER_20230825 - name: VW_CONTRACT_TERM_SAX_SCHEDULE - name: VW_DIM_ABACUS_CONTRACT_20250507 - name: ROLLBACK_ACC_5056 - name: VW_ABACUS_BALANCES_LOOKER_20240613 - name: VW_ABACUS_FACT_SALES_DISTRO_V3_20250219 - name: VW_ABACUS_FACT_SALES_NR_V3_20231211 - name: VW_CONTRACT_TERM_CONDITION_COUNTRIES_HISTORY_20240322 - name: VW_FACT_CONTRACT_HISTORY_20241016 - name: VW_UPC_TO_CONTRACT_MAPPING - name: WORKSTATION_SUMMARY_DBT - name: SNAPSHOT_MECHANICAL_TRANSACTION_DETAIL - name: VW_ABACUS_FACT_SALES_DISTRO_V2 - name: ROLLBACK_STMT_DB_SALES_DISTRO_BK_312_ROLLOVER_INT_2097 - name: VW_ABACUS_FACT_SALES_DISTRO_V2_20230508