| 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 . |
With Snowflake modulesThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) in Boost.spaceCentralization and synchronization platform, where you can organize and manage your data. 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.
To establish the connection, you must:
To obtain your account name from 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 establish the connection in Boost.space Integrator:
-
Log in to your Boost.space Integrator account, add a Snowflake moduleThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) to your scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive., and click Create a connection.
-
Optional: In the Connection name field, enter a name for the connection.
-
In the Account field, enter your copied Account name and Organization name 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.
-
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)
-