text: drop table if exists item_text;
  create table item_text
  (
      i_item_sk                 int,
      i_item_id                 string,
      i_rec_start_date          string,
      i_rec_end_date            string,
      i_item_desc               string,
      i_current_price           double,
      i_wholesale_cost          double,
      i_brand_id                int,
      i_brand                   string,
      i_class_id                int,
      i_class                   string,
      i_category_id             int,
      i_category                string,
      i_manufact_id             int,
      i_manufact                string,
      i_size                    string,
      i_formulation             string,
      i_color                   string,
      i_units                   string,
      i_container               string,
      i_manager_id              int,
      i_product_name            string
  )
  USING csv
  OPTIONS(header "false", delimiter "|", path "${TPCDS_GENDATA_DIR}/item.dat")
  ;
  drop table if exists item;
  create table item
  using ${TPCDS_FORMAT}
  as (select * from item_text)
  ;
  drop table if exists item_text;
  