Load Data from Google Cloud Storage Buckets
You can use IMPORT and EXPORT commands to import and export data directly from Google Cloud Storage. Exasol identifies Google Cloud Storage as the source / destination by its URL.
Exasol currently supports virtually hosted cloud storage URLs such as, https://<bucket>.storage.googleapis.com.
Exasol doesn't support the path-style URLs (https://storage.googleapis.com/<bucket>).
Set Up Google Project
To use IMPORT and EXPORT commands with Google Cloud Storage, you need an HMAC key for the Google Project that is going to be used with the commands. For instructions on how to set up the project, see Google Documentation on Simple Migration.
Run CONNECTION Command
Exasol recommends you create a connection string.
CONNECTION Example
CREATE CONNECTION GCS_CONNECTION
TO 'https://testbucket.storage.googleapis.com'
USER '<Access ID>'
IDENTIFIED BY '<secret>';
Run IMPORT/EXPORT Command
To authenticate IMPORT and EXPORT commands, use a connection string.
Exasol doesn't support OAuth 2.0 authentication.
IMPORT Example
EXPORT Example