text: CREATE SCHEMA IF NOT EXISTS "tpcds_sf1000";
  CREATE EXTERNAL STORAGE "tpcds_sf1000"."sample_tpcds_qa_es" TYPE S3 ENDPOINT 'https://s3.us-west-2.amazonaws.com/' REGION 'us-west-2' IDENTITY '' CREDENTIAL '';
  CREATE EXTERNAL FORMAT IF NOT EXISTS "tpcds_sf1000"."sample_tpcds_qa_ef" TYPE CSV WITH (DELIMITER '|', ON_MISSING_FIELD 'SUPPLYNULL', ON_EXTRA_FIELD 'REMOVE');
  CREATE EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el" PATH 'yb-sampledata-d4f1c23ea7' EXTERNAL STORAGE "tpcds_sf1000"."sample_tpcds_qa_es" EXTERNAL FORMAT "tpcds_sf1000"."sample_tpcds_qa_ef";
  SET SEARCH_PATH TO "tpcds_sf1000";
  CREATE TABLE call_center
  (   
      cc_call_center_sk         bigint               not null,
      cc_call_center_id         char(16)              not null,
      cc_rec_start_date         date                          ,
      cc_rec_end_date           date                          ,
      cc_closed_date_sk         bigint                       ,
      cc_open_date_sk           bigint                       ,
      cc_name                   varchar(50)                   ,
      cc_class                  varchar(50)                   ,
      cc_employees              bigint                       ,
      cc_sq_ft                  bigint                       ,
      cc_hours                  char(20)                      ,
      cc_manager                varchar(40)                   ,
      cc_mkt_id                 bigint                       ,
      cc_mkt_class              char(50)                      ,
      cc_mkt_desc               varchar(100)                  ,
      cc_market_manager         varchar(40)                   ,
      cc_division               bigint                       ,
      cc_division_name          varchar(50)                   ,
      cc_company                bigint                       ,
      cc_company_name           char(50)                      ,
      cc_street_number          char(10)                      ,
      cc_street_name            varchar(60)                   ,
      cc_street_type            char(15)                      ,
      cc_suite_number           char(10)                      ,
      cc_city                   varchar(60)                   ,
      cc_county                 varchar(30)                   ,
      cc_state                  char(2)                       ,
      cc_zip                    char(10)                      ,
      cc_country                varchar(20)                   ,
      cc_gmt_offset             decimal(5,2)                  ,
      cc_tax_percentage         decimal(5,2)                  ,
      primary key (cc_call_center_sk)
  ) distribute replicate;
  
  CREATE TABLE catalog_page
  (   
      cp_catalog_page_sk        bigint               not null,
      cp_catalog_page_id        char(16)              not null,
      cp_start_date_sk          bigint                       ,
      cp_end_date_sk            bigint                       ,
      cp_department             varchar(50)                   ,
      cp_catalog_number         bigint                       ,
      cp_catalog_page_number    bigint                       ,
      cp_description            varchar(100)                  ,
      cp_type                   varchar(100)                  ,
      primary key (cp_catalog_page_sk)
  ) distribute replicate;
  
  CREATE TABLE catalog_returns
  (
      cr_returned_date_sk       bigint                       ,
      cr_returned_time_sk       bigint                       ,
      cr_item_sk                bigint               not null,
      cr_refunded_customer_sk   bigint                       ,
      cr_refunded_cdemo_sk      bigint                       ,
      cr_refunded_hdemo_sk      bigint                       ,
      cr_refunded_addr_sk       bigint                       ,
      cr_returning_customer_sk  bigint                       ,
      cr_returning_cdemo_sk     bigint                       ,
      cr_returning_hdemo_sk     bigint                       ,
      cr_returning_addr_sk      bigint                       ,
      cr_call_center_sk         bigint                       ,
      cr_catalog_page_sk        bigint                       ,
      cr_ship_mode_sk           bigint                       ,
      cr_warehouse_sk           bigint                       ,
      cr_reason_sk              bigint                       ,
      cr_order_number           bigint               not null,
      cr_return_quantity        bigint                       ,
      cr_return_amount          decimal(7,2)                  ,
      cr_return_tax             decimal(7,2)                  ,
      cr_return_amt_inc_tax     decimal(7,2)                  ,
      cr_fee                    decimal(7,2)                  ,
      cr_return_ship_cost       decimal(7,2)                  ,
      cr_refunded_cash          decimal(7,2)                  ,
      cr_reversed_charge        decimal(7,2)                  ,
      cr_store_credit           decimal(7,2)                  ,
      cr_net_loss               decimal(7,2)                  ,
      primary key (cr_item_sk, cr_order_number)
  ) distribute on (cr_returned_date_sk);
  
  CREATE TABLE catalog_sales
  (   
      cs_sold_date_sk           bigint                       ,
      cs_sold_time_sk           bigint                       ,
      cs_ship_date_sk           bigint                       ,
      cs_bill_customer_sk       bigint                       ,
      cs_bill_cdemo_sk          bigint                       ,
      cs_bill_hdemo_sk          bigint                       ,
      cs_bill_addr_sk           bigint                       ,
      cs_ship_customer_sk       bigint                       ,
      cs_ship_cdemo_sk          bigint                       ,
      cs_ship_hdemo_sk          bigint                       ,
      cs_ship_addr_sk           bigint                       ,
      cs_call_center_sk         bigint                       ,
      cs_catalog_page_sk        bigint                       ,
      cs_ship_mode_sk           bigint                       ,
      cs_warehouse_sk           bigint                       ,
      cs_item_sk                bigint               not null,
      cs_promo_sk               bigint                       ,
      cs_order_number           bigint               not null,
      cs_quantity               bigint                       ,
      cs_wholesale_cost         decimal(7,2)                  ,
      cs_list_price             decimal(7,2)                  ,
      cs_sales_price            decimal(7,2)                  ,
      cs_ext_discount_amt       decimal(7,2)                  ,
      cs_ext_sales_price        decimal(7,2)                  ,
      cs_ext_wholesale_cost     decimal(7,2)                  ,
      cs_ext_list_price         decimal(7,2)                  ,
      cs_ext_tax                decimal(7,2)                  ,
      cs_coupon_amt             decimal(7,2)                  ,
      cs_ext_ship_cost          decimal(7,2)                  ,
      cs_net_paid               decimal(7,2)                  ,
      cs_net_paid_inc_tax       decimal(7,2)                  ,
      cs_net_paid_inc_ship      decimal(7,2)                  ,
      cs_net_paid_inc_ship_tax  decimal(7,2)                  ,
      cs_net_profit             decimal(7,2)                  ,
      primary key (cs_item_sk, cs_order_number)
  ) distribute on (cs_sold_date_sk);
  
  CREATE TABLE customer_address
  (   
      ca_address_sk             bigint               not null,
      ca_address_id             char(16)              not null,
      ca_street_number          char(10)                      ,
      ca_street_name            varchar(60)                   ,
      ca_street_type            char(15)                      ,
      ca_suite_number           char(10)                      ,
      ca_city                   varchar(60)                   ,
      ca_county                 varchar(30)                   ,
      ca_state                  char(2)                       ,
      ca_zip                    char(10)                      ,
      ca_country                varchar(20)                   ,
      ca_gmt_offset             decimal(5,2)                  ,
      ca_location_type          char(20)                      ,
      primary key (ca_address_sk)
  ) distribute replicate;
  
  CREATE TABLE customer
  (   
      c_customer_sk             bigint               not null,
      c_customer_id             char(16)              not null,
      c_current_cdemo_sk        bigint                       ,
      c_current_hdemo_sk        bigint                       ,
      c_current_addr_sk         bigint                       ,
      c_first_shipto_date_sk    bigint                       ,
      c_first_sales_date_sk     bigint                       ,
      c_salutation              char(10)                      ,
      c_first_name              char(20)                      ,
      c_last_name               char(30)                      ,
      c_preferred_cust_flag     char(1)                       ,
      c_birth_day               bigint                       ,
      c_birth_month             bigint                       ,
      c_birth_year              bigint                       ,
      c_birth_country           varchar(20)                   ,
      c_login                   char(13)                      ,
      c_email_address           char(50)                      ,
      c_last_review_date        char(10)                      ,
      primary key (c_customer_sk)
  ) distribute on (c_current_cdemo_sk);
  
  CREATE TABLE customer_demographics
  (
      cd_demo_sk                bigint               not null,
      cd_gender                 char(1)                       ,
      cd_marital_status         char(1)                       ,
      cd_education_status       char(20)                      ,
      cd_purchase_estimate      bigint                       ,
      cd_credit_rating          char(10)                      ,
      cd_dep_count              bigint                       ,
      cd_dep_employed_count     bigint                       ,
      cd_dep_college_count      bigint                       ,
      primary key (cd_demo_sk)
  );
  
  CREATE TABLE date_dim
  (
      d_date_sk                 bigint               not null,
      d_date_id                 char(16)              not null,
      d_date                    date                          ,
      d_month_seq               bigint                       ,
      d_week_seq                bigint                       ,
      d_quarter_seq             bigint                       ,
      d_year                    bigint                       ,
      d_dow                     bigint                       ,
      d_moy                     bigint                       ,
      d_dom                     bigint                       ,
      d_qoy                     bigint                       ,
      d_fy_year                 bigint                       ,
      d_fy_quarter_seq          bigint                       ,
      d_fy_week_seq             bigint                       ,
      d_day_name                char(9)                       ,
      d_quarter_name            char(6)                       ,
      d_holiday                 char(1)                       ,
      d_weekend                 char(1)                       ,
      d_following_holiday       char(1)                       ,
      d_first_dom               bigint                       ,
      d_last_dom                bigint                       ,
      d_same_day_ly             bigint                       ,
      d_same_day_lq             bigint                       ,
      d_current_day             char(1)                       ,
      d_current_week            char(1)                       ,
      d_current_month           char(1)                       ,
      d_current_quarter         char(1)                       ,
      d_current_year            char(1)                       ,
      primary key (d_date_sk)
  ) distribute replicate;
  
  CREATE TABLE household_demographics
  (
      hd_demo_sk                bigint               not null,
      hd_income_band_sk         bigint                       ,
      hd_buy_potential          char(15)                      ,
      hd_dep_count              bigint                       ,
      hd_vehicle_count          bigint                       ,
      primary key (hd_demo_sk)
  ) distribute replicate;
  
  CREATE TABLE income_band
  (
      ib_income_band_sk         bigint               not null,
      ib_lower_bound            bigint                       ,
      ib_upper_bound            bigint                       ,
      primary key (ib_income_band_sk)
  ) distribute replicate;
  
  CREATE TABLE inventory
  (
      inv_date_sk               bigint               not null,
      inv_item_sk               bigint               not null,
      inv_warehouse_sk          bigint               not null,
      inv_quantity_on_hand      bigint                       ,
      primary key (inv_date_sk, inv_item_sk, inv_warehouse_sk)
  ) distribute on (inv_date_sk);
  
  CREATE TABLE item
  (
      i_item_sk                 bigint               not null,
      i_item_id                 char(16)              not null,
      i_rec_start_date          date                          ,
      i_rec_end_date            date                          ,
      i_item_desc               varchar(200)                  ,
      i_current_price           decimal(7,2)                  ,
      i_wholesale_cost          decimal(7,2)                  ,
      i_brand_id                bigint                       ,
      i_brand                   char(50)                      ,
      i_class_id                bigint                       ,
      i_class                   char(50)                      ,
      i_category_id             bigint                       ,
      i_category                char(50)                      ,
      i_manufact_id             bigint                       ,
      i_manufact                char(50)                      ,
      i_size                    char(20)                      ,
      i_formulation             char(20)                      ,
      i_color                   char(20)                      ,
      i_units                   char(10)                      ,
      i_container               char(10)                      ,
      i_manager_id              bigint                       ,
      i_product_name            char(50)                      ,
      primary key (i_item_sk)
  ) distribute replicate;
  
  CREATE TABLE promotion
  (
      p_promo_sk                bigint               not null,
      p_promo_id                char(16)              not null,
      p_start_date_sk           bigint                       ,
      p_end_date_sk             bigint                       ,
      p_item_sk                 bigint                       ,
      p_cost                    decimal(15,2)                 ,
      p_response_target         bigint                       ,
      p_promo_name              char(50)                      ,
      p_channel_dmail           char(1)                       ,
      p_channel_email           char(1)                       ,
      p_channel_catalog         char(1)                       ,
      p_channel_tv              char(1)                       ,
      p_channel_radio           char(1)                       ,
      p_channel_press           char(1)                       ,
      p_channel_event           char(1)                       ,
      p_channel_demo            char(1)                       ,
      p_channel_details         varchar(100)                  ,
      p_purpose                 char(15)                      ,
      p_discount_active         char(1)                       ,
      primary key (p_promo_sk)
  ) distribute replicate;
  
  CREATE TABLE reason
  (
      r_reason_sk               bigint               not null,
      r_reason_id               char(16)              not null,
      r_reason_desc             char(100)                     ,
      primary key (r_reason_sk)
  ) distribute replicate;
  
  CREATE TABLE ship_mode
  (
      sm_ship_mode_sk           bigint               not null,
      sm_ship_mode_id           char(16)              not null,
      sm_type                   char(30)                      ,
      sm_code                   char(10)                      ,
      sm_carrier                char(20)                      ,
      sm_contract               char(20)                      ,
      primary key (sm_ship_mode_sk)
  ) distribute replicate;
  
  CREATE TABLE store
  (
      s_store_sk                bigint               not null,
      s_store_id                char(16)              not null,
      s_rec_start_date          date                          ,
      s_rec_end_date            date                          ,
      s_closed_date_sk          bigint                       ,
      s_store_name              varchar(50)                   ,
      s_number_employees        bigint                       ,
      s_floor_space             bigint                       ,
      s_hours                   char(20)                      ,
      s_manager                 varchar(40)                   ,
      s_market_id               bigint                       ,
      s_geography_class         varchar(100)                  ,
      s_market_desc             varchar(100)                  ,
      s_market_manager          varchar(40)                   ,
      s_division_id             bigint                       ,
      s_division_name           varchar(50)                   ,
      s_company_id              bigint                       ,
      s_company_name            varchar(50)                   ,
      s_street_number           varchar(10)                   ,
      s_street_name             varchar(60)                   ,
      s_street_type             char(15)                      ,
      s_suite_number            char(10)                      ,
      s_city                    varchar(60)                   ,
      s_county                  varchar(30)                   ,
      s_state                   char(2)                       ,
      s_zip                     char(10)                      ,
      s_country                 varchar(20)                   ,
      s_gmt_offset              decimal(5,2)                  ,
      s_tax_precentage          decimal(5,2)                  ,
      primary key (s_store_sk)
  ) distribute replicate;
  
  CREATE TABLE store_returns
  (   
      sr_returned_date_sk       bigint                       ,
      sr_return_time_sk         bigint                       ,
      sr_item_sk                bigint               not null,
      sr_customer_sk            bigint                       ,
      sr_cdemo_sk               bigint                       ,
      sr_hdemo_sk               bigint                       ,
      sr_addr_sk                bigint                       ,
      sr_store_sk               bigint                       ,
      sr_reason_sk              bigint                       ,
      sr_ticket_number          bigint               not null,
      sr_return_quantity        bigint                       ,
      sr_return_amt             decimal(7,2)                  ,
      sr_return_tax             decimal(7,2)                  ,
      sr_return_amt_inc_tax     decimal(7,2)                  ,
      sr_fee                    decimal(7,2)                  ,
      sr_return_ship_cost       decimal(7,2)                  ,
      sr_refunded_cash          decimal(7,2)                  ,
      sr_reversed_charge        decimal(7,2)                  ,
      sr_store_credit           decimal(7,2)                  ,
      sr_net_loss               decimal(7,2)                  ,
      primary key (sr_item_sk, sr_ticket_number)
  ) distribute on (sr_returned_date_sk);
  
  CREATE TABLE store_sales
  (   
      ss_sold_date_sk           bigint                       ,
      ss_sold_time_sk           bigint                       ,
      ss_item_sk                bigint               not null,
      ss_customer_sk            bigint                       ,
      ss_cdemo_sk               bigint                       ,
      ss_hdemo_sk               bigint                       ,
      ss_addr_sk                bigint                       ,
      ss_store_sk               bigint                       ,
      ss_promo_sk               bigint                       ,
      ss_ticket_number          bigint               not null,
      ss_quantity               bigint                       ,
      ss_wholesale_cost         decimal(7,2)                  ,
      ss_list_price             decimal(7,2)                  ,
      ss_sales_price            decimal(7,2)                  ,
      ss_ext_discount_amt       decimal(7,2)                  ,
      ss_ext_sales_price        decimal(7,2)                  ,
      ss_ext_wholesale_cost     decimal(7,2)                  ,
      ss_ext_list_price         decimal(7,2)                  ,
      ss_ext_tax                decimal(7,2)                  ,
      ss_coupon_amt             decimal(7,2)                  ,
      ss_net_paid               decimal(7,2)                  ,
      ss_net_paid_inc_tax       decimal(7,2)                  ,
      ss_net_profit             decimal(7,2)                  ,
      primary key (ss_item_sk, ss_ticket_number)
  ) distribute on (ss_sold_date_sk);
  
  CREATE TABLE time_dim
  (
      t_time_sk                 bigint               not null,
      t_time_id                 char(16)              not null,
      t_time                    bigint                       ,
      t_hour                    bigint                       ,
      t_minute                  bigint                       ,
      t_second                  bigint                       ,
      t_am_pm                   char(2)                       ,
      t_shift                   char(20)                      ,
      t_sub_shift               char(20)                      ,
      t_meal_time               char(20)                      ,
      primary key (t_time_sk)
  ) distribute replicate;
  
  CREATE TABLE warehouse
  (   
      w_warehouse_sk            bigint               not null,
      w_warehouse_id            char(16)              not null,
      w_warehouse_name          varchar(20)                   ,
      w_warehouse_sq_ft         bigint                       ,
      w_street_number           char(10)                      ,
      w_street_name             varchar(60)                   ,
      w_street_type             char(15)                      ,
      w_suite_number            char(10)                      ,
      w_city                    varchar(60)                   ,
      w_county                  varchar(30)                   ,
      w_state                   char(2)                       ,
      w_zip                     char(10)                      ,
      w_country                 varchar(20)                   ,
      w_gmt_offset              decimal(5,2)                  ,
      primary key (w_warehouse_sk)
  ) distribute replicate;
  
  CREATE TABLE web_page
  (   
      wp_web_page_sk            bigint               not null,
      wp_web_page_id            char(16)              not null,
      wp_rec_start_date         date                          ,
      wp_rec_end_date           date                          ,
      wp_creation_date_sk       bigint                       ,
      wp_access_date_sk         bigint                       ,
      wp_autogen_flag           char(1)                       ,
      wp_customer_sk            bigint                       ,
      wp_url                    varchar(100)                  ,
      wp_type                   char(50)                      ,
      wp_char_count             bigint                       ,
      wp_link_count             bigint                       ,
      wp_image_count            bigint                       ,
      wp_max_ad_count           bigint                       ,
      primary key (wp_web_page_sk)
  ) distribute replicate;
  
  CREATE TABLE web_returns
  (   
      wr_returned_date_sk       bigint                       ,
      wr_returned_time_sk       bigint                       ,
      wr_item_sk                bigint               not null,
      wr_refunded_customer_sk   bigint                       ,
      wr_refunded_cdemo_sk      bigint                       ,
      wr_refunded_hdemo_sk      bigint                       ,
      wr_refunded_addr_sk       bigint                       ,
      wr_returning_customer_sk  bigint                       ,
      wr_returning_cdemo_sk     bigint                       ,
      wr_returning_hdemo_sk     bigint                       ,
      wr_returning_addr_sk      bigint                       ,
      wr_web_page_sk            bigint                       ,
      wr_reason_sk              bigint                       ,
      wr_order_number           bigint               not null,
      wr_return_quantity        bigint                       ,
      wr_return_amt             decimal(7,2)                  ,
      wr_return_tax             decimal(7,2)                  ,
      wr_return_amt_inc_tax     decimal(7,2)                  ,
      wr_fee                    decimal(7,2)                  ,
      wr_return_ship_cost       decimal(7,2)                  ,
      wr_refunded_cash          decimal(7,2)                  ,
      wr_reversed_charge        decimal(7,2)                  ,
      wr_account_credit         decimal(7,2)                  ,
      wr_net_loss               decimal(7,2)                  ,
      primary key (wr_item_sk, wr_order_number)
  ) distribute on (wr_returned_date_sk);
  
  CREATE TABLE web_sales
  (   
      ws_sold_date_sk           bigint                       ,
      ws_sold_time_sk           bigint                       ,
      ws_ship_date_sk           bigint                       ,
      ws_item_sk                bigint               not null,
      ws_bill_customer_sk       bigint                       ,
      ws_bill_cdemo_sk          bigint                       ,
      ws_bill_hdemo_sk          bigint                       ,
      ws_bill_addr_sk           bigint                       ,
      ws_ship_customer_sk       bigint                       ,
      ws_ship_cdemo_sk          bigint                       ,
      ws_ship_hdemo_sk          bigint                       ,
      ws_ship_addr_sk           bigint                       ,
      ws_web_page_sk            bigint                       ,
      ws_web_site_sk            bigint                       ,
      ws_ship_mode_sk           bigint                       ,
      ws_warehouse_sk           bigint                       ,
      ws_promo_sk               bigint                       ,
      ws_order_number           bigint               not null,
      ws_quantity               bigint                       ,
      ws_wholesale_cost         decimal(7,2)                  ,
      ws_list_price             decimal(7,2)                  ,
      ws_sales_price            decimal(7,2)                  ,
      ws_ext_discount_amt       decimal(7,2)                  ,
      ws_ext_sales_price        decimal(7,2)                  ,
      ws_ext_wholesale_cost     decimal(7,2)                  ,
      ws_ext_list_price         decimal(7,2)                  ,
      ws_ext_tax                decimal(7,2)                  ,
      ws_coupon_amt             decimal(7,2)                  ,
      ws_ext_ship_cost          decimal(7,2)                  ,
      ws_net_paid               decimal(7,2)                  ,
      ws_net_paid_inc_tax       decimal(7,2)                  ,
      ws_net_paid_inc_ship      decimal(7,2)                  ,
      ws_net_paid_inc_ship_tax  decimal(7,2)                  ,
      ws_net_profit             decimal(7,2)                  ,
      primary key (ws_item_sk, ws_order_number)
  ) distribute on (ws_sold_date_sk);
  
  CREATE table web_site
  (
      web_site_sk               bigint               not null,
      web_site_id               char(16)              not null,
      web_rec_start_date        date                          ,
      web_rec_end_date          date                          ,
      web_name                  varchar(50)                   ,
      web_open_date_sk          bigint                       ,
      web_close_date_sk         bigint                       ,
      web_class                 varchar(50)                   ,
      web_manager               varchar(40)                   ,
      web_mkt_id                bigint                       ,
      web_mkt_class             varchar(50)                   ,
      web_mkt_desc              varchar(100)                  ,
      web_market_manager        varchar(40)                   ,
      web_company_id            bigint                       ,
      web_company_name          char(50)                      ,
      web_street_number         char(10)                      ,
      web_street_name           varchar(60)                   ,
      web_street_type           char(15)                      ,
      web_suite_number          char(10)                      ,
      web_city                  varchar(60)                   ,
      web_county                varchar(30)                   ,
      web_state                 char(2)                       ,
      web_zip                   char(10)                      ,
      web_country               varchar(20)                   ,
      web_gmt_offset            decimal(5,2)                  ,
      web_tax_percentage        decimal(5,2)                  ,
      primary key (web_site_sk)
  ) distribute replicate;
  
  LOAD TABLE "tpcds_sf1000"."call_center" FROM ('tpcds-sf1000/call_center/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."catalog_page" FROM ('tpcds-sf1000/catalog_page/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."catalog_returns" FROM ('tpcds-sf1000/catalog_returns/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."catalog_sales" FROM ('tpcds-sf1000/catalog_sales/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."customer" FROM ('tpcds-sf1000/customer/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."customer_address" FROM ('tpcds-sf1000/customer_address/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."customer_demographics" FROM ('tpcds-sf1000/customer_demographics/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."date_dim" FROM ('tpcds-sf1000/date_dim/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."household_demographics" FROM ('tpcds-sf1000/household_demographics/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."income_band" FROM ('tpcds-sf1000/income_band/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."inventory" FROM ('tpcds-sf1000/inventory/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."item" FROM ('tpcds-sf1000/item/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."promotion" FROM ('tpcds-sf1000/promotion/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."reason" FROM ('tpcds-sf1000/reason/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."ship_mode" FROM ('tpcds-sf1000/ship_mode/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."store" FROM ('tpcds-sf1000/store/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."store_returns" FROM ('tpcds-sf1000/store_returns/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."store_sales" FROM ('tpcds-sf1000/store_sales/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."time_dim" FROM ('tpcds-sf1000/time_dim/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."warehouse" FROM ('tpcds-sf1000/warehouse/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."web_page" FROM ('tpcds-sf1000/web_page/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."web_returns" FROM ('tpcds-sf1000/web_returns/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."web_sales" FROM ('tpcds-sf1000/web_sales/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  LOAD TABLE "tpcds_sf1000"."web_site" FROM ('tpcds-sf1000/web_site/') EXTERNAL LOCATION "tpcds_sf1000"."sample_tpcds_qa_el";
  
  