TRUNCATE `bim_dwh_orders_in_dataset`;

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