Load Data from Google Cloud Storage

This section explains how to load data into Exasol from Google Cloud Storage buckets.

You can use the IMPORT and EXPORT commands to exchange data with files in Google Cloud Storage (GCS). Exasol automatically identifies GCS as the source or destination by the URL that is provided in the command.

Exasol only supports virtually hosted cloud storage URLs using the format https://<bucket>.storage.googleapis.com. Path-style URLs such as https://storage.googleapis.com/<bucket> are not supported.

Set up the Google project

To use the 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 more information, see Google Documentation on Simple Migration and HMAC keys.

Create a connection string

We recommend that you use CREATE CONNECTION to define a connection and authenticate in IMPORT/EXPORT commands.

Example

CREATE CONNECTION GCS_CONNECTION 
TO 'https://testbucket.storage.googleapis.com' 
USER '<Access ID>'
IDENTIFIED BY '<secret>';

Exasol does not support OAuth 2.0 authentication.

Run the IMPORT/EXPORT command

Examples

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

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