-
Type:
New Feature
-
Status: Resolved
-
Priority:
Normal
-
Resolution: Fixed
-
Fix Version/s: EXASolution 5.0.16
-
Component/s: EXAloader
-
Labels:None
- relates
-
EXASOL-1773 EXASOL for AWS™
-
- Resolved
-
-
SOL-594 Amazon S3 to EXASOL: Load many files from bucket into table in parallel
- Published
- mentioned in
IMPORT and EXPORT can now be used to read and write data directly from/to Amazon AWS S3 buckets. EXASolution automatically recognizes AWS S3 IMPORTs/EXPORTs based on the URL.
Note: EXASolution only supports virtual-hosted-style AWS S3 URLs (e.g., http://bucket.s3.amazonaws.com). Path-style URLs (e.g., http://s3.amazonaws.com/bucket) are not supported.
Authentication:
- To authenticate with a user/password, provide the AWS S3 access key ID in the USER field and the secret access key in the IDENTIFIED BY field.
- To authenticate with temporary credentials for EC2 IAM roles, leave the USER and IDENTIFIED BY fields empty.
Examples:
IMPORT INTO testtable FROM CSV AT 'https://testbucket.s3.amazonaws.com' USER '<key-ID>' IDENTIFIED BY '<secret-key>' -- user/password FILE 'testpath/test.csv'; -- temporary credentials for EC2 role EXPORT testtable INTO CSV AT 'https://testbucket.s3.amazonaws.com' FILE 'testpath/test.csv';