How to load data into Snowflake from amazon S3 file using Diyotta?
How to load data into Snowflake from amazon S3 file using Diyotta?
- 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 ) ;