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.

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.

Default 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.

Tip: You can enter a default database name here, then override the default database and schema or specify a table in your export or import.

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.

Authentication type: Choose either basic or key pair authentication.

• Basic: This authentication method sends Base64-encoded username and password values in the authentication request.
• Key pair: This authentication method requires, as a minimum, a 2048-bit RSA key pair. The key must be in the PEM format. Learn more about configuring keys.

Username (required): Enter the Username to connect to Snowflake. For example, DEV_QA.

Private key (required): Use this field to store the encrypted or unencrypted RSA private key used for authentication. The key must be in PEM format. Multiple layers of protection, including AES 256 encryption, are in place to keep your authentication key safe. When editing this connection, you must re-enter this value each time; it is stored only when the connection is saved and never displayed as text.
Key Pair Authentication & Key Pair Rotation

Private key passphrase (optional): Provide an optional passphrase. This is used to decrypt the Key field. Multiple layers of protection, including AES 256 encryption, are in place to keep your authentication key safe. When editing this connection, you must re-enter this value each time; it is stored only when the connection is saved and never displayed as text.

Default 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.

Tip: You can specify your default schema here, then override the default or use a specific schema in an export or import.

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.

Password (required): Enter the password to connect to Snowflake.

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).