RE: How to load data into Snowflake from amazon S3 file using Diyotta?

How to load data into Snowflake from  amazon S3 file using Diyotta?

Fred Advanced User Asked on July 17, 2019 in Snowflake Process Platform.
Add Comment
1 Answers
  1. Diyotta using COPY command to upload amazon S3 file into Snowflake as below.

 

COPY  INTO DEV_DB.public.testdata_medium_DDS7752 from ‘S3://diyotta/QA_TEST/testdata_medium.dat’ CREDENTIALS =(AWS_KEY_ID=’$DI_PWD’ AWS_SECRET_KEY=’$DI_2PWD’)  ON_ERROR=’ABORT_STATEMENT’  PURGE=FALSE  RETURN_FAILED_ONLY=FALSE  ENFORCE_LENGTH=TRUE  TRUNCATECOLUMNS=FALSE  FORCE=TRUE  LOAD_UNCERTAIN_FILES=FALSE FILE_FORMAT=( type=’CSV’ COMPRESSION=’AUTO’ ERROR_ON_COLUMN_COUNT_MISMATCH=FALSE FIELD_DELIMITER=’|’ DATE_FORMAT=’AUTO’ TIME_FORMAT=’AUTO’  TIMESTAMP_FORMAT=’AUTO’  BINARY_FORMAT=’UTF-8′ NULL_IF=’NULL’  EMPTY_FIELD_AS_NULL=FALSE )  ;

Expert Answered on July 17, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.