Snowflake Support
Connect to Snowflake with User/Password, Key-Pair, or SSO — plus efficient handling of large result sets.
DataBook Studio provides comprehensive Snowflake support with three authentication methods and efficient large result set handling.
Authentication
Three methods are supported:
| Method | Detail |
|---|---|
| User/Password | Standard username and password login |
| Key-Pair | Authenticate with a private key for automated or service-account access |
| SSO (Browser) | External browser OAuth flow for SSO-enabled accounts |
Session tokens are cached for convenience with automatic refresh. Role, warehouse, database, and schema selection happens automatically with graceful fallback for permission-restricted contexts.
Large Result Sets
When Snowflake returns large result sets, the API splits rows across multiple partition URLs instead of returning them inline. DataBook Studio handles this transparently — downloading, decompressing, and assembling the complete result set for you with no manual intervention.
Snowflake Dialect
The AI copilot understands Snowflake-specific SQL syntax (QUALIFY, VARIANT, etc.) and generates dialect-correct queries. Safety guardrails also apply Snowflake-specific rules.