Snowflake

At a glance

Availability: Experimental (how to enable).
Auth: API key.
Connection: The key from SNOWFLAKE_PAT is sent as the Bearer prefixed Authorization header.
Docs: https://docs.snowflake.com/en/developer-guide/sql-api/authenticating

Set these per environment. See Connect an integration.

Variable	Required	Description
`SNOWFLAKE_PAT`	Yes	Snowflake programmatic access token (PAT) used as a Bearer token with the SQL API Docs.
`SNOWFLAKE_ACCOUNT`	Yes	Your Snowflake account identifier (e.g., xy12345.us-east-1) Docs.
`SNOWFLAKE_USERNAME`	Yes	Snowflake username for authentication Docs.
`SNOWFLAKE_PASSWORD`	Yes	Snowflake password for authentication Docs.
`SNOWFLAKE_WAREHOUSE`	Yes	Default warehouse to use for queries (e.g., COMPUTE_WH) Docs.
`SNOWFLAKE_DATABASE`	No	Default database to use for queries Docs.
`SNOWFLAKE_SCHEMA`	No	Default schema to use for queries (defaults to PUBLIC) Docs.

Locate Your Account Identifier: Find your Snowflake account identifier in the Snowflake web interface URL (e.g., xy12345.us-east-1 from https://xy12345.us-east-1.snowflakecomputing.com)
Create or Use Existing User: Use an existing Snowflake user or create a new one with appropriate permissions. The user needs USAGE privileges on the warehouse and database, and SELECT privileges on tables.
Generate a Programmatic Access Token: In Snowsight, open your user profile > Settings > Authentication and generate a programmatic access token (PAT), or run ALTER USER … ADD PROGRAMMATIC ACCESS TOKEN. The SQL API does not accept username/password basic auth; the PAT is sent as a Bearer token.
Configure Warehouse: Ensure you have a warehouse created and running. The default warehouse is typically named COMPUTE_WH.
Set Environment Variables: Add the following environment variables to your .env file with your Snowflake credentials
Test Connection: Test your connection by listing databases or running a simple query

Tool	Access	Description
Run Query	Write	Execute a SQL query against your Snowflake data warehouse
List Databases	Read	List all databases in your Snowflake account
List Schemas	Read	List all schemas in a Snowflake database
List Tables	Read	List all tables in a Snowflake database schema
Describe Table	Read	Get detailed column information for a specific table

Help me query data from my Snowflake data warehouse. Show me specific records or analyze patterns.
Show me the structure of tables in my Snowflake database and help me understand the schema.
Analyze my Snowflake data and generate insights about trends, patterns, and anomalies.
Help me optimize my SQL queries for better performance in Snowflake.