Integromat
  • Back to website
Articles in this section
  • Formstack
  • Magento 2
  • Google Cloud Vision
  • ManyChat
  • Airtable
  • Bubble
  • Email (legacy)
  • Facebook Groups
  • Google Sheets (legacy)
  • HTTP
See more
  1. Integromat Support
  2. Apps
  3. Docs

Snowflake

Integromat Support Team Integromat Support Team Updated May 30, 2020 14:51

The Snowflake module enables you to execute SQL command in your Snowflake account.

Getting Started with Snowflake

Prerequisites

  • A Snowflake account

In order to use Snowflake with Integromat, it is necessary to have a Snowflake account. If you do not have one, you can create a Snowflake account at trial.snowflake.com.

The module dialog fields that are displayed in bold (in the Integromat scenario, not in this documentation article) are mandatory!

Connecting Snowflake to Integromat

To connect your Snowflake account to Integromat 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.com then 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.

2020-05-28_11_17_41-Worksheet_-_New_Worksheet.png

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

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

2020-05-28_11_36_09-Integration_Snowflake___Integromat.png

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)
Was this article helpful?
0 out of 0 found this helpful
Menu
  • Features
  • Apps & Services
  • Templates
  • Pricing
  • What's new
  • Use cases
  • Feature requests
Information
  • Privacy
  • Terms
  • FAQ
  • Help & Tutorials
  • Community
  • Academy
  • Find a partner
  • Blog
Cooperation
  • Developer platform
  • Affiliate Program
  • Become a partner
  • Schools and Universities
Company
  • About the company
  • We are hiring
  • Contact
Follow us
© 2021 Integromat by Celonis. All rights reserved. Integromat® is a registered trademark.
  • English