The Snowflake module enables you to execute SQL command in your Snowflake account.
Prerequisites
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.
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 |
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, The schema can be required for some SQL commands (e.g. |
Role |
Enter the security role you want to use after creating the connection, if needed.
|
Click the Continue button to establish the connection.
The connection has been established. You can proceed with setting up the module.
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)
|