Snowflake
With Snowflake modules in Make, 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 Make
To establish the connection, you must:
Obtain your account details in Snowflake
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 Make.
Establish the connection with Snowflake in Make
To establish the connection in Make:
Log in to your Make account, add a Snowflake module to your scenario, 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 Scenarios
After connecting the app, you can perform the following actions:
Execute SQL