Table of Contents

Snowflake

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…). More only by using your login credentials or by following the instructions below .

Snowflake

	Important
Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice. Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

Important

Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.

Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

The 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) More enables you to execute SQL commands in your Snowflake account.

Getting Started with Snowflake

Prerequisites

A Snowflake account

In order to use Snowflake with Boost.spaceCentralization and synchronization platform, where you can organize and manage your data. More IntegratorPart of the Boost.space system, where you can create your connections and automate your processes. More, it is necessary to have a Snowflake account. If you do not have one, you can create a Snowflake account at trial.snowflake.com.

Connect Snowflake to Boost.space Integrator

To connect your Snowflake account to Boost.space Integrator you need to fill the Create a connection dialog as follows:

Connection name	Enter the name for the connection.
Account	Enter the name of your Snowflake account. For example, if the URL of your Snowflake account is https://sx48547.eu-central-1.snowflakecomputing.comthen the name of your account is `sx48547.eu-central-1`.
Username	Enter your username. This can be found, for example, in the top-right corner of your account.
Password	Enter the password to your account.
Database	Specify the database you want to use after creating the connection. For example, `DEMO_DB`.
Schema	Enter the schema you want to use after creating the connection, if needed. For example, `PUBLIC`. The schema can be required for some SQL commands (e.g. `CREATE TABLE`).
Role	Enter the security role you want to use after creating the connection, if needed. To use a role, the role must have been granted to the userCan use the system on a limited basis based on the rights assigned by the admin. More. Only a single role can be active at a time for a user session.

Click the Continue button to establish the connection.

The connection has been established. You can proceed with setting up the module.

Actions

Execute SQL

Executes an SQL command in your Snowflake account.

Connection

Establish a connection to your Snowflake account.

SQL Command

Enter the SQL statement you want to execute in your Snowflake account.

Make sure you have set up the connection accordingly (schema, role)