Connect Snowflake to Superhuman Docs and Superhuman Go

Superhuman Connectors let you bring the tools your organization relies on directly into Superhuman Docs and Superhuman Go. With the Snowflake connector, you can pull data from Snowflake directly into Superhuman Docs and ask questions about it in plain language through Superhuman Go, our AI chat agent. This keeps reporting and decisions anchored to your live source of truth, so your team can turn data into answers without exporting spreadsheets or switching between tools.

Configure the Snowflake connector for your organization

Note: The Snowflake connector is only available to customers on our Enterprise tier. You must be an Enterprise admin to complete the setup and configuration steps outlined in this article.

Step 1: Gather your Snowflake account identifier

First, find and copy your Snowflake account identifier and instance URL.

Account identifier: This identifier should look something like abc123-def456. If you do not know your identifier, run the following query in Snowflake to retrieve it:

SELECT LOWER(CONCAT(CURRENT_ORGANIZATION_NAME(), '-', CURRENT_ACCOUNT_NAME()));

Instance URL: This URL should look something like https://{ACCOUNT_IDENTIFIER}.snowflakecomputing.com, with some variation depending on how your Snowflake instance is configured.

For more information, see this Snowflake documentation: Account identifiers

Step 2: Add OAuth security integration to Snowflake

This step creates an OAuth integration with your Snowflake instance that Superhuman requires to securely authenticate end users.

Sign in to your Snowflake admin account.
Decide which existing Snowflake security roles you’d like to explicitly allow and disallow via the Snowflake connector. This can be used to restrict Superhuman’s access to sensitive data within Snowflake.

Run the following command that will create the OAuth security integration that Superhuman can leverage:

CREATE SECURITY INTEGRATION OAUTH_CODA_PACK
  TYPE = oauth
  ENABLED = true
  OAUTH_CLIENT = custom
  OAUTH_CLIENT_TYPE= 'CONFIDENTIAL'
  OAUTH_REDIRECT_URI = 'https://coda.io/packsAuth/oauth2/24936'
  OAUTH_ISSUE_REFRESH_TOKENS = true
  OAUTH_REFRESH_TOKEN_VALIDITY = 7776000  // 90 days
  // Optional: Block additional roles.
  BLOCKED_ROLES_LIST = (
    'SYSADMIN', 'ACCOUNTADMIN', 'ORGADMIN', 'SECURITYADMIN'
  );

Next, to create a set of Snowflake-generated OAuth secrets that are required to configure the Snowflake connector, run this command:
```
SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('OAUTH_CODA_PACK');
```
This will return a JSON object containing the client ID and client secrets. Copy the values of the OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET, which you will need when configuring the connector in Superhuman.
```
{
  "OAUTH_CLIENT_SECRET_2": "SECRET2_ABC123",
  "OAUTH_CLIENT_SECRET": "SECRET_ABC123",
  "OAUTH_CLIENT_ID": "CLIENT_ID_ABC123"
}
```

Step 3: Configure the Snowflake connector in Superhuman

This step adds a new configuration for the Snowflake connector in Superhuman and inputs the OAuth secrets from Snowflake. With the values you gathered from your Snowflake account, follow these steps to complete the configuration in Superhuman:

Go to the Connectors page.
In the search field in the upper-right corner, enter Snowflake, then click on the Snowflake connector to start configuring it.
On the page that opens, click on the menu next to Connector access and select Custom.
In the window that appears, click Confirm.
In the Configurations section, click Edit to change the existing configuration, or click + Add Configuration below to create a new one.
Enter or edit the configuration name, then under Groups with access, choose whether the configuration applies to everyone or to selected groups.
In the Policy section, for the Connection endpoint URL, enter your Snowflake instance URL that consists of your account identifier: https://{ACCOUNT_IDENTIFIER}.snowflakecomputing.com
Click on the Select scopes… menu and check the boxes next to the scopes you want to enable.
Under Read permissions, select Allow, Always ask, or Deny.
Under Write permissions, also select Allow, Always ask, or Deny.
Optionally, check the box next to Allow only private connections to write to Snowflake.
Click on the Select tables… menu and choose which items from Snowflake to sync.
Optionally, check the box next to Doc sharing to enforce configuration permissions for it.
Next, in the OAuth app credentials section, enter your Client ID and Client secret:
- Client ID: Enter the OAUTH_CLIENT_ID value copied from the Snowflake OAuth security integration.
- Client secret: Enter the OAUTH_CLIENT_SECRET value copied from the Snowflake OAuth security integration (you can ignore OAUTH_CLIENT_SECRET_2).
Click Save configuration.

The configuration is now complete and can be used in Superhuman Docs and Superhuman Go to connect to your Snowflake data. If you need to make any changes later, go to the Connectors page, find and click on the Snowflake connector, then click Edit next to the configuration you want to update.

Try out Snowflake integration in Superhuman Docs

After the Snowflake connector is configured, you should be able to add it to your doc and connect to your Snowflake account. To do that, follow these steps:

Type /snowflake in your doc, and select the Snowflake connector from the options.
In the window that appears, click Select configuration.
In the next window, click on the dropdown menu, select a configuration, and click Select.
Follow the prompts to connect to your Snowflake account.
At this point, you can add a new Query table. Type /query in your doc, then select the Query table from the options.
In the Query field in the right-hand panel, type in your Snowflake query. Select the columns used to uniquify the request. Then run the query and see the results in Docs.

Tap into your Snowflake data in Superhuman Go

Superhuman Go is our AI chat agent, available in the Superhuman browser extension for Chrome and Edge, and in the AI editor at app.grammarly.com. Once the Snowflake connector is configured, Go can tap into your Snowflake data and help you work with it in plain language — without writing SQL or leaving the page you're on.

To start Go in the browser, hover over the right edge of your browser window to reveal the Superhuman tab, then click it to open the chat. You can then ask Go to work with your Snowflake data. For example, you can:

Ask questions in plain language: Query your warehouse without writing SQL — for example, “What was total revenue by region last quarter?” — and get an answer back in seconds.
Summarize and explain your data: Have Go describe what a table contains, surface trends, or break down a metric so you don’t have to dig through rows yourself.
Pull numbers into your work: Drop specific figures, lists, or query results straight into the doc, email, or message you’re drafting.
Generate content grounded in your data: Turn live Snowflake data into summaries, status updates, or reports without exporting to a spreadsheet first.
Ask follow-up questions: Refine or drill deeper into any result in a natural back-and-forth, just like a conversation.

Because Go uses the context of your active window and connected sources, you can also click Add sources to chat to point it at Snowflake before asking your question. Go acts using the Snowflake role and permissions granted through the connector, so it can only access data you’re already allowed to query.