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

IMPORT INTO testtable FROM CSV AT GCS_CONNECTION
FILE 'testpath/test.csv';

EXPORT Example

EXPORT INTO testtable FROM CSV AT GCS_CONNECTION
FILE 'testpath/test.csv';