DROP TABLE IF EXISTS `dim_shipping_method`;
DROP TABLE IF EXISTS `dim_salesrule`;
DROP TABLE IF EXISTS `map_salesrule`;
DROP TABLE IF EXISTS `dim_product`;
DROP TABLE IF EXISTS `fact_order_item`;
DROP TABLE IF EXISTS `fact_order_item_parent`;
DROP TABLE IF EXISTS `fact_shipment_item`;
DROP TABLE IF EXISTS `fact_shipment_item_parent`;
DROP TABLE IF EXISTS `fact_invoice_item`;
DROP TABLE IF EXISTS `fact_invoice_item_parent`;
DROP TABLE IF EXISTS `fact_order_cancel_item`;
DROP TABLE IF EXISTS `fact_order_cancel_item_parent`;
DROP TABLE IF EXISTS `dim_customer_mini`;
DROP TABLE IF EXISTS `dim_customer`;
DROP TABLE IF EXISTS `dim_store`;
DROP TABLE IF EXISTS `fact_order`;
DROP TABLE IF EXISTS `fact_credit_memo_item`;
DROP TABLE IF EXISTS `fact_credit_memo_item_parent`;
DROP TABLE IF EXISTS `dim_shipping_address`;
DROP TABLE IF EXISTS `fact_shipment`;
DROP TABLE IF EXISTS `dim_billing_address`;
DROP TABLE IF EXISTS `fact_invoice`;
DROP TABLE IF EXISTS `fact_payment`;
DROP TABLE IF EXISTS `dim_payment_method`;
DROP TABLE IF EXISTS `fact_credit_memo`;
DROP TABLE IF EXISTS `fact_order_cancel`;
DROP TABLE IF EXISTS `dim_category`;
DROP TABLE IF EXISTS `map_product_category`;
DROP TABLE IF EXISTS `dim_attribute_option`;
DROP TABLE IF EXISTS `dim_address_details`;
DROP TABLE IF EXISTS `map_product_attribute`;
DROP TABLE IF EXISTS `dim_order_date`;
DROP TABLE IF EXISTS `dim_order_time`;
DROP TABLE IF EXISTS `dim_invoice_date`;
DROP TABLE IF EXISTS `dim_age`;
DROP TABLE IF EXISTS `tmp_dim_category_by_column`;
DROP TABLE IF EXISTS `fact_metadata`;
DROP TABLE IF EXISTS `map_order_state`;
DROP TABLE IF EXISTS `dim_order_state`;
DROP TABLE IF EXISTS `dim_tax_rate`;
DROP TABLE IF EXISTS `map_order_tax_rate`;
DROP TABLE IF EXISTS `map_order_item_tax_rate`;
DROP TABLE IF EXISTS `bim_dwh_orders_in_dataset`;
DROP TABLE IF EXISTS `sn_dim_shipping_method`;
DROP TABLE IF EXISTS `sn_dim_salesrule`;
DROP TABLE IF EXISTS `sn_map_salesrule`;
DROP TABLE IF EXISTS `sn_dim_product`;
DROP TABLE IF EXISTS `sn_fact_order_item`;
DROP TABLE IF EXISTS `sn_fact_order_item_parent`;
DROP TABLE IF EXISTS `sn_fact_shipment_item`;
DROP TABLE IF EXISTS `sn_fact_shipment_item_parent`;
DROP TABLE IF EXISTS `sn_fact_invoice_item`;
DROP TABLE IF EXISTS `sn_fact_invoice_item_parent`;
DROP TABLE IF EXISTS `sn_fact_order_cancel_item`;
DROP TABLE IF EXISTS `sn_fact_order_cancel_item_parent`;
DROP TABLE IF EXISTS `sn_dim_customer_mini`;
DROP TABLE IF EXISTS `sn_dim_customer`;
DROP TABLE IF EXISTS `sn_dim_store`;
DROP TABLE IF EXISTS `sn_fact_order`;
DROP TABLE IF EXISTS `sn_fact_credit_memo_item`;
DROP TABLE IF EXISTS `sn_fact_credit_memo_item_parent`;
DROP TABLE IF EXISTS `sn_dim_shipping_address`;
DROP TABLE IF EXISTS `sn_fact_shipment`;
DROP TABLE IF EXISTS `sn_dim_billing_address`;
DROP TABLE IF EXISTS `sn_fact_invoice`;
DROP TABLE IF EXISTS `sn_fact_payment`;
DROP TABLE IF EXISTS `sn_dim_payment_method`;
DROP TABLE IF EXISTS `sn_fact_credit_memo`;
DROP TABLE IF EXISTS `sn_fact_order_cancel`;
DROP TABLE IF EXISTS `sn_dim_category`;
DROP TABLE IF EXISTS `sn_map_product_category`;
DROP TABLE IF EXISTS `sn_dim_attribute_option`;
DROP TABLE IF EXISTS `sn_dim_address_details`;
DROP TABLE IF EXISTS `sn_map_product_attribute`;
DROP TABLE IF EXISTS `sn_dim_order_date`;
DROP TABLE IF EXISTS `sn_dim_order_time`;
DROP TABLE IF EXISTS `sn_dim_age`;
DROP TABLE IF EXISTS `sn_fact_metadata`;
DROP TABLE IF EXISTS `sn_map_order_state`;
DROP TABLE IF EXISTS `sn_dim_order_state`;
DROP TABLE IF EXISTS `sn_dim_tax_rate`;
DROP TABLE IF EXISTS `sn_map_order_tax_rate`;
DROP TABLE IF EXISTS `sn_map_order_item_tax_rate`;
DROP TABLE IF EXISTS `fact_order_status_updates`;
DROP TABLE IF EXISTS `sn_fact_order_status_updates`;
DROP TABLE IF EXISTS `fact_comment`;
DROP TABLE IF EXISTS `sn_fact_comment`;
DROP TABLE IF EXISTS `bim_tmp_order_status_history_rank`;
DROP TABLE IF EXISTS `bim_tmp_product_attribute_values_latest`;
DROP TABLE IF EXISTS `bim_stg_product_attribute_values_latest`;
DROP TABLE IF EXISTS `sn_dim_invoice_date`;
DROP TABLE IF EXISTS `dim_default_billing_address`;
DROP TABLE IF EXISTS `sn_dim_default_billing_address`;
DROP TABLE IF EXISTS `dim_default_shipping_address`;
DROP TABLE IF EXISTS `sn_dim_default_shipping_address`;