
TRUNCATE TABLE `dim_shipping_method`;
TRUNCATE TABLE `dim_salesrule`;
TRUNCATE TABLE `map_salesrule`;
TRUNCATE TABLE `dim_product`;
TRUNCATE TABLE `fact_order_item`;
TRUNCATE TABLE `fact_order_item_parent`;
TRUNCATE TABLE `fact_shipment_item`;
TRUNCATE TABLE `fact_shipment_item_parent`;
TRUNCATE TABLE `fact_invoice_item`;
TRUNCATE TABLE `fact_invoice_item_parent`;
TRUNCATE TABLE `fact_order_cancel_item`;
TRUNCATE TABLE `fact_order_cancel_item_parent`;
TRUNCATE TABLE `dim_customer_mini`;
TRUNCATE TABLE `dim_customer`;
TRUNCATE TABLE `dim_store`;
TRUNCATE TABLE `fact_order`;
TRUNCATE TABLE `fact_credit_memo_item`;
TRUNCATE TABLE `fact_credit_memo_item_parent`;
TRUNCATE TABLE `dim_shipping_address`;
TRUNCATE TABLE `fact_shipment`;
TRUNCATE TABLE `dim_billing_address`;
TRUNCATE TABLE `fact_invoice`;
TRUNCATE TABLE `fact_payment`;
TRUNCATE TABLE `dim_payment_method`;
TRUNCATE TABLE `fact_credit_memo`;
TRUNCATE TABLE `fact_order_cancel`;
TRUNCATE TABLE `dim_category`;
TRUNCATE TABLE `map_product_category`;
TRUNCATE TABLE `dim_attribute_option`;
TRUNCATE TABLE `dim_address_details`;
TRUNCATE TABLE `map_product_attribute`;
TRUNCATE TABLE `dim_order_date`;
TRUNCATE TABLE `dim_order_time`;
TRUNCATE TABLE `dim_invoice_date`;
TRUNCATE TABLE `dim_age`;
TRUNCATE TABLE `tmp_dim_category_by_column`;
TRUNCATE TABLE `fact_metadata`;
TRUNCATE TABLE `map_order_state`;
TRUNCATE TABLE `dim_order_state`;
TRUNCATE TABLE `dim_tax_rate`;
TRUNCATE TABLE `map_order_tax_rate`;
TRUNCATE TABLE `map_order_item_tax_rate`;
TRUNCATE TABLE `bim_dwh_orders_in_dataset`;

TRUNCATE TABLE `sn_dim_shipping_method`;
TRUNCATE TABLE `sn_dim_salesrule`;
TRUNCATE TABLE `sn_map_salesrule`;
TRUNCATE TABLE `sn_dim_product`;
TRUNCATE TABLE `sn_fact_order_item`;
TRUNCATE TABLE `sn_fact_order_item_parent`;
TRUNCATE TABLE `sn_fact_shipment_item`;
TRUNCATE TABLE `sn_fact_shipment_item_parent`;
TRUNCATE TABLE `sn_fact_invoice_item`;
TRUNCATE TABLE `sn_fact_invoice_item_parent`;
TRUNCATE TABLE `sn_fact_order_cancel_item`;
TRUNCATE TABLE `sn_fact_order_cancel_item_parent`;
TRUNCATE TABLE `sn_dim_customer_mini`;
TRUNCATE TABLE `sn_dim_customer`;
TRUNCATE TABLE `sn_dim_store`;
TRUNCATE TABLE `sn_fact_order`;
TRUNCATE TABLE `sn_fact_credit_memo_item`;
TRUNCATE TABLE `sn_fact_credit_memo_item_parent`;
TRUNCATE TABLE `sn_dim_shipping_address`;
TRUNCATE TABLE `sn_fact_shipment`;
TRUNCATE TABLE `sn_dim_billing_address`;
TRUNCATE TABLE `sn_fact_invoice`;
TRUNCATE TABLE `sn_fact_payment`;
TRUNCATE TABLE `sn_dim_payment_method`;
TRUNCATE TABLE `sn_fact_credit_memo`;
TRUNCATE TABLE `sn_fact_order_cancel`;
TRUNCATE TABLE `sn_dim_category`;
TRUNCATE TABLE `sn_map_product_category`;
TRUNCATE TABLE `sn_dim_attribute_option`;
TRUNCATE TABLE `sn_dim_address_details`;
TRUNCATE TABLE `sn_map_product_attribute`;
TRUNCATE TABLE `sn_dim_order_date`;
TRUNCATE TABLE `sn_dim_order_time`;
TRUNCATE TABLE `sn_dim_invoice_date`;
TRUNCATE TABLE `sn_dim_age`;
TRUNCATE TABLE `sn_fact_metadata`;
TRUNCATE TABLE `sn_map_order_state`;
TRUNCATE TABLE `sn_dim_order_state`;
TRUNCATE TABLE `sn_dim_tax_rate`;
TRUNCATE TABLE `sn_map_order_tax_rate`;
TRUNCATE TABLE `sn_map_order_item_tax_rate`;
TRUNCATE TABLE `fact_order_status_updates`;
TRUNCATE TABLE `sn_fact_order_status_updates`;
TRUNCATE TABLE `fact_comment`;
TRUNCATE TABLE `sn_fact_comment`;
TRUNCATE TABLE `bim_tmp_order_status_history_rank`;
TRUNCATE TABLE `dim_default_billing_address`;
TRUNCATE TABLE `sn_dim_default_billing_address`;
TRUNCATE TABLE `dim_default_shipping_address`;
TRUNCATE TABLE `sn_dim_default_shipping_address`;