COF-C03 Data Loading, Unloading, and Connectivity — All Questions With Answers

COPY INTO my_table
FROM @my_stage/data/
FILES = ('file1.csv', 'file2.csv')
FILE_FORMAT = (TYPE = CSV SKIP_HEADER = 1)
ON_ERROR = CONTINUE;

SELECT 
  $1:id::int, 
  $1:details:name::string, 
  $1:details:address:city::string 
FROM @my_stage/customers.json.gz
(FILE_FORMAT => 'my_json_format');

SELECT * FROM TABLE(INFORMATION_SCHEMA.COPY_HISTORY(
   TABLE_NAME => 'SALES_DATA',
   START_TIME => DATEADD(hours, -1, CURRENT_TIMESTAMP())
));

-- Result Row:
-- FILE_NAME: sales_oct_01.csv, STATUS: PARTIALLY_LOADED, ROW_COUNT: 500, ROW_ERRORS: 2

CREATE STAGE my_internal_stage
  FILE_FORMAT = (TYPE = 'CSV' FIELD_DELIMITER = '|' SKIP_HEADER = 1);

COPY INTO target_table
  FROM @my_internal_stage/data/
  FILE_FORMAT = (TYPE = 'CSV' FIELD_DELIMITER = ',');