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

Name ↓SizeModified
⬆..📄update_us_physical_new_release_view_for_project_highlights.sql19.7 KB2026-07-13 03:27📄update_uk_physical_product_view_subaccount_id.sql4.7 KB2026-07-13 03:27📄update_staging_physical_product_rtd_ca_view_for_local_label_cd.sql116.8 KB2026-07-13 03:27📄update_physical_product_inventory_view_for_all_order_qt.sql4.2 KB2026-07-13 03:27📄update_ca_physical_retail_view_with_orders.sql35.2 KB2026-07-13 03:27📄update_ca_physical_product_view_with_orders_and_price.sql28.6 KB2026-07-13 03:27📄update-us_physical_retail_view-with_coops.sql14.4 KB2026-07-13 03:27📄update-us_physical_product_view-with-orch-pricing-and-12M-and-24M-sales.sql44.2 KB2026-07-13 03:27📄update-us_physical_product_view-with-coops.sql35.2 KB2026-07-13 03:27📄update-us_physical_product_view-based-on-us_physical_product.sql31.4 KB2026-07-13 03:27📄update-us_physical_product_view-based-on-RTD_view.sql39.9 KB2026-07-13 03:27📄update-staging_us_physical_retail_view-with-selling_company-table.sql44.8 KB2026-07-13 03:27📄update-staging_us_physical_retail_view-with-CAT-logic.sql44.9 KB2026-07-13 03:27📄update-staging_us_physical_retail_view-applying-selling-company-to-orders.sql44.6 KB2026-07-13 03:27📄update-staging_us_physical_product_view-with-physical_product_sap_inventroy_view.sql46.9 KB2026-07-13 03:27📄update-staging_us_physical_product_view-for-column-name-correction.sql46.7 KB2026-07-13 03:27📄update-staging_ca_physical_product_view-with-physical_product_sap_inventroy_view.sql30.6 KB2026-07-13 03:27📄Update-Pricing-Schema-on-Physical_Product_Metadata_View.sql18.4 KB2026-07-13 03:27📄update-ca_physical_retail_view-with-metadata_view.sql36.5 KB2026-07-13 03:27📄update-ca_physical_retail_view-applying_selling_company_to_orders.sql38.2 KB2026-07-13 03:27📄update-ca_physical_product_view_by_add__new_product_status_name.sql26.4 KB2026-07-13 03:27📄update-ca_physical_product_view-with-orch-pricing-and-12M-and-24M-sales.sql39.0 KB2026-07-13 03:27📄update-ca_physical_product_view-based-on-RTD_view.sql39.3 KB2026-07-13 03:27📄update-ca_physical_product_view-based-on-ca_physical_product.sql22.0 KB2026-07-13 03:27📄Update-Art_Relations-Schema-on-Physical_Product_Metadata_View.sql17.9 KB2026-07-13 03:27📄physical_product_metadata_view_label_map.sql17.4 KB2026-07-13 03:27📄PHYS-4705-create-eu_point_of_sale_by_product_view.sql4.1 KB2026-07-13 03:27📄PHYS-4705-create-eu_point_of_sale_by_product_country_view.sql4.3 KB2026-07-13 03:27📄PHYS-4705-create-eu_point_of_sale_by_country_view.sql1.6 KB2026-07-13 03:27📄PHYS-4656_move_uk_physical_product_view_to_orchard_app_reporting.sql4.9 KB2026-07-13 03:27📄PHYS-4325-add-track-sides-to-phys-new-release-view.sql17.6 KB2026-07-13 03:27📄PHYS-4324-update-us_physical_new_release_view-to-use-alooma-synced-db-orchard_app_reporting.sql17.2 KB2026-07-13 03:27📄PHYS-4284-update-bandsintown-url-new-release-view.sql17.6 KB2026-07-13 03:27📄PHYS-4213-update-uk_physical_product_view-upc-to-point-to-display_upc.sql4.9 KB2026-07-13 03:27📄PHYS-4211-update-bandsintown-url-on-us_physical_new_release_view.sql16.9 KB2026-07-13 03:27📄PHYS-3830-remove-deleted-products-from-us_physical_new_release_view.sql16.8 KB2026-07-13 03:27📄PHYS-3802-lock-into-US-for-us_physical_new_release_view-sales_goals-marketing-info-join.sql16.8 KB2026-07-13 03:27📄PHYS-3698-add-more-marketing-info-to-us_physical_new_release_view.sql16.0 KB2026-07-13 03:27📄PHYS-3651-add-placeholder_upc-to-us_physical_new_release_view.sql15.9 KB2026-07-13 03:27📄PHYS-3581-fix-query-fails-when-multiple-entries-for-site.sql16.2 KB2026-07-13 03:27📄PHYS-3419-fix-ordering-of-us_physical_new_release_view.sql16.1 KB2026-07-13 03:27📄PHYS-3402-update-us_physical_new_release_view-pricing.sql16.7 KB2026-07-13 03:27📄PHYS-3281-us_physical_new_release_view-use-vendor-company-else-name.sql17.2 KB2026-07-13 03:27📄PHYS-3189-fix-embargo_date-restriction-in-us_physical_new_release_view.sql17.1 KB2026-07-13 03:27📄PHYS-3016-update-us_physical_product_view-with-pricing-info.sql44.1 KB2026-07-13 03:27📄PHYS-2616-create-releases.theorchard.com-view.sql7.8 KB2026-07-13 03:27📄PHYS-2536-update_uk_physical_product_view.sql4.5 KB2026-07-13 03:27📄PHYS-2536-create-uk_physical_product_view.sql2.4 KB2026-07-13 03:27📄int1151-Update-Daily-Overstock-Caclulation-to-Prevent-Negative-12-and-24-Month-Shipments.sql40.3 KB2026-07-13 03:27📄int1151-Update-Daily-Overstock-Caclulation-to-Prevent-Negative-12-and-24-Month-Shipments-Canada.sql27.8 KB2026-07-13 03:27📄INT-744-Update-Physical_Product_Metadata_View_with_Orchad_App_Reporting_V2-and-Schema.sql19.5 KB2026-07-13 03:27📄INT-630-Create-SONY_MONTH_END_DATES_table_in_Sony_Internal.sql577 B2026-07-13 03:27📄INT-630-Create-HISTORICAL_PRODUCT_VIEW_MAX_DATE_V-in_Sony_Internal.sql702 B2026-07-13 03:27📄INT-460-Update-physical_product_sap_inventory_view-for-return_disp.sql6.1 KB2026-07-13 03:27📄INT-407-Add_LAST_3_MTH-columns-to-PHYSICAL_PRODUCT_SALES_RTD_VIEW.sql16.6 KB2026-07-13 03:27📄INT-405-Add-STD-CARTON_PACK_QT_column_to_Physical_Product_Metadata_View.sql18.8 KB2026-07-13 03:27📄INT-405-Add-LAST_3_MTH_and_STD_CARTON_PACK_QT_columns_to_US_PHYSICAL_PRODUCT_VIEW.sql12.3 KB2026-07-13 03:27📄INT-405-Add-LAST_3_MTH_and_STD_CARTON_PACK_QT_columns_to_US_PHYSICAL_PRODUCT.sql739 B2026-07-13 03:27📄INT-405-Add-LAST_3_MTH_and_STD_CARTON_PACK_QT_columns_to_STAGING_US_PHYSICAL_PRODUCT_VIEW.sql48.3 KB2026-07-13 03:27📄INT-405-Add-LAST_3_MTH_and_STD_CARTON_PACK_QT_columns_to_STAGING_CA_PHYSICAL_PRODUCT_VIEW.sql31.7 KB2026-07-13 03:27📄INT-405-Add-LAST_3_MTH_and_STD_CARTON_PACK_QT_columns_to_CA_PHYSICAL_PRODUCT_VIEW.sql13.4 KB2026-07-13 03:27📄INT-405-Add-LAST_3_MTH_and_STD_CARTON_PACK_QT_columns_to_CA_PHYSICAL_PRODUCT.sql957 B2026-07-13 03:27📄INT-405-add-LAST_3_MTH-columns-to-STAGING_PHYSICAL_PRODUCT_RTD_US_VIEW.sql137.4 KB2026-07-13 03:27📄INT-405-add-LAST_3_MTH-columns-to-STAGING_PHYSICAL_PRODUCT_RTD_CA_VIEW.sql136.6 KB2026-07-13 03:27📄INT-405-add-LAST_3_MTH-columns-to-PHYSICAL_PRODUCT_RTD.sql808 B2026-07-13 03:27📄INT-2818-CREATE-TASK-MONTHLY_INSERT_ABACUS_SETTLEMENT_HISTORY_TASK.sql1.7 KB2026-07-13 03:27📄INT-2818-CREATE-TASK-MONTHLY_INSERT_ABACUS_SETTLEMENT_FEED_HISTORY_TASK.sql1.5 KB2026-07-13 03:27📄INT-2818-CREATE-TASK-MONTHLY_INSERT_ABACUS_SETTLEMENT_FEED_BATCH_TASK.sql2.2 KB2026-07-13 03:27📄INT-2818-CREATE-TASK-ABACUS_SETTLEMENT_FEED_TRIGGER_STREAM_RESET_TASK.sql1.9 KB2026-07-13 03:27📄INT-2758-create-phy-audit-gds-campaign-tables-20260430.sql6.0 KB2026-07-13 03:27📄INT-2753-Recompile-STAGING_ABACUS_SETTLEMENT_CM_VIEW-to-add-2-SAP-Company-Codes.sql94.4 KB2026-07-13 03:27📄INT-2753-Recompile-ABACUS_SETTLEMENT_FEED_CM_VIEW-to-add-SAP-Company-Codes-20260421.sql66.4 KB2026-07-13 03:27📄INT-2730_Create_a_new_View_named_RED_TABLE_DATA_VIEW.sql1.0 KB2026-07-13 03:27📄INT-2729-Add-3-new-Columns-to-RED_TABLE-and-STAGING_RED_TABLE.sql1.7 KB2026-07-13 03:27📄INT-2723_Grant_CRUD_to_TIA_for_SONY_INTERNAL_RED_TABLES.sql752 B2026-07-13 03:27📄INT-2715_Create_RED_Tables_in_SONY_INTERNAL.sql1.6 KB2026-07-13 03:27📄INT-2715-Create-RED_TABLE_AUDIT_TRAIL-with-Incremental-AUDIT_ID.sql829 B2026-07-13 03:27📄INT-2713_ORCHARD_DMS_TO_TCODE_ALL_PRIVILEGE_TO_ROLE_TIA_V2.sql566 B2026-07-13 03:27📄INT-2713_Create_Task_REFRESH_RED_TABLE_FROM_PROD.sql17.3 KB2026-07-13 03:27📄INT-2713_Create_Table_REFRESH_RED_TABLE_LOG.sql652 B2026-07-13 03:27📄INT-2691-Assign-Unallocated-Contract-IDs-based-on-Company-Brand-Name-Map-Setup-for-FOUNDATION-MEDIA-20260402.sql96.9 KB2026-07-13 03:27📄INT-2684-Recompile-ABACUS_SETTLEMENT_FEED_TRIGGER_VIEW-20260316.sql2.3 KB2026-07-13 03:27📄INT-2663-Recompile-STAGING_ABACUS_SETTLEMENT_CM_VIEW-for-new-GRPS-20260326.sql94.1 KB2026-07-13 03:27📄INT-2588_STARS_Manual_Product_Mapping_Feed_Task_adjust_to_daily_from_weekly.sql1.4 KB2026-07-13 03:27📄INT-2588_STARS_Manual_Product_Mapping_Feed_S3_ingestion_TASK.sql5.2 KB2026-07-13 03:27📄INT-2543_Create_SMART_Table_in_SONY_INTERNAL_database_V2_SFbased.sql29.5 KB2026-07-13 03:27📄INT-2543_Create_SMART_Table_in_SONY_INTERNAL_database_Addendum.sql2.6 KB2026-07-13 03:27📄INT-2512-Grant-CRUD-to-TECH_INTEGRATIONS_ADMIN-to-abacus_settlement_feed_trigger.sql641 B2026-07-13 03:27📄INT-247-create-CDSUS-ARTICLE-tables_rebase.sql7.4 KB2026-07-13 03:27📄INT-2414-Fix_Wrong_Subgenre_in_Workstation_Physical_Analytics_V2.sql12.5 KB2026-07-13 03:27📄INT-2384-Recompile-STAGING_ABACUS_SETTLEMENT_FEED_CM_VIEW-for-COMPANY_BRAND_NAME-20250818.sql65.7 KB2026-07-13 03:27📄INT-2384-Recompile-STAGING_ABACUS_SETTLEMENT_CM_VIEW-for-COMPANY_BRAND_NAME-20250818.sql93.5 KB2026-07-13 03:27📄INT-2384-Recompile-ABACUS_SETTLEMENT_FEED_CM_VIEW-for-COMPANY_BRAND_NAME-20250818.sql2.0 KB2026-07-13 03:27📄INT-2384-Add-the-new-column-COMPANY_BARND_NAME-to-2-ABACUS_SETTLEMENT_tables.sql671 B2026-07-13 03:27📄INT-2292-Add-2-new-OWNERSHIP-and-GROSS_NET-columns-to-ABACUS_SETTLEMENT_HISTORY-table.sql792 B2026-07-13 03:27📄INT-2218-Recompile-STAGING_ABACUS_SETTLEMENT_FEED_CM_VIEW-20250729.sql65.3 KB2026-07-13 03:27📄INT-2218-Recompile-STAGING_ABACUS_SETTLEMENT_FEED_CM_VIEW-20250617.sql62.2 KB2026-07-13 03:27📄INT-2218-Recompile-STAGING_ABACUS_SETTLEMENT_CM_VIEW-20250729.sql92.3 KB2026-07-13 03:27📄INT-2218-Recompile-STAGING_ABACUS_SETTLEMENT_CM_VIEW-20250617.sql76.3 KB2026-07-13 03:27📄INT-2218-Recompile-ABACUS_SETTLEMENT_FEED_CM_VIEW-20250729.sql1.9 KB2026-07-13 03:27📄INT-2218-INT-2218-CREATE-ABACUS_SETTLEMENT_FEED_TRIGGER_TABLE_AND_VIEW.sql2.7 KB2026-07-13 03:27📄INT-2218-CREATE-STREAM-ABACUS_SETTLEMENT_FEED_TRIGGER_STREAM.sql618 B2026-07-13 03:27📄INT-2218-Create-STAGING_ABACUS_SETTLEMENT_FEED_CM_VIEW.sql61.6 KB2026-07-13 03:27📄INT-2218-Create-STAGING_ABACUS_SETTLEMENT_CM_VIEW-V3.sql73.1 KB2026-07-13 03:27📄INT-2218-Create-STAGING_ABACUS_SETTLEMENT_CM_VIEW-V2.sql72.9 KB2026-07-13 03:27📄INT-2218-Create-Snowflake-Table-ORCHARD_DMS_TO_TCODE.sql923 B2026-07-13 03:27📄INT-2218-Create-Snowflake-Table-ABACUS_SETTLEMENT_HISTORY.sql4.9 KB2026-07-13 03:27📄INT-2218-Create-Snowflake-Table-ABACUS_SETTLEMENT_FEED_HISTORY.sql5.2 KB2026-07-13 03:27📄INT-2218-Create-Snowflake-Table-ABACUS_SETTLEMENT_FEED_BATCH.sql788 B2026-07-13 03:27📄INT-2218-Create-SETTLEMENT_EXTRACT_FROM_ABACUS_SETTLEMENT_CM_BAL_VIEW.sql2.6 KB2026-07-13 03:27📄INT-2218-Create-ORCHARD_CURRENCY_EXCHANGE_RATE_VIEW.sql3.1 KB2026-07-13 03:27📄INT-2218-Create-ABACUS_SETTLEMENT_HISTORY_SUMMARY_CURRENT_VIEW.sql2.4 KB2026-07-13 03:27📄INT-2218-Create-ABACUS_SETTLEMENT_HISTORY_SUMMARY_CURRENT_VIEW-v2.sql2.5 KB2026-07-13 03:27📄INT-2218-Create-ABACUS_SETTLEMENT_FEED_CM_VIEW.sql1.8 KB2026-07-13 03:27📄INT-1998-Create-FIELD_MANAGER_VIEW.sql922 B2026-07-13 03:27📄INT-1633-Add-INVOICE_FILE_SUFFIX-to-ORCHARD_MONTHLY_SAP_AGGREGATE_FEED_HISTORY.sql747 B2026-07-13 03:27📄INT-1510-Modify-CA-Dist_Label-Subaccount-Logic-on-Phyiscal_Product_Metadata_View.sql20.5 KB2026-07-13 03:27📄INT-1325-Add-new-column-TRANS_SUBTYPE-to-ORCHARD_MONTHLY_SAP_AGGREGATE_FEED_HISTORY.sql405 B2026-07-13 03:27📄INT-1264-Update-Data-in-ORCHARD_MONTHLY_SAP_AGGREGATE_FEED_HISTORY-based-on-DEV-Table.sql473 B2026-07-13 03:27📄INT-1264-Create-ORCHARD_MONTHLY_SAP_AGGREGATE_FEED_HISTORY-Table.sql4.0 KB2026-07-13 03:27📄fix_sony_internal_table_ownership_2.sql3.2 KB2026-07-13 03:27📄fix_sony_internal_table_ownership.sql7.1 KB2026-07-13 03:27📄DS-3944_update_uk_physical_product_view.sql5.8 KB2026-07-13 03:27📄DS-1266_CREATE_eu_point_of_sale_by_product_view.sql433 B2026-07-13 03:27📄DS-1266_CREATE_eu_point_of_sale_by_product_country_view.sql465 B2026-07-13 03:27📄DS-1266_CREATE_eu_point_of_sale_by_country_view.sql433 B2026-07-13 03:27📄drop-product_status_from_ca_physical_retail_view.sql37.4 KB2026-07-13 03:27📄drop-product_status_from_ca_physical_product_view.sql26.3 KB2026-07-13 03:27📄DISTRO-4435-update_uk_physical_view_orch_app_report_v2.sql5.4 KB2026-07-13 03:27📄DISTRO-4222-update_us_physical_new_release_view_orch_app_report_v2.sql19.4 KB2026-07-13 03:27📄DIS-1096-update_us_physical_new_release_view_add_country_of_origin.sql19.9 KB2026-07-13 03:27📄create_view_us_physical_retail_view.sql24.9 KB2026-07-13 03:27📄create_view_staging_us_physical_retail_view.sql20.8 KB2026-07-13 03:27📄create_update_staging_physical_product_mtd_ca_view.sql3.5 KB2026-07-13 03:27📄create_table_us_physical_retail.sql1.5 KB2026-07-13 03:27📄create_staging_physical_product_mtd_us_view.sql1.8 KB2026-07-13 03:27📄create_staging_physical_product_mtd_ca_view.sql1.7 KB2026-07-13 03:27📄create_selling_company_table.sql1.3 KB2026-07-13 03:27📄create_selling_company_regular_sales_view.sql756 B2026-07-13 03:27📄create_sapca_profit_center_table.sql2.0 KB2026-07-13 03:27📄create_physical_product_sales_by_month_view.sql950 B2026-07-13 03:27📄create_physical_product_metadata_view.sql9.3 KB2026-07-13 03:27📄create_physical_product_inventory_view.sql1.8 KB2026-07-13 03:27📄create_physical_current_period_view.sql617 B2026-07-13 03:27📄create_physial_by_month.sql1.1 KB2026-07-13 03:27📄create_perpetual_inventory_tables.sql3.0 KB2026-07-13 03:27📄create_label_map_view.sql1.0 KB2026-07-13 03:27📄CREATE_FILE_FORMATE_cdsuscsvformat.sql347 B2026-07-13 03:27📄create-us_physical_product-table.sql4.8 KB2026-07-13 03:27📄create-staging_us_physical_product_view.sql21.2 KB2026-07-13 03:27📄create-staging_physical_product_rtd_us_view.sql52.7 KB2026-07-13 03:27📄create-staging_physical_product_rtd_ca_view2.sql51.3 KB2026-07-13 03:27📄create-staging_ca_physical_product_view.sql14.1 KB2026-07-13 03:27📄create-physical_product_sap_inventory_view.sql2.6 KB2026-07-13 03:27📄create-physical_product_sales_rtd_view.sql7.1 KB2026-07-13 03:27📄create-physical_product_rtd.sql8.7 KB2026-07-13 03:27📄create-coop_generic_product_metadata_view.sql1.5 KB2026-07-13 03:27📄create-coop_advertising_view.sql3.2 KB2026-07-13 03:27📄create-coop_advertising-table.sql2.5 KB2026-07-13 03:27📄create-ca_physical_product-table.sql5.2 KB2026-07-13 03:27📄change_physical_product_inventory_view_ca_key_from_article_to_selection.sql4.4 KB2026-07-13 03:27📄CCM-1570-update-us_physical_new_release_view-definition.sql20.7 KB2026-07-13 03:27📄CAT_748-tear-down-product-to-project.sql22.4 KB2026-07-13 03:27📄CAT-749-teardown-us-physical-new-release.sql22.0 KB2026-07-13 03:27📄CAT-748-update_us_physical_new_release_view_for_first_week.sql22.5 KB2026-07-13 03:27📄add_overstock_columns_to_staging_physical_product_rtd_us_view.sql120.9 KB2026-07-13 03:27📄add_overstock_columns_to_staging_physical_product_rtd_ca_view2.sql119.2 KB2026-07-13 03:27📄add_overstock_columns_to_sap_perptetual_inventory_tables.sql1.1 KB2026-07-13 03:27📄add_overstock_columns_to_ca_physical_product_view.sql27.9 KB2026-07-13 03:27📄add_open_scrap_to_inventory_tables.sql826 B2026-07-13 03:27📄add_open_scrap_column_to_physical_product_inventory_view.sql4.1 KB2026-07-13 03:27📄add_coop_to_physical_product_sales_by_month_view.sql4.6 KB2026-07-13 03:27📄add_cols_to_label_map_view.sql2.8 KB2026-07-13 03:27📄add-reporting_parent_no-to-coop_advertising.sql3.4 KB2026-07-13 03:27📄add-overstock-columns-to-us_physical_product_view.sql45.1 KB2026-07-13 03:27📄add-overstock-columns-to-physical_product_sales_rtd_view.sql15.6 KB2026-07-13 03:27📄add-overstock-columns-to-physical_product_rtd.sql505 B2026-07-13 03:27📄add-overstock-columns-to-physical_product_inventory_view.sql6.4 KB2026-07-13 03:27📄add-fin_label_mapping_flag-to-cdsca_product.sql607 B2026-07-13 03:27📄add-fin_label_mapping_flag-to-cdsca_billing_history.sql643 B2026-07-13 03:27📄add-deleted_product_in-to-coop_advertising.sql641 B2026-07-13 03:27📄add-columns-to-cdsus_current_period.sql828 B2026-07-13 03:27📄add-columns-to-cdsca_current_period.sql825 B2026-07-13 03:27📄add-columns-to-canada-open-orders-table.sql885 B2026-07-13 03:27