Index of /database/snowflake/ROYALTY_ACCOUNTING/build/changelog/ddl

Name ↓SizeModified
⬆..📁view-2026-09-14 06:27📁materialized_view_as_table-2026-09-14 06:27📁dynamic_table-2026-09-14 06:27📄WAR-990-update-vw-revenue-by-recording-to-use-sales-v3-table.sql1.4 KB2026-07-13 03:27📄WAR-990-update-vw-revenue-by-product-to-use-sales-v3-table.sql1.5 KB2026-07-13 03:27📄WAR-990-update-vw-revenue-by-country-to-use-sales-v3-table.sql1.6 KB2026-07-13 03:27📄WAR-977-replace_revenue_by_country.sql1.5 KB2026-07-13 03:27📄WAR-976-replace_vw_revenue_by_country_with_country_code.sql1.9 KB2026-07-13 03:27📄WAR-959_gross_rev_nr_flat.sql1.3 KB2026-07-13 03:27📄WAR-959_gross_rev_by_recording.sql1.5 KB2026-07-13 03:27📄WAR-939-grant_revenue_by_country_tables.sql657 B2026-07-13 03:27📄WAR-939-create_revenue_by_country.sql664 B2026-07-13 03:27📄WAR-929-create_vw_revenue_by_country.sql1.5 KB2026-07-13 03:27📄WAR-879-drop_and_create_revenue_by_recording_nr_table.sql1.3 KB2026-07-13 03:27📄WAR-878-update_vw_revenue_by_recording_nr.sql1.4 KB2026-07-13 03:27📄WAR-873_update_revenue_by_product_flat.sql1.2 KB2026-07-13 03:27📄WAR-873_revenue_distro_flat_name_upc.sql1.2 KB2026-07-13 03:27📄WAR-872_update_fields_revenue_by_product_distro.sql1.4 KB2026-07-13 03:27📄WAR-872_more_columns_revenue_product_distro.sql1.5 KB2026-07-13 03:27📄WAR-844-create_revenue_by_recording_nr.sql987 B2026-07-13 03:27📄WAR-843-create_vw_revenue_by_recording_nr.sql1.2 KB2026-07-13 03:27📄WAR-819_create_revenue_by_product_distro.sql1.2 KB2026-07-13 03:27📄WAR-819-remove-distro-revenue-by-tables.sql837 B2026-07-13 03:27📄WAR-819-create_vw_revenue_by_product_distro.sql1.2 KB2026-07-13 03:27📄WAR-772-create-distro_rev_by_product_table.sql1.2 KB2026-07-13 03:27📄WAR-759-alter-vw_distro_rev_by_product.sql1.6 KB2026-07-13 03:27📄WAR-656_improve_nr_contributor_name.sql3.7 KB2026-07-13 03:27📄WAR-654-add-contract_term_condition_id-to-vw_abacus_fact_sales_nr.sql3.7 KB2026-07-13 03:27📄WAR-585_create_view_and_table_distro_rev_by_product_attempt_V2.sql2.6 KB2026-07-13 03:27📄WAR-585_create_new_view_and_table_DISTRO_REV_BY_TRACK.sql2.6 KB2026-07-13 03:27📄WAR-445-modify-vw-abacus-fact-sales-distro.sql4.4 KB2026-07-13 03:27📄WAR-305-add-contract-id-to-vw-abacus-fact-sales.sql6.6 KB2026-07-13 03:27📄WAR-1844_drop_revenue_views.sql10.3 KB2026-07-13 03:27📄WAR-1844_drop_old_revenue_tables.sql1.7 KB2026-07-13 03:27📄WAR-166-abacus_fact_sales_add_label_quantity.sql5.9 KB2026-07-13 03:27📄WAR-1158_change_revenue_by_store_to_cmm.sql2.1 KB2026-07-13 03:27📄WAR-1114-create_table_revenue_by_recording_distro_fix.sql1.3 KB2026-07-13 03:27📄WAR-1113-fix-update-joins-in-revenue-by-recording-distro.sql2.2 KB2026-07-13 03:27📄WAR-1113-create_vw_revenue_by_recording_distro.sql2.2 KB2026-07-13 03:27📄WAR-1066-create_revenue_by_store.sql1.2 KB2026-07-13 03:27📄WAR-1065-create_vw_revenue_by_store.sql1.7 KB2026-07-13 03:27📄WAR-1062_create_table_revenue_by_transaction_type.sql1.3 KB2026-07-13 03:27📄WAR-1061-create_vw_revenue_by_transaction_type.sql1.8 KB2026-07-13 03:27📄TAP-548-grant-access-to-tap-table.sql687 B2026-07-13 03:27📄TAP-548-create-payoneer-sync-snapshot.sql584 B2026-07-13 03:27📄TAP-1397-update-manufactured-upc.sql523 B2026-07-13 03:27📄TAP-1397-create-manufactured-upc-table.sql770 B2026-07-13 03:27📄SYS-13733-create-transaction-staging-table.sql1.1 KB2026-07-13 03:27📄MAINT-update-adjustments-tables.sql1.0 KB2026-07-13 03:27📄MAINT-staging-acct-run-results.sql1.7 KB2026-07-13 03:27📄MAINT-recreate-currency-map.sql3.9 KB2026-07-13 03:27📄MAINT-recreate-adjustments-tables.sql1.7 KB2026-07-13 03:27📄MAINT-nr-staging-permission-read-role.sql341 B2026-07-13 03:27📄MAINT-modify-adjustments-table.sql2.1 KB2026-07-13 03:27📄MAINT-fix-vw-abacus-contract-perms.sql2.4 KB2026-07-13 03:27📄MAINT-drop_time_columns_from_mech_staging.sql459 B2026-07-13 03:27📄MAINT-drop-acct-run-adjustment-id.sql981 B2026-07-13 03:27📄MAINT-create-currency-map.sql4.1 KB2026-07-13 03:27📄MAINT-create-accounting-run-results-staging.sql1.9 KB2026-07-13 03:27📄MAINT-contract-txn-permissions.sql677 B2026-07-13 03:27📄MAINT-alter-royalty-rate-decimal.sql570 B2026-07-13 03:27📄MAINT-add_underscores_to_more_column_names.sql1.9 KB2026-07-13 03:27📄MAINT-add_underscores_to_column_names.sql30.5 KB2026-07-13 03:27📄MAINT-add-run-id-contract-txn-stage.sql285 B2026-07-13 03:27📄MAINT-add-column-to-acct-run-results.sql918 B2026-07-13 03:27📄ACC-9220-update-precision-for-sales-nr-temp-and-final-tables.sql3.5 KB2026-07-13 03:27📄ACC-9220-drop-columns-from-nr-sales-and-temp-tables.sql2.5 KB2026-07-13 03:27📄ACC-9075-update_precision_stmt_db_sales_nr_staging.sql1.9 KB2026-07-13 03:27📄ACC-8900-1_snapshot_table.sql9.3 KB2026-07-13 03:27📄ACC-8718-snapshot-eligible-contracts-orchard-migration.sql482 B2026-07-13 03:27📄ACC-8704-create-transaction-correction-distro-mech.sql8.9 KB2026-07-13 03:27📄ACC-8559-create-snapshot-tables-for-orchard-migration.sql1.7 KB2026-07-13 03:27📄ACC-8558-insert-into-oa-migrated-abacus-contracts.sql50.8 KB2026-07-13 03:27📄ACC-8558-create-migrated-abacus-contracts.sql417 B2026-07-13 03:27📄ACC-8558-create-abacus-account-exclusion-list.sql17.5 KB2026-07-13 03:27📄ACC-8481-increase-precision-for-stmt-db-sales-distro-table-column.sql8.4 KB2026-07-13 03:27📄ACC-8477-drop-sales-file-delivery-streams-and-tasks.sql414 B2026-07-13 03:27📄ACC-8154-create-snapshot-contract-mechanical-deduction-table.sql1.5 KB2026-07-13 03:27📄ACC-8123-increase-precision-for-stmt-db-sales-distro-table-column.sql8.4 KB2026-07-13 03:27📄ACC-8066-add-track-id-to-snapshot.sql2.1 KB2026-07-13 03:27📄ACC-8044-create-abacus-sales-file-ingest-format.sql993 B2026-07-13 03:27📄ACC-8024-alter-mechanical-transaction-sequence.sql2.9 KB2026-07-13 03:27📄ACC-7948-1_vw_oa_contracts.sql194 B2026-07-13 03:27📄ACC-7754-accounting-run-results-distro-mech.sql5.2 KB2026-07-13 03:27📄ACC-7741-create-accounting-run-results-distro-mech-staging.sql5.2 KB2026-07-13 03:27📄ACC-7740-drop-mechanical-deduction-transaction-staging-table.sql1.3 KB2026-07-13 03:27📄ACC-7739-create-snapshot-tables-for-mechanical-transaction.sql4.0 KB2026-07-13 03:27📄ACC-7706-add-columns-to-distro-sales.sql1.1 KB2026-07-13 03:27📄ACC-6585-increase-varchar-length.sql1.6 KB2026-07-13 03:27📄ACC-6531-2_create_vw_fact_sale_pub.sql2.0 KB2026-07-13 03:27📄ACC-6531-1_create_pub_run_tables.sql5.7 KB2026-07-13 03:27📄ACC-6421-alter-contract-txn-nr-tables.sql929 B2026-07-13 03:27📄ACC-6411-modify-term-type-columns.sql1.2 KB2026-07-13 03:27📄ACC-6280-alter-snapshot-contract-nr-tables.sql10.0 KB2026-07-13 03:27📄ACC-6279-contract-denorm-schedule-id.sql12.9 KB2026-07-13 03:27📄ACC-5979-drop-deprecated-tables.sql973 B2026-07-13 03:27📄ACC-5741-add-contract-txn-id-to-accounting-run-results.sql19.8 KB2026-07-13 03:27📄ACC-5738-create-contract-txn-sequences.sql10.6 KB2026-07-13 03:27📄ACC-5701-vw-fact-sales-nr-corrections.sql6.2 KB2026-07-13 03:27📄ACC-5701-vw-fact-sales-distro-corrections.sql13.3 KB2026-07-13 03:27📄ACC-5696-transaction-correction-tables.sql6.7 KB2026-07-13 03:27📄ACC-5515-create-fact_sale_publishing.sql2.8 KB2026-07-13 03:27📄ACC-5473-change-vw_abacus_balances_looker-to-handle-event-target-change.sql20.2 KB2026-07-13 03:27📄ACC-5369-create-nr-contract-snapshot-tables.sql9.1 KB2026-07-13 03:27📄ACC-5369-create-contract-denorm-nr.sql6.8 KB2026-07-13 03:27📄ACC-5368-modify-vw-fact-sales-distro-to-add-sales_file_id.sql16.9 KB2026-07-13 03:27📄ACC-5368-modify-vw-fact-sales-distro-to-add-more-columns.sql34.4 KB2026-07-13 03:27📄ACC-5368-modify-vw-fact-sales-distro-looker-ignore-knr-label.sql8.5 KB2026-07-13 03:27📄ACC-5368-modify-vw-fact-sales-distro-looker-fix-row-dropping-issue.sql8.3 KB2026-07-13 03:27📄ACC-5368-create-vw-unallocated-sales-distro.sql4.4 KB2026-07-13 03:27📄ACC-5368-create-vw-fact-sales-distro-looker.sql8.2 KB2026-07-13 03:27📄ACC-5368-create-vw-abacus-balances-looker.sql9.3 KB2026-07-13 03:27📄ACC-5346-create-contract_transaction-final_tables.sql2.0 KB2026-07-13 03:27📄ACC-5320-modify-vw-fact-sales-distro-to-fix-join.sql16.8 KB2026-07-13 03:27📄ACC-5306-modify-vw-fact-sales-distro.sql8.3 KB2026-07-13 03:27📄ACC-5226-create-arr-distro-tables.sql8.5 KB2026-07-13 03:27📄ACC-5124-update-vw_abacus_fact_sales.sql8.2 KB2026-07-13 03:27📄ACC-5067-recreate-contract-denorm-distro.sql3.6 KB2026-07-13 03:27📄ACC-5067-create-contract-denorm-distro.sql3.2 KB2026-07-13 03:27📄ACC-5067-add-currency-and-dates-to-denorm-distro.sql3.6 KB2026-07-13 03:27📄ACC-4961-recreate-nr-fact-sales.sql6.5 KB2026-07-13 03:27📄ACC-4961-fix-column-names-nr-results.sql1.7 KB2026-07-13 03:27📄ACC-4887-create-abacus-csv-format.sql922 B2026-07-13 03:27📄ACC-4882-create-contract-transaction-nr-staging.sql1.1 KB2026-07-13 03:27📄ACC-4880-create-vw-abacus-fact-sales-nr.sql3.2 KB2026-07-13 03:27📄ACC-4830-create-accounting-run-results-nr.sql3.4 KB2026-07-13 03:27📄ACC-4829-create-nr-sales-stream.sql14.9 KB2026-07-13 03:27📄ACC-4827-create-stmt_db_sales_nr_temp-and-final.sql4.0 KB2026-07-13 03:27📄ACC-4826-create-stmt_db_sales_nr_staging.sql4.3 KB2026-07-13 03:27📄ACC-4759-modify-vw-abacus-fact-sales-distro.sql3.9 KB2026-07-13 03:27📄ACC-4759-create-vw-abacus-fact-sales-distro.sql3.9 KB2026-07-13 03:27📄ACC-4758-drop-deprecated-staging-tables.sql11.9 KB2026-07-13 03:27📄ACC-4748-create-stmt_db_sales_distro.sql2.2 KB2026-07-13 03:27📄ACC-4747-create-stmt_db_sales_distro_temp.sql2.2 KB2026-07-13 03:27📄ACC-4742-create-dim-transaction-subtype.sql1.6 KB2026-07-13 03:27📄ACC-4734-grant-select-on-cdc_sales_file_delivery_dig_sales_testfile_abacus.sql381 B2026-07-13 03:27📄ACC-4734-create-distribution-sales-stream.sql16.6 KB2026-07-13 03:27📄ACC-4653-create-stmt_db_sales_distro_staging.sql3.8 KB2026-07-13 03:27📄ACC-4647-modify-abacus-fact-sales.sql7.3 KB2026-07-13 03:27📄ACC-4647-add-wht-to-run-results.sql6.5 KB2026-07-13 03:27📄ACC-4602-drop-adjustment-tables.sql3.0 KB2026-07-13 03:27📄ACC-4592-add-txn-type-to-vw-abacus-fact-sales.sql6.1 KB2026-07-13 03:27📄ACC-4557-fix-vw-abacus-fact-sales.sql5.9 KB2026-07-13 03:27📄ACC-4484-recreate-result-tables.sql6.5 KB2026-07-13 03:27📄ACC-4243-unprocessed-sales-txn-id.sql627 B2026-07-13 03:27📄ACC-4243-alter-vw-abacus-fact-sales.sql5.8 KB2026-07-13 03:27📄ACC-3876_drop_mechanical_rate_ispc_id_column.sql663 B2026-07-13 03:27📄ACC-3761-alter-contract-txn-staging.sql635 B2026-07-13 03:27📄ACC-3760-modify-adjustment-result-tables.sql603 B2026-07-13 03:27📄ACC-3748_sync_staging_results_struct_to_results.sql594 B2026-07-13 03:27📄ACC-3733-alter-unprocessed-txns-stage.sql1.5 KB2026-07-13 03:27📄ACC-3648-add-contract-term-id-to-contract-transaction-staging.sql306 B2026-07-13 03:27📄ACC-3574_modify_vw_active_contract_term.sql11.2 KB2026-07-13 03:27📄ACC-3574_modify_vw_active_contract.sql2.1 KB2026-07-13 03:27📄ACC-3560-drop-staged-run-summary-table.sql158 B2026-07-13 03:27📄ACC-3553-create-kms-stage-qa.sql605 B2026-07-13 03:27📄ACC-3549-truncate-all-tables-in-ROYALTY_ACCOUNTING-QA.sql763 B2026-07-13 03:27📄ACC-3548-add-sales_file_id.sql326 B2026-07-13 03:27📄ACC-3536-deploy-existing-view-tables-to-prod-schema.sql14.3 KB2026-07-13 03:27📄ACC-3527-drop-txn_id-and-isrc_id.sql370 B2026-07-13 03:27📄ACC-3462-add-summary-columns.sql1.5 KB2026-07-13 03:27📄ACC-3405-update_to_match_output.sql6.0 KB2026-07-13 03:27📄ACC-3386_create_vw_active_contract_w_grants.sql2.7 KB2026-07-13 03:27📄ACC-3386_create_vw_active_contract_term_fix_names.sql10.0 KB2026-07-13 03:27📄ACC-3386_create_vw_active_contract_term.sql9.9 KB2026-07-13 03:27📄ACC-3386_create_vw_active_contract_fix_name-2.sql2.8 KB2026-07-13 03:27📄ACC-3386_add_sb_db_default_terms.sql10.3 KB2026-07-13 03:27📄ACC-3386_add_payee_metadata.sql3.0 KB2026-07-13 03:27📄ACC-3373-stage-unprocessed-txns.sql1.9 KB2026-07-13 03:27📄ACC-3278-drop-unused-stages-qa.sql190 B2026-07-13 03:27📄ACC-3278-drop-orch-app-reporting-stage-prod.sql113 B2026-07-13 03:27📄ACC-3278-create-txn-detail-parquet-stage-prod.sql721 B2026-07-13 03:27📄ACC-3278-create-stages-qa-2.sql1.4 KB2026-07-13 03:27📄ACC-3278-create-stages-prod.sql1.4 KB2026-07-13 03:27📄ACC-3278-create-orch-app-reporting-stage-prod.sql351 B2026-07-13 03:27📄ACC-3278-create-abacus-tsv-stage-qa.sql402 B2026-07-13 03:27📄ACC-3277-deploy-existing-tables-to-prod-schema.sql18.2 KB2026-07-13 03:27📄ACC-3260_create_royalties_run_result_staging.sql1.1 KB2026-07-13 03:27📄ACC-3255-create-s3-stage-for-run-summary.sql401 B2026-07-13 03:27📄ACC-3253_create_staged_run_summary.sql736 B2026-07-13 03:27📄ACC-3233-mech-permissions.sql725 B2026-07-13 03:27📄ACC-3233-create-mech-stage.sql1.0 KB2026-07-13 03:27📄ACC-3130-update-column-names.sql4.1 KB2026-07-13 03:27📄ACC-3130-add-missing-fields-to-staging.sql1.4 KB2026-07-13 03:27📄ACC-3130-add-missing-fields-to-results.sql1.6 KB2026-07-13 03:27📄ACC-3067-sync-acct-run-tables.sql1.8 KB2026-07-13 03:27📄ACC-3067-mech-admin-fields.sql1.1 KB2026-07-13 03:27📄ACC-2722-roles-and-grants.sql1.3 KB2026-07-13 03:27📄ACC-2706-create-accounting-run-results.sql1.1 KB2026-07-13 03:27📄ACC-2677-create-accounting-run-adjustments.sql801 B2026-07-13 03:27📄ACC-2676-grant-adjustment-tables.sql1.4 KB2026-07-13 03:27📄ACC-2596-add-payee-id-to-staging.sql289 B2026-07-13 03:27📄ACC-2410-create-txn-detail-stage.sql339 B2026-07-13 03:27📄ACC-2410-create-qa-stage.sql339 B2026-07-13 03:27📄ACC-10248-drop-dated-views.sql7.5 KB2026-07-13 03:27