Snowflake

Owned by Charles Bishop (Deactivated)
Last updated: Oct 22, 2018

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

All needed plug-ins come packaged with Datameer as of 7.1.6 and above. No additional database driver configuration is needed to connect to Snowflake.

If you are using a previous version of Datameer, contact your Datameer support representative for the following plug-ins.

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

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.