Snowflake
Run SQL, inspect warehouse objects, and query governed semantic views
Connect Snowflake for bounded SQL statement workflows and warehouse metadata. Shared connections use a programmatic access token; published apps can let each signed-in user authorize through Snowflake OAuth.
Connect Snowflake
For a shared connection, enter the programmatic access token, account identifier, and role. For published app users, an administrator also configures the Snowflake OAuth client and final app origin.
The connector can submit, poll, partition, and cancel SQL statements; list databases, schemas, and warehouses; and query a semantic view with read-only SQL.
Example prompt:
Use Snowflake to list schemas in ANALYTICS, inspect the available warehouse, and run this read-only query with a 100-row limit.
Verify and recover
List databases, submit SELECT CURRENT_ROLE(), and poll the result. Cancel a disposable statement. In app-user mode, verify two users remain isolated.
If Snowflake rejects the request, check the account identifier, role, token or OAuth grant, and warehouse privileges. Disconnecting does not cancel unrelated queries or delete Snowflake objects.