1 Answer
- Newest
- Most votes
- Most comments
0
LOAD DATA FROM S3 FILE 's3://bucket-name/path/to/file.csv'
INTO TABLE schema_name.table_name
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(start_year,start_month,start_year_mo,profile,term_length,load_zone,rate,meter_fee,supplier_id,product_id,curve_date,expires,annual_mwh_from,annual_mwh_to,market_id,iso_id,state,weather_zone,rate_class,sub_rate_class,por,sc,includes_grt,includes_congestion,grt_multiplier)
SET matrix_file_id = '02dc7f82-52ba-4843-be82-72f894d06e2d';
answered a year ago
Relevant content
asked 3 years ago
asked 5 years ago
- AWS OFFICIALUpdated a year ago
