Quickly link your Snowflake data warehouse to Google Sheets for hassle-free data integration.
Get Add-ons
Select Add-ons
and choose Get Add-ons
. This action will redirect you to the Google Workspace Marketplace.
Click on Install
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.
Launch Superjoin
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 list
Go to sources and click on “Connect new Source”
Search for Snowflake
Type Snowflake in the search bar and click on Snowflake
Connect your account
Connect to your Snowflake account using your account, username, private key and
warehouse name.
Get Account Subdomain
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.
Fill up the form
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.
Provide your Private Key
Superjoin provides you 2 ways of authorization:
encrypted
and unencrypted
private keys. We will generate a public key which you can use in the Snowflake account.When uploading an encrypted private key, you will need to provide the passphrase. All your credentials will be encrypted with the highest industry standards. Learn more
Using the public key
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.
Adding the public key to Snowflake
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.
Return to Superjoin
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.
Quickly link your Snowflake data warehouse to Google Sheets for hassle-free data integration.
Get Add-ons
Select Add-ons
and choose Get Add-ons
. This action will redirect you to the Google Workspace Marketplace.
Click on Install
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.
Launch Superjoin
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 list
Go to sources and click on “Connect new Source”
Search for Snowflake
Type Snowflake in the search bar and click on Snowflake
Connect your account
Connect to your Snowflake account using your account, username, private key and
warehouse name.
Get Account Subdomain
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.
Fill up the form
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.
Provide your Private Key
Superjoin provides you 2 ways of authorization:
encrypted
and unencrypted
private keys. We will generate a public key which you can use in the Snowflake account.When uploading an encrypted private key, you will need to provide the passphrase. All your credentials will be encrypted with the highest industry standards. Learn more
Using the public key
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.
Adding the public key to Snowflake
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.
Return to Superjoin
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.