> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superjoin.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect your Snowflake data warehouse to Google Sheets

> Quickly link your Snowflake data warehouse to Google Sheets for hassle-free data integration.

## Step-by-step walkthrough: How to connect Snowflake to Google Sheets

<Steps>
  <Step title="Get Add-ons">
    Select `Add-ons` and choose `Get Add-ons`. This action will redirect you to the Google Workspace Marketplace.

    <Frame>
      <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/getaddons.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=ba23d07d1410cd3afb25454c5581cc85" alt="Get Add-ons" width="1361" height="648" data-path="images/getaddons.png" />
    </Frame>
  </Step>

  <Step title="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.

    <Frame>
      <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/marketplace.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=8b32a5ed819c10448985a7e3df6f7731" alt="Marketplace" width="966" height="884" data-path="images/marketplace.png" />
    </Frame>
  </Step>

  <Step title="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.

    <Frame>
      <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/launchstackit.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=14e2ecb541402cb914b79951a8faff16" alt="Launch Superjoin" width="1347" height="543" data-path="images/launchstackit.png" />
    </Frame>
  </Step>

  <Step title="Go to sources list">
    Go to sources and click on "Connect new Source"

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-1.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=b2a4cb06d1b65a8d132dbb63e6ee9bd8" alt="Go to sources list" width="3024" height="1504" data-path="images/snowflake/snowflake-step-1.png" />
    </Frame>
  </Step>

  <Step title="Search for Snowflake">
    Type Snowflake in the search bar and click on Snowflake

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-2.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=138c3e75d64a709a218d87df1fda3c65" alt="Search for Snowflake" width="3024" height="1504" data-path="images/snowflake/snowflake-step-2.png" />
    </Frame>
  </Step>

  <Step title="Connect your account">
    Connect to your Snowflake account using your account, username, private key and\
    warehouse name.

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-3.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=206f4c427628c5e102794b6e68af36d3" alt="Connect your account" width="3360" height="1906" data-path="images/snowflake/snowflake-step-3.png" />
    </Frame>
  </Step>

  <Step title="Get Account Subdomain">
    Login to your Snowflake account and click on `View account details` as shown in the screenshot below.

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-4.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=0f858ec4a7e6a78dd809fa667d57c716" alt="Get Account Subdomain" width="1410" height="1084" data-path="images/snowflake/snowflake-step-4.png" />
    </Frame>

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

    You may also note the User name.

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-5.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=daef607f2565311d360d52915470be31" alt="Get Account Subdomain" width="2978" height="1546" data-path="images/snowflake/snowflake-step-5.png" />
    </Frame>
  </Step>

  <Step title="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.

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-6.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=d742060b3e89e7ffedb53daccde3a503" alt="Provide your Private Key" width="2256" height="1810" data-path="images/snowflake/snowflake-step-6.png" />
    </Frame>
  </Step>

  <Step title="Provide your Private Key">
    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.

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-7.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=23f12ef1bfea79d6e225c077b70653df" alt="Provide your Private Key" width="2256" height="1810" data-path="images/snowflake/snowflake-step-7.png" />
    </Frame>

    <Note>
      When uploading an encrypted private key, you will need to provide the passphrase.
      All your credentials will be encrypted with the highest industry standards. <a href="https://www.superjoin.ai/data-security" target="_blank" rel="noreferrer">Learn more</a>
    </Note>

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-8.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=39bcb97f008cc44e797b0a373881b2d3" alt="Provide your Private Key" width="2256" height="1810" data-path="images/snowflake/snowflake-step-8.png" />
    </Frame>
  </Step>

  <Step title="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.

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-9.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=73870e6172b1a0eea7e1763e590dc7cc" alt="Using the public key" width="2256" height="1810" data-path="images/snowflake/snowflake-step-9.png" />
    </Frame>
  </Step>

  <Step title="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.

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-10.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=7f60f755f750c7a2dac934d7421d9ce2" alt="Adding the public key to Snowflake" width="3360" height="2084" data-path="images/snowflake/snowflake-step-10.png" />
    </Frame>
  </Step>

  <Step title="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.

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/snowflake/snowflake-step-11.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=641b2c665d15f70a28ef233b05a4b874" alt="Return to Superjoin" width="2256" height="1810" data-path="images/snowflake/snowflake-step-11.png" />
    </Frame>
  </Step>
</Steps>
