Snowflake
With the Snowflake app in you can execute SQL commands, and return results in your Snowflake account.
To use the Snowflake modules, you must have a paid Snowflake account. For subscription information, refer to the Snowflake Pricing page.
To establish the connection, you must:
To obtain your account name in 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 shown and store it in a safe place.
You will use these values in the Account field in .
To generate your private key in your Snowflake account, refer to Snowflake documentation.
Note: You need to generate both public and private keys to successfully connect Snowflake in Make. Your public key is associated with your Snowflake account, and your private key connects Snowflake to Make. You may generate either an encrypted or unencrypted private key. If you generate an encrypted key, store your password in a safe place.
To create the connection:
Log in to your account, add a Snowflake module to your , and click Create a connection.
Optional: In the Connection name field, enter a name for the connection.
In the Connection type, select the type of the connection:
- Snowflake username/password:
- Optional: In the Connection name field, enter a name for the connection.
- In the Account field, enter your copied Account name and Organization name that you copied above 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.
- Snowflake key pair:
- Optional: In the Connection name field, enter a name for the connection.
- In the Account field, enter your copied Account name and Organization name that you copied above in ORGANIZATION-ACCOUNT format. For example, if your Organization name is ABC, and account name is DEF, enter ABC-DEF.
- In the Username field, enter your Snowflake account's login username.
- In the Private key field, enter your unencrypted private key and proceed to the next step. If you use an encrypted private key, follow the steps below:
- Click Extract.
- In the Extract field, select Private key.
- Upload the private key that you generated above.
- For encrypted private keys: In the Password field, enter the password for your private key that you generated above.
- 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've successfully created the connection and can now use the Snowflake app in your . If you want to make changes to your connection in the future, follow the steps here.
After connecting to the Snowflake app, you can use the following types of modules to build your .