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 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 use CREATE CONNECTION to define a connection and authenticate 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.