Integrating with Snowflake

Overview

Snowflake is a data warehousing service that can support a high amount of workloads simultaneously. By integrating with Snowflake, users can access Snowflake's ability to store and share large amounts of data, and Decisions' library of automated Workflows, Steps, Reports, and more. 

Prerequisites

• Download and install the Snowflake ODBC driver from the Snowflake Documentation site.

Example

1. Navigate to Integrations > Databases and click CREATE CONNECTION. 
2. In the Database Integration dialog, define a desirable Connection Name. Then, from the Database Type dropdown, select ODBC.
3. Enter the connection string to connect to the Snowflake database. Click PICK OR CREATE ODBC DB TYPE and select Pick Existing.

   
   

   ActionScript

   Driver={SnowflakeDSIIDriver};Server=abc12345.dataCenter.snowflakecomputing.com;account=abc12345;Database=SNOWFLAKE_SAMPLE_DATA;Uid=snowflakeUserID;Pwd=snowflakePassword;schema=public;warehouse=COMPUTE_WH;role=SYSADMIN;

   ActionScript

   
   

   Driver={SnowflakeDSIIDriver};	Reference the ODBC driver by name
   Server=abc12345.dataCenter.snowflakecomputing.com; account=abc12345;	The account id and datacenter location provided by Snowflake.
   Database=SNOWFLAKE_SAMPLE_DATA;	The database name
   Uid=snowflakeUserID; Pwd=snowflakePassword;	Snowflake username and password
   schema=public; warehouse=COMPUTE_WH; role=SYSADMIN;	Data usage details

4. Navigate to ALL > DatabaseDefinitionWizard, select Snowflake, and click PICK.
   
   
   
   
5. Click TEST to test the database connection. If the Test Status is Success, click OK to save this Database Integration.

Communicate with Integrated Table

A Flow can be created to demonstrate how to communicate with the Integrated Database Table using the System generated steps in a Workflow process. The steps for the integrated table can be found under Integration > Database > [Integrated Database Name] > [Integrated Table Name] in the Flow Designer.