Page Comparison

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

...

• plugin-jdbc-v2
• plugin-s3
• plugin-snowflake

Configuring Snowflake as a Connection

In order to import and export from Snowflake, you must first To create a Snowflake 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. 
   Image Removed
3. Enter the Snowflake credentials and AWS S3 credentials.
   Image Removed
   Image Removed
4. If required, add a description and click Save.
   Image Removed

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.
   Image Removed
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.
   Image Removed
4. A preview of the imported data is displayed. Review the schema and click Next.
   Image Removed
5. Review the schedule, data retention, and advanced properties for the job.
   Image Removed
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.
   Image RemovedSelect "+" and then select "Connection" or right-click on a folder in the File Browser and select "Create New" and then "Connection". A 'New Connection' tab opens.
   Image Added or Image Added
7. Select "Snowflake" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens. 
   Image Added 
8. Enter the Snowflake URL and your Snowflake credentials. 
   Image Added
   
9. Chose the storage export environment. Mark either "AWS Simple Storage Service" or "Azure Blob Storage".
   INFO: The Data is first exported to S3 or Blob Storage and then will be moved to Snowflake. 
   INFO: For S3, enter the access key, access secret, your region and the bucket. 
   Image Added
   INFO: For Blob Storage, enter the account, container, credentials and SAS.
   Image Added
   
10. Confirm with "Next". The section 'Save' opens. 
    Image Added
11. If needed, enter a description and confirm with "Save". The dialog 'Save Connection' opens.
    Image Added
    
12. Select the name and storage location of the connection and confirm with "Save". The Snowflake connection is saved. 
    Image Added