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.
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.
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.
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.
Comments
Please sign in to leave a comment.