Skip to main content

Celonis Product Documentation

Snowflake

With Snowflake modules in Celonis platform, 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 Celonis platform

To establish the connection, you must:

Obtain your account details in Snowflake

To obtain your account name from your Snowflake account:

  1. Log in to your Snowflake account. If you are logging in for the first time, use the email you have received from Snowflake.

  2. At the bottom left, click on your generated account name next to the Snowflake icon.

  3. 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 Celonis platform.

Establish the connection with Snowflake in Celonis platform

To establish the connection in Celonis platform:

  1. Log in to your Celonis platform account, add a Snowflake module to your Action Flow, and click Create a connection.

  2. Optional: In the Connection name field, enter a name for the connection.

  3. 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.

  4. In the Username and Password fields, enter your Snowflake account's login credentials.

  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.

  6. Click Save.

  7. If prompted, authenticate your account and confirm access.

You have successfully established the connection. You can now edit your Action Flow and add more Snowflake modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.

Build Snowflake Action Flows

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

Actions
  • Execute SQL