Uploaded image for project: 'EXASOL Roadmap'
  1. EXASOL Roadmap
  2. EXASOL-1774

Import/Export from/to Amazon S3™ buckets

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: EXASolution 5.0.16
    • Component/s: EXAloader
    • Labels:
      None

      Attachments

        Issue Links

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

            Activity

              People

              • Assignee:
                CaptainEXA Captain EXASOL
                Reporter:
                CaptainEXA Captain EXASOL
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: