Snowflake

Full guide for the Snowflake SimpleChat action.

Screenshot needed

Snowflake configuration

Capture Account and Warehouse, Authentication, Execution Limits, and Test Connection. Redact secrets.

Save as docs/images/reference/actions-snowflake-configuration.png

Drop the file at that path and it replaces this card automatically. No other change needed.

What this action does

Snowflake connects to one Snowflake account and warehouse for read-only data retrieval. It can run SQL and discover databases, schemas, tables, and table details.

Why and when to use it

Use Snowflake when analytics data is stored in Snowflake and users need governed natural-language access through an agent. Do not use it for Databricks SQL Warehouses or traditional SQL Server/PostgreSQL/MySQL targets; use those dedicated actions.

Before you start

Snowflake Account Identifier without the snowflakecomputing.com suffix.
Warehouse and optional default database, schema, role, and user.
Password, key-pair private key, OAuth token, or compatible reusable identity.
Agents/actions enabled with enable_semantic_kernel.

Configure the action

Choose Snowflake.
Fill Account Identifier and Warehouse.
Optionally set Default Database, Default Schema, Role, and Snowflake User.
Choose Authentication Method: Password, Key Pair, or OAuth Token.
Fill Password, Private Key and optional Private Key Passphrase, or OAuth Token.
Set Max Rows, Query Timeout (seconds), and Login Timeout (seconds).
Use Test Connection.

Example prompts

“Which regions had the highest subscription growth last month?”
“List schemas in the ANALYTICS database and describe CUSTOMER_HEALTH.”
“Query the top 50 accounts with declining usage over the last 30 days.”

Troubleshooting