Import/Export from/to Amazon S3™ buckets

Details

Detail name Value
Changelog Number 1957
Type New Feature
Status Resolved
Fix Versions EXASolution 5.0.16
Resolution Date 2016-08-29

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:

  1. 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.
  2. 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';