Skip to main content
Your agent can explore your Snowflake databases and run read-only queries so you get insights, reports, and data checks without writing SQL. Ask in natural language and get answers. Authentication uses a Snowflake Programmatic Access Token (PAT) — no password — and queries time out after 30 seconds.
Screenshot: Snowflake capability card in Settings → Capabilities with account, login name and PAT configured

How to enable

Go to Settings → Capabilities and enable Snowflake. Enter your Account Identifier, Login Name, and Programmatic Access Token (PAT) in the capability card (see below).

Example use cases

  • Revenue and rankings — “Query our Snowflake sales table and show top 10 customers by revenue this year”
  • Scheduled reports — “Every Friday, run a query for weekly signups and post a summary to Slack”
  • Data reconciliation — “Compare yesterday’s order count in Snowflake with the count in our CRM and flag any mismatch”
  • Schema discovery — “List the tables in our analytics schema and describe the columns in the events table”
  • Ad-hoc analysis — “What were our top-performing campaigns last month by spend and conversions? Use the marketing schema in Snowflake”
Dr Plotts answering a question using Snowflake data
Dr Plotts chart from Snowflake data
The agent supports read-only operations only (e.g. querying data, listing tables, describing schemas). No DDL or DML.

How to connect Snowflake

1

Get your account identifier and login name

In Snowflake, open Account Details. Note your Account Identifier (format: <org>-<account>) and Login Name (username).
2

Create a Programmatic Access Token (PAT)

Generate a PAT in Snowflake for programmatic access — see Snowflake’s PAT documentation for how to create one. The PAT is used instead of a password for the integration.
3

Configure in Abundly

Go to Settings → Capabilities and enable Snowflake. Enter the Account Identifier, Login Name, and PAT in the capability card. The PAT is stored as a team secret (secret type: Snowflake).

Learn more