Set up a connection to Snowflake

Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings. The Snowflake data platform is not built on any existing database technology or “big data” software platforms such as Hadoop. For more information, see Key Concepts & Architecture.

For information on data types supported by Snowflake's platform, see Data Types.

All Snowflake costs are based on usage of data storage, virtual warehouses (compute) resources, and cloud services. For more information, see System Usage & Billing.

Start establishing a connection to Snowflake in either of the following ways:

• From the Resources menu, select Connections. Then, click + Create connection at the top right.
  – or –
• While working in a new or existing integration, you can add an application to flow simply by clicking Add source or Add destination.

In the resulting Application list, click Snowflake.

The General section of the Create connection pane then asks you to name the new connection.

Be sure to provide a clear and distinguishable Name as soon as the connection is created. Throughout integrator.io imports and exports, you will have the option to choose this new connection, and a unique identifier will prove helpful later when selecting among a list of connections that you’ve created.

Edit required Snowflake settings

For information on Snowflake's access control framework, see Overview of Access Control.

At this point, you’re presented with a series of options for modifying the Snowflake authentication.

1. Account name (required): Enter the Account name for this account set up by the Snowflake server administrator. For example, celigo_partner is the account name, which can be obtained from the URL.

2. Database name (required): Enter the Snowflake database that you want to connect. For example, TEST_DB is available in the list, but you can also create a new one by clicking Create.

3. Warehouse name (required): Enter the Warehouse used for executing the compute process. For example, QA_WAREHOUSE is available in the list, but you can click Create to create a new warehouse. If you are using this connection for the Snowflake Data Warehouse quickstart integration template, verify that the Snowflake warehouse you select has Auto Resume set to Yes.

4. Schema (optional): Name of the schema that the connection will use. If the name is not provided, the connection will use the default schema defined in Snowflake for the user.
5. User Role (optional): Name of the roles to use in the connection. If the user role is not provided, the connection will use the default user role defined in Snowflake for the user.
6. Username (required): Enter the Username to connect to Snowflake. For example, DEV_QA.

7. Password (required): Enter the password to connect to Snowflake.
8. Borrow concurrency from (optional): Select another connection from the list....

9. Concurrency level (optional): Up to 25 allowed....

Test and save the connection

Once you have configured the Snowflake connection, select one of the following options:

• Save: Click this button to save the connection.
• Save & close: Click this button to save the connection and close the Create connection panel.
• Cancel: Click this button to exit connection creation without saving.
• Test connection: Click this button to test the connection. Commit the new connection so that it will be available to all integrations for your account (and applied to the current source or destination app, if you created it within a flow).