This article describes how to connect to Snowflake with Exasol and then load data.
Snowflake must be reachable from the Exasol system.
The user credentials in the connection must be valid.
Download the latest JDBC driver from the Snowflake website: Downloading / integrating the JDBC Driver.
To add the JDBC driver in Exasol, create a configuration file called settings.cfg
with the following settings:
Follow the procedure described in Add JDBC Driver to upload the settings.cfg
configuration and JDBC driver files to Exasol.
To create a connection, run the following statement. Replace the placeholders in the connection string and credentials with the corresponding values for your Snowflake account.
-- Create a connection to Snowflake
CREATE OR REPLACE CONNECTION SNOWFLAKE_CONNECTION TO
'jdbc:snowflake://<myorganization>-<myaccount>.snowflakecomputing.com/?warehouse=<my_compute_wh>&role=<my_role>&CLIENT_SESSION_KEEP_ALIVE=true'
USER '<sfuser>' IDENTIFIED BY '<sfpwd>';
To test the connection, run the following statement.
SELECT * FROM
(
IMPORT FROM jdbc AT SNOWFLAKE_CONNECTION
STATEMENT 'select ''Connection works!'' as connection_status'
);
Use IMPORT to load data from a table or SQL statement using the connection that you created.