1 - Create an empty table named SalesFact_work that has the same schema as SalesFact. 2 - Switch the partition containing the stale data from SalesFact to SalesFact_Work. 3 - Drop the SalesFact_Work table. Reference: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-partition