Connect your Snowflake data warehouse to Google Sheets

Select Add-ons and choose Get Add-ons. This action will redirect you to the Google Workspace Marketplace.

Click on Extensions from the Google Sheets menu. Note: For the best experience, install Superjoin where there’s only a single account is logged in the Chrome profile.

Once installed, navigate back to the Extensions menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.

Go to sources and click on “Connect new Source”

Type Snowflake in the search bar and click on Snowflake

Connect to your Snowflake account using your account, username, private key and
warehouse name.

Login to your Snowflake account and click on View account details as shown in the screenshot below.

In the modal window, copy the account subdomain (highlighted in the screenshot). Example: https://{subdomain}.snowflakecomputing.com

You may also note the User name.

Once you are done filling up Account, User, and Warehouse, You can begin authorization. Click on Configure under Private Key.

Snowflake supports RSA certificate for authorization.

Superjoin provides you 2 ways of authorization:

• Create Key Pair - Superjoin will create a key pair for you. We save the private key securely and provide you the public key. This public key has to be used in the Snowflake account.
• Upload Private Key - You can upload your private key file. We support both encrypted and unencrypted private keys. We will generate a public key which you can use in the Snowflake account.

Once you have decided on the way you want to authorize, you will be presented with a public key. This will allow us to communicate with your Snowflake account. You may copy the public key and add it to your Snowflake account.

After copying the public key, you can add it to your Snowflake account. Head over to Snowflake. Here you may create a new SQL Workspace. Then in the code editor, you can paste the public key. Make sure to replace <username here> with your actual user name.

Once the query execution is successful, you can return to Superjoin. Clicking Next will close the modal window. And you are all set to go! Click on Authorize to complete the process.