Table of Contents

Snowflake
- Connect Snowflake to Boost.space Integrator
- Build Snowflake Scenarios

Active
This application does not need additional settings. So you can make connectionUnique, active service acces point to a network. There are different types of connections (API key, Oauth…). only by using your login credentials or by following the instructions below .

Snowflake

With Snowflake modulesa module is an application or tool designed to handle specific business functions, such as CRM, project management, or inventory. The system's modular architecture allows you to activate only the modules you need, enabling customization and scalability as your business requirements evolve. in Boost.spaceA platform that centralizes and synchronizes company data from internal and external sources, offering a suite of modules and addons for project management, CRM, data visualization, and more. Has many features to optimize your workflow! IntegratorPart of the Boost.space system, where you can create your connections and automate your processes., 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.

Connect Snowflake to Boost.space Integrator

To establish the connection, you must:

For the Snowflake userCan use the system on a limited basis based on the rights assigned by the admin./password type of connection: Obtain your account details in Snowflake.
For the Snowflake key pair type of connection: Generate your private key in Snowflake.
Establish the connection in Boost.space Integrator.

Obtain your account details 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.

Generate your private key in Snowflake

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.

Establish the connection with Snowflake in Boost.space Integrator

To establish the connection in Boost.space Integrator:

Log in to your Boost.space Integrator account, add a Snowflake modulea module is an application or tool designed to handle specific business functions, such as CRM, project management, or inventory. The system's modular architecture allows you to activate only the modules you need, enabling customization and scalability as your business requirements evolve. to your scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive., and click Create a connection.
In the Connection type, select the type of the connection:
- Snowflake username/password:
  1. Optional: In the Connection name field, enter a name for the connection.
  2. 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.
  3. In the Username and Password fields, enter your Snowflake account’s login credentials.
  4. 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:
  1. Optional: In the Connection name field, enter a name for the connection.
  2. 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.
  3. In the Username field, enter your Snowflake account’s login username.
  4. 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:
    1. Click Extract.
    2. In the Extract field, select Private key.
    3. Upload the private key that you generated above.
    4. For encrypted private keys: In the Password field, enter the password for your private key that you generated above.
  5. 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.

Build Snowflake ScenariosA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive.

After connecting the app, you can perform the following actions:

Actions

Execute SQL
- Reading from Snowflake (SELECT)
- Writing back to Snowflake (INSERT)