Articles in this section

Set up a connection to Snowflake

The Snowflake data warehouse platform offers a cutting-edge solution for modern data management, tailored to meet the needs of today's data-driven organizations. It seamlessly integrates with the cloud, providing unparalleled flexibility, scalability, and performance. The Snowflake architecture allows you to effortlessly store, process, and analyze vast amounts of data from diverse sources, ensuring real-time insights and actionable intelligence. For more information, see Key Concepts & Architecture.

For information on data types supported by Snowflake's platform, see Data Types. Make sure that your account has the necessary access control for the export and import options you select.

snowflake-ready.png

This connector is certified under the Snowflake Ready technology validation program, which optimizes Celigo integrations with Snowflake, emphasizing functional and performance best practices

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.

createSnowflakeConnection.png

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.

SnowflakeAppDetails.png

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.

360065343272-image-3.png

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.

360065533791-image-4.png

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.

360065533811-image-5.png

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.

360065343312-image-6.png

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

Edit advanced Snowflake settings

Save the connection

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

  • Save: Click this button to save the connection.

  • Close: Click this button to exit the Create connection panel without saving your changes.

Take the following class to learn more about this topic:

Read more about this connection:

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.