| Active |
|---|
| This application does not need additional settings. So you can make connection only by using your login credentials or by following the instructions below . |
With Snowflake modules in Boost.space Integrator, you can execute SQL commands, and return results in your Snowflake account.
To use the Snowflake modules, you must have a paid Snowflake account. You can create an account at snowflake.com. For subscription information, refer to the Snowflake Pricing page.
Refer to the Snowflake API documentation for a list of available endpoints.
To establish the connection, you must:
-
For the Snowflake user/password type of connection: Obtain your account details in Snowflake.
-
For the Snowflake key pair type of connection: Generate your private key in Snowflake.
To obtain your account name in your Snowflake account:
-
Log in to your Snowflake account. If you are logging in for the first time, use the email you have received from Snowflake.
-
At the bottom left, click on your generated account name next to the Snowflake icon.
-
Copy the Account name and Organization name values shown and store them in a safe place.
You will use these values in the Account field in Boost.space Integrator.
To generate your private key in your Snowflake account, refer to Snowflake documentation.
Note: You need to generate both public and private keys to successfully connect Snowflake in Boost.space Integrator. Your public key is associated with your Snowflake account, and your private key connects Snowflake to Boost.space Integrator. You may generate either an encrypted or unencrypted private key. If you generate an encrypted key, store your password in a safe place.
To establish the connection in Boost.space Integrator:
-
Log in to your Boost.space Integrator account, add a Snowflake module to your scenario, and click Create a connection.
-
In the Connection type, select the type of the connection:
-
Snowflake username/password:
-
Optional: In the Connection name field, enter a name for the connection.
-
In the Account field, enter your copied Account name and Organization name that you copied above in ORGANIZATION-ACCOUNT format. For example, if your Organization name is ABC, and account name is DEF, enter ABC-DEF.
-
In the Username and Password fields, enter your Snowflake account’s login credentials.
-
In the Database field, enter the name of the database for which you are going to execute commands. To see the names of the current databases, in the left sidebar, click Data > Databases.
-
-
Snowflake key pair:
-
Optional: In the Connection name field, enter a name for the connection.
-
In the Account field, enter your copied Account name and Organization name that you copied above in ORGANIZATION-ACCOUNT format. For example, if your Organization name is ABC, and account name is DEF, enter ABC-DEF.
-
In the Username field, enter your Snowflake account’s login username.
-
In the Private key field, enter your unencrypted private key and proceed to the next step. If you use an encrypted private key, follow the steps below:
-
Click Extract.
-
In the Extract field, select Private key.
-
Upload the private key that you generated above.
-
For encrypted private keys: In the Password field, enter the password for your private key that you generated above.
-
-
In the Database field, enter the name of the database for which you are going to execute commands. To see the names of the current databases, in the left sidebar, click Data > Databases.
-
-
-
Click Save.
-
If prompted, authenticate your account and confirm access.
You have successfully established the connection. You can now edit your scenario and add more Snowflake modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.