text: create database if not exists ${DB};
  use ${DB};
  
  drop table if exists store_returns;
  
  create external table store_returns
  (
      sr_returned_date_sk       int,
      sr_return_time_sk         int,
      sr_item_sk                int,
      sr_customer_sk            int,
      sr_cdemo_sk               int,
      sr_hdemo_sk               int,
      sr_addr_sk                int,
      sr_store_sk               int,
      sr_reason_sk              int,
      sr_ticket_number          int,
      sr_return_quantity        int,
      sr_return_amt             float,
      sr_return_tax             float,
      sr_return_amt_inc_tax     float,
      sr_fee                    float,
      sr_return_ship_cost       float,
      sr_refunded_cash          float,
      sr_reversed_charge        float,
      sr_store_credit           float,
      sr_net_loss               float             
  )
  row format delimited fields terminated by '|' 
  location '${LOCATION}';
  