Skip to main content
Snowflake is a cloud data warehouse used to store and analyze large volumes of structured data. Connecting Snowflake to Duvo lets your agents query your warehouse directly, pulling metrics, exploring tables, and using live data to inform decisions and reports.
Snowflake is read-only in Duvo. Agents can run SELECT-style queries but cannot modify your data.

​
Setup

Confirm prerequisites

A Snowflake account with key-pair authentication enabled for the connecting user.
An RSA key pair generated for the user, with the public key registered in Snowflake. You provide the private key to Duvo.
A compute warehouse available for the role you plan to use.
New to key-pair auth? Follow Snowflake’s key-pair authentication guide to generate the keys and register the public key.

Grant the required permissions

The Snowflake role you specify must have:
  • USAGE on the target warehouse, database, and schema
  • SELECT on any tables or views your agents need to read
The role determines exactly what data the agent can reach. Scope it to only the databases, schemas, and tables the agent needs.

Add the connection in Duvo

On the Connections page, open Snowflake and fill in these fields:
​
Private Key
PEM
required
The RSA private key for authentication, in PEM format. Include the full key with the -----BEGIN PRIVATE KEY----- and -----END PRIVATE KEY----- lines.
​
Account
string
required
Your Snowflake account identifier, either orgname-accountname (e.g. myorg-myaccount) or the legacy locator (e.g. xy12345.us-east-1). Find it in your account URL or under Admin > Accounts.
​
Username
string
required
The Snowflake user configured with your public key.
​
Database
string
required
The default database to connect to.
​
Schema
string
required
The default schema within the database.
​
Warehouse
string
required
The compute warehouse to use for queries.
​
Role
string
required
The Snowflake role to assume for the session. This determines what data the agent can access.
​
Private Key Passphrase
string
Optional. The passphrase used to decrypt the private key, if the key is encrypted.

​
Capabilities

  • Run read-only SQL queries — execute SELECT, WITH (CTEs), SHOW, DESCRIBE, and EXPLAIN statements against your warehouse. Write operations are not permitted.
  • Discover tables and schemas — list all tables in a given database and schema, including row counts and comments, so agents can understand the data landscape before querying.
  • Verify connection details — check the active user, role, database, schema, and warehouse to confirm the session is configured correctly.
  • Export large result sets — query results exceeding 5,000 rows are automatically exported as CSV files for downstream analysis rather than returned inline.

​
Key Benefits

  • Live warehouse data — agents read directly from Snowflake instead of relying on stale exports or manual data pulls.
  • Safe by design — only read-only operations are allowed, so your data cannot be modified through Duvo.
  • Role-scoped access — the Snowflake role you specify controls exactly which databases, schemas, and tables the agent can reach.
  • Large-scale results — automatic CSV export handles result sets of any size without truncation.
  • Key-pair authentication — no passwords are stored; authentication uses RSA key pairs for stronger security.

​
Works Well With

https://mintcdn.com/duvo-d8027998/O3tlM6eCuFk2uJpN/images/connections/google-sheets.svg?fit=max&auto=format&n=O3tlM6eCuFk2uJpN&q=85&s=0ef8d55e05c34e7a4a618933bdf0ceb3

Google Sheets

Query Snowflake and write the results into a spreadsheet for stakeholder review or recurring reports.
https://mintcdn.com/duvo-d8027998/O3tlM6eCuFk2uJpN/images/connections/gmail.svg?fit=max&auto=format&n=O3tlM6eCuFk2uJpN&q=85&s=ad4e229283f3fe2f26c0f96a49f28e13

Gmail

Pull warehouse metrics and include them in automated email summaries or alerts.
https://mintcdn.com/duvo-d8027998/O3tlM6eCuFk2uJpN/images/connections/slack.svg?fit=max&auto=format&n=O3tlM6eCuFk2uJpN&q=85&s=8a64bdd1af39e903923e4a273b4a4618

Slack

Monitor key business thresholds and post a notification to a channel when values change.

​
Outcome Examples

Every Monday, a summary of last week’s revenue, order volume, and exception count is posted to your team’s Slack channel or emailed to stakeholders. The agent queries your warehouse, calculates week-over-week changes, and distributes the formatted result automatically. No one needs to open Snowflake or prepare a report manually.
An agent polls Snowflake every hour and fires a Slack notification when inventory drops below the reorder point, a fraud rate crosses a limit, or any other condition is met. It stays silent when everything is within bounds, so alerts stay signal, not noise.
A stakeholder needs a fresh customer list, transaction export, or regional breakdown. The agent runs the query and writes the results into a named Google Sheet, including a “last refreshed” timestamp. Run on demand or on a schedule.
See Snowflake Workflows for step-by-step tutorials covering all three patterns.