yuniql
yuniql copied to clipboard
Use S3 storage as source of CSV bulk file for redshift
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;