Snowflake

with the snowflake app in {{product name}} 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 connect snowflake and {{product name}} to establish the connection, you must for the snowflake user/password type of connection snowflake docid 0rsc1noayu5yri4oj ny for the snowflake key pair type of connection snowflake docid 0rsc1noayu5yri4oj ny snowflake docid 0rsc1noayu5yri4oj ny obtain your account details in snowflake 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 {{product name}} generate your private key in snowflake 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 create the connection in {{product name}} to create the connection log in to your {{product name}} account, add a snowflake module to your {{scenario singular lowercase}} , 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 {{scenario plural lowercase}} if you want to make changes to your connection in the future, follow the steps connect an application docid\ so88fm6pkt0g adkddfzz snowflake modules after connecting to the snowflake app, you can use the following types of modules to build your {{scenario plural lowercase}} actions execute sql snowflake resources snowflake api documentation