Snowflake

Connect, import, and export to Snowflake, your cloud data warehouse.

Configuring Snowflake as a Connection

In order to import and export from Snowflake, you must first create a connection.

1. Click the + (plus) button and select Connection or right-click in the browser and select Create new > Connection.
2. From drop-down list, select  Snowflake  as the connection type. 
   
3. Enter the Snowflake credentials and AWS S3 credentials.
   
   
4. If required, add a description and click Save.
   

Importing Data from Snowflake

After configuring a connection to Snowflake, you can set up an import job to access the connection.

1. Click the + (plus) button and select Import Job or right-click in the browser and select Create new > Import job.
2. Click Select Connection and choose the name of your Snowflake connection (here - Snowflake_connector) then click Next.
   
3. The Snowflake database name is that set in the connector. 
   If not previously set from the connector, enter the Snowflake Warehouse name. 
   Select to import to a table or view and select the schema to be used.
   
4. A preview of the imported data is displayed. Review the schema and click Next.
   
5. Review the schedule, data retention, and advanced properties for the job.
   
6. Add a description and check the box if you would like the import to start immediately after saving.
   Click Save, and name the file.