Quickly link your Snowflake data warehouse to Google Sheets for hassle-free data integration.
Get Add-ons
Add-ons
and choose Get Add-ons
. This action will redirect you to the Google Workspace Marketplace.Click on Install
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.Launch Superjoin
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 list
Search for Snowflake
Connect your account
Get Account Subdomain
View account details
as shown in the screenshot below.https://{subdomain}.snowflakecomputing.com
You may also note the User name.Fill up the form
Account
, User
, and Warehouse
, You can begin authorization. Click on Configure
under Private Key.Snowflake supports RSA certificate for authorization.Provide your Private Key
encrypted
and unencrypted
private keys. We will generate a public key which you can use in the Snowflake account.Using the public key
Adding the public key to Snowflake
<username here>
with your actual user name.Return to Superjoin
Next
will close the modal window.
And you are all set to go! Click on Authorize
to complete the process.