Snowflake
This content is not available in your language yet.
Connect a Snowflake data warehouse to Agent Context. Agents can query your Snowflake tables using standard SQL.
- Go to Agent Context in the dashboard
- Click Add Source → Snowflake
- Enter your account, warehouse, and credentials
- Specify the table to connect
- Click Test Connection to verify, then Save
Connection Parameters
Section titled “Connection Parameters”| Parameter | Required | Description |
|---|---|---|
| Account | Yes | Snowflake account identifier (e.g., account.region or orgname-accountname) |
| Warehouse | Yes | Compute warehouse to use for queries |
| Username | Yes | Snowflake user for authentication |
| Password | Yes | Password for the specified user |
| Table | Yes | Fully qualified table name: DATABASE.SCHEMA.TABLE |
Authentication
Section titled “Authentication”Provide your Snowflake username and password in the setup form.
Key pair authentication and role selection are supported at the backend level but not yet exposed in the dashboard UI. Contact support if you need these options.
Table Reference Format
Section titled “Table Reference Format”Tables use a three-part fully qualified name:
DATABASE.SCHEMA.TABLEExamples:
ANALYTICS.PUBLIC.CUSTOMERSRAW_DATA.STAGING.EVENTSPROD_DB.FINANCE.TRANSACTIONS
What Gets Discovered
Section titled “What Gets Discovered”When you connect a Snowflake table, Agent Context discovers:
- The table’s columns, types, and constraints
- Column-level metadata for schema exploration
Each connected table becomes individually queryable by agents via the context-lake catalog and context-lake query commands.
Troubleshooting
Section titled “Troubleshooting”| Issue | Fix |
|---|---|
| Account not found | Verify the account identifier format. Use account.region (e.g., xy12345.us-east-1) or the newer orgname-accountname format. |
| Authentication failed | Verify username and password. Check that the user account is not locked or expired. |
| Warehouse suspended | The specified warehouse may be suspended. Resume it in the Snowflake console or set it to auto-resume. |
| Table not found | Verify the fully qualified name (DB.SCHEMA.TABLE). Names are case-sensitive — Snowflake defaults to uppercase. |
| Permission denied | Ensure the user/role has SELECT access on the target table and USAGE on the database, schema, and warehouse. |