At a glance
- Availability: Experimental (how to enable).
- Auth: API key.
- Connection: The key from
SNOWFLAKE_PATis sent as theBearerprefixedAuthorizationheader. - Docs: https://docs.snowflake.com/en/developer-guide/sql-api/authenticating
Credentials
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. |
Setup
- 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
Tools
| 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 |
Example prompts
- 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.