yuniql icon indicating copy to clipboard operation
yuniql copied to clipboard

Use S3 storage as source of CSV bulk file for redshift

Open rdagumampan opened this issue 4 years ago • 0 comments

Use S3 storage as source of CSV bulk file for redshift. The current build only uses local csv files but for large DW like Redshift, these baseline data might have been placed in a storage account such as S3 containers.

This sql can be part of a valid version

COPY table_name
FROM 's3://<your-bucket-name>/load/file_name.csv'
credentials 'aws_access_key_id=<Your-Access-Key-ID>;aws_secret_access_key=<Your-Secret-Access-Key>'
CSV;

rdagumampan avatar Jan 29 '21 10:01 rdagumampan