[EXASOL-1774] Import/Export from/to Amazon S3™ buckets Created: 08.07.2016  Updated: 09.12.2020  Resolved: 29.08.2016

Status: Resolved
Project: EXASOL Roadmap
Component/s: EXAloader
Fix Version/s: EXASolution 5.0.16

Type: New Feature Priority: Normal
Reporter: Captain EXASOL Assignee: Captain EXASOL
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Causing
Related
relates EXASOL-1773 EXASOL for AWS™ Resolved
relates SOL-594 Amazon S3 to EXASOL: Load many files ... Obsolete

 Description   

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';

Generated at Tue Sep 28 22:02:50 CEST 2021 using Jira 7.13.18#713018-sha1:e1230154f8ff8cc9272975bf568fc732e806fd68.