Load Data from Google Cloud Storage

This article 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 recognizes GCS as the source or destination based on the URL used with the IMPORT/EXPORT statement.

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 HMAC keys.

Create connection

We recommend that you always use CREATE CONNECTION to define a connection and authenticate using the connection object in IMPORT/EXPORT commands. Replace the connection name, URL, and authentication details with your own values.

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

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

OAuth 2.0 authentication is not supported.

Import or export data

Examples

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

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