Rank #2 of 4 in Data Warehouses & Lakehouses
vs Databricks
vs BigQuery
vs MotherDuckShowcase
Try itExperimental
See what an agent can do with Snowflake before you ever sign up. Pick a story: recorded sessions replay real probe-harness transcripts; sandboxed self-drive sessions are designed and gated (docs/TRY-IT.md).
$uvx --from snowflake-cli snow sql --helprecorded session — replayed, not liveVerified integrations
Connections to other tracked products — hover a chip for the verbatim evidence quote behind it.
By theme — the product's score on each story themeBy theme
Agent analytics — stories about agent analytics in this arenaAgent analyticsevidence →
Stories about agent analytics in this arena
Agenticness — how well agents can access and operate the productAgenticnessevidence →
How well agents can access and operate the product
Automation depth — how much of the product can run unattendedAutomation depthevidence →
How much of the product can run unattended
Cost economics — stories about cost economics in this arenaCost economicsevidence →
Stories about cost economics in this arena
Ecosystem integrations — the surrounding ecosystem — integrations, marketplaces, community packagesEcosystem integrationsevidence →
The surrounding ecosystem — integrations, marketplaces, community packages
Governance access — stories about governance access in this arenaGovernance accessevidence →
Stories about governance access in this arena
Ingestion pipelines — stories about ingestion pipelines in this arenaIngestion pipelinesevidence →
Stories about ingestion pipelines in this arena
Notebooks workspace — stories about notebooks workspace in this arenaNotebooks workspaceevidence →
Stories about notebooks workspace in this arena
Openness — open source, data portability, and self-hosting storiesOpennessevidence →
Open source, data portability, and self-hosting stories
Privacy posture — data-handling and privacy storiesPrivacy postureevidence →
Data-handling and privacy stories
Semantic layer — stories about semantic layer in this arenaSemantic layerevidence →
Stories about semantic layer in this arena
Sharing marketplace — stories about sharing marketplace in this arenaSharing marketplaceevidence →
Stories about sharing marketplace in this arena
Sql analytics — stories about sql analytics in this arenaSql analyticsevidence →
Stories about sql analytics in this arena
Streaming realtime — stories about streaming realtime in this arenaStreaming realtimeevidence →
Stories about streaming realtime in this arena
Story verdicts — every judged story with its evidenceStory verdicts
What’s free: 0 free · 1 paid · 0 enterprise · 42 not stated in evidence
Follow the green: where the map greys out is where Snowflake stops today. ✓ full · ~ partial · ! disputed · — none · n/a not applicable.
Agent analytics — stories about agent analytics in this arenaAgent analytics
Stories about agent analytics in this arena
Agent ops
Agenticness — how well agents can access and operate the productAgenticness
How well agents can access and operate the product
API surface
Drive the product through a documented public API
✓8/10
unlocks → Webhooks · Standard drivers (JDBC/ODBC) and documented BI-tool integrations connect my dashboards without custom glue · I get a fast local or free dev loop — a local engine, emulator, or sandbox — to develop transformations before touching production compute
Subscribe to events via webhooks
—0/10
Build against official SDKs
✓7/10
Issue scoped/least-privilege API credentials for an agent
~5/10
Connect an agent via an official MCP server
✓9/10
Download a machine-readable API spec (OpenAPI or equivalent)
✓8/10
Rely on versioned APIs with a documented deprecation policy
~6/10
Test against a sandbox environment without touching production data
~5/10
Explore an interactive API reference with runnable examples
~3/10
Docs for agents
Point an agent at llms.txt or agent-oriented docs
✓9/10
Agentic features
Delegate tasks to a built-in AI assistant inside the product
~4/10
unlocks → MCP client
Operate the product with natural-language commands
~7/10
Plug MCP servers into this product so it can use their tools
—0/10
Get AI-generated insights and suggestions from my data inside the product
✓8/10
Set up automations that run autonomously in the background
~5/10
Automation depth — how much of the product can run unattendedAutomation depth
How much of the product can run unattended
Cost economics — stories about cost economics in this arenaCost economics
Stories about cost economics in this arena
Ecosystem integrations — the surrounding ecosystem — integrations, marketplaces, community packagesEcosystem integrations
The surrounding ecosystem — integrations, marketplaces, community packages
Standard drivers (JDBC/ODBC) and documented BI-tool integrations connect my dashboards without custom glue
—–
I get a fast local or free dev loop — a local engine, emulator, or sandbox — to develop transformations before touching production compute
—0/10
Dbt is a first-class citizen — a documented adapter or native dbt project support with vendor docs to match
✓8/10
Governance access — stories about governance access in this arenaGovernance access
Stories about governance access in this arena
Ingestion pipelines — stories about ingestion pipelines in this arenaIngestion pipelines
Stories about ingestion pipelines in this arena
Notebooks workspace — stories about notebooks workspace in this arenaNotebooks workspace
Stories about notebooks workspace in this arena
Openness — open source, data portability, and self-hosting storiesOpenness
Open source, data portability, and self-hosting stories
Privacy posture — data-handling and privacy storiesPrivacy posture
Data-handling and privacy stories
Semantic layer — stories about semantic layer in this arenaSemantic layer
Stories about semantic layer in this arena
Sharing marketplace — stories about sharing marketplace in this arenaSharing marketplace
Stories about sharing marketplace in this arena
Sql analytics — stories about sql analytics in this arenaSql analytics
Stories about sql analytics in this arena
Query open table formats and files in object storage — Iceberg, Delta, Parquet — without first loading them into proprietary storage
✓8/10
Inspect query profiles and execution plans to find why a query is slow or expensive
✓8/10
Time-travel — query data as of a past point and restore dropped or corrupted tables from history
✓9/10
I get a full analytical SQL surface — window functions, CTEs, semi-structured JSON, arrays, and rich date/time types — without bolt-on extensions
~7/10
Streaming realtime — stories about streaming realtime in this arenaStreaming realtime
Stories about streaming realtime in this arena
Sorted by importance (agentic first) (high → low) · 54/54 stories · click a row’s chevron for the rationale and evidence
Connect an agent via an official MCP server G Agent access | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 3 | full | 9/10 | Tprobed | |
Drive the product through a documented public API G Agent access | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 3 | full | 8/10 | Tprobed | |
Delegate tasks to a built-in AI assistant inside the product G Agentic features | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 3 | partial | 4/10 | Cclaimed | |
Plug MCP servers into this product so it can use their tools G Agent access | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 3 | none | 0/10 | ||
Point an agent at llms.txt or agent-oriented docs G Agent access | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | full | 9/10 | Tprobed | |
Download a machine-readable API spec (OpenAPI or equivalent) G Api quality | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | full | 8/10 | Tprobed | |
Get AI-generated insights and suggestions from my data inside the product G Agentic features | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | full | 8/10 | Cclaimed | |
Run the product headlessly / in CI for automation G Agent access | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | full | 8/10 | Tprobed | |
Use an official CLI G Agent access | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | full | 8/10 | Tprobed | |
Build against official SDKs G Agent access | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | full | 7/10 | Tprobed | |
Operate the product with natural-language commands G Agentic features | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | partial | 7/10 | Cclaimed | |
Rely on versioned APIs with a documented deprecation policy G Api quality | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | partial | 6/10 | Cclaimed | |
Issue scoped/least-privilege API credentials for an agent G Agent access | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | partial | 5/10 | Cclaimed | |
Set up automations that run autonomously in the background G Agentic features | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | partial | 5/10 | Cclaimed | |
Explore an interactive API reference with runnable examples G Api quality | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | partial | 3/10 | Tprobed | |
Subscribe to events via webhooks G Agent access | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 2 | none | 0/10 | ||
Test against a sandbox environment without touching production data G Api quality | ai-native user | Agenticness — how well agents can access and operate the productAgenticness | 1 | partial | 5/10 | Cclaimed | |
My agent can run governed SQL end to end — authenticate, discover schemas, query, and read results back through a CLI or API with no dashboard in the loop C Agent ops | ai-native user | Agent analytics — stories about agent analytics in this arenaAgent analytics | 3 | full | 8/10 | Tprobed | |
I get a full analytical SQL surface — window functions, CTEs, semi-structured JSON, arrays, and rich date/time types — without bolt-on extensions C Sql | analyst | Sql analytics — stories about sql analytics in this arenaSql analytics | 3 | partial | 7/10 | Xcommunity | |
Define rules that trigger actions automatically on events G | ai-native user | Automation depth — how much of the product can run unattendedAutomation depth | 3 | partial | 6/10 | Cclaimed | |
Access control reaches tables, columns, and rows — roles plus masking policies — so one warehouse can serve many teams safely C Access | platform-engineer | Governance access — stories about governance access in this arenaGovernance access | 3 | partial | 5/10 | Cclaimed | |
Bulk-load CSV, JSON, and Parquet from cloud object storage with a single documented command C Loading | data-engineer | Ingestion pipelines — stories about ingestion pipelines in this arenaIngestion pipelines | 3 | partial | 5/10 | Xcommunity | |
Export all of my data in open formats and leave G | ai-native user | Openness — open source, data portability, and self-hosting storiesOpenness | 3 | partial | 5/10 | Xcommunity | |
The pricing model is documented clearly enough that I can estimate a monthly bill for my workload before committing G Pricing | platform-engineer | Cost economics — stories about cost economics in this arenaCost economics | 3 | disputed | 5/10 | Dcontradicted | |
Prevent my data from being used to train AI models G | ai-native user | Privacy posture — data-handling and privacy storiesPrivacy posture | 3 | none | untested | none yet | |
Self-host the core product G | ai-native user | Openness — open source, data portability, and self-hosting storiesOpenness | 3 | n/a | untested | none yet | |
Share live datasets with another account or organization without copying data or building an export pipeline C Sharing | data-engineer | Sharing marketplace — stories about sharing marketplace in this arenaSharing marketplace | 2 | fullpaid | 9/10 | Cclaimed | |
Time-travel — query data as of a past point and restore dropped or corrupted tables from history C Recovery | data-engineer | Sql analytics — stories about sql analytics in this arenaSql analytics | 2 | full | 9/10 | Cclaimed | |
A managed service continuously ingests new files or events as they arrive, without me running my own pipeline infrastructure C Loading | data-engineer | Ingestion pipelines — stories about ingestion pipelines in this arenaIngestion pipelines | 2 | full | 8/10 | Xcommunity | |
Budgets, resource monitors, or auto-suspend stop a runaway query or idle compute from burning money overnight G Pricing | platform-engineer | Cost economics — stories about cost economics in this arenaCost economics | 2 | full | 8/10 | Xcommunity | |
Dbt is a first-class citizen — a documented adapter or native dbt project support with vendor docs to match C Transformation | data-engineer | Ecosystem integrations — the surrounding ecosystem — integrations, marketplaces, community packagesEcosystem integrations | 2 | full | 8/10 | Xcommunity | |
First-party notebooks let me mix SQL and Python against warehouse data, with results and charts inline C Notebooks | analyst | Notebooks workspace — stories about notebooks workspace in this arenaNotebooks workspace | 2 | full | 8/10 | Xcommunity | |
Inspect query profiles and execution plans to find why a query is slow or expensive C Performance | data-engineer | Sql analytics — stories about sql analytics in this arenaSql analytics | 2 | full | 8/10 | Xcommunity | |
Query open table formats and files in object storage — Iceberg, Delta, Parquet — without first loading them into proprietary storage C Lakehouse | data-engineer | Sql analytics — stories about sql analytics in this arenaSql analytics | 2 | full | 8/10 | Cclaimed | |
A built-in AI assistant writes, fixes, and explains SQL against my schemas from natural language, inside the product C Agent ops | ai-native user | Agent analytics — stories about agent analytics in this arenaAgent analytics | 2 | partial | 7/10 | Cclaimed | |
Define a governed semantic model — metrics, dimensions, and joins declared once — that queries and AI tools answer against consistently C Semantics | analyst | Semantic layer — stories about semantic layer in this arenaSemantic layer | 2 | full | 7/10 | Cclaimed | |
Do everything through the API that I can do in the UI G | ai-native user | Openness — open source, data portability, and self-hosting storiesOpenness | 2 | partial | 6/10 | Tprobed | |
I get audit logs of who ran what and column-level lineage of where data came from G Governance | platform-engineer | Governance access — stories about governance access in this arenaGovernance access | 2 | partial | 6/10 | Cclaimed | |
Perform bulk operations across many items at once G | ai-native user | Automation depth — how much of the product can run unattendedAutomation depth | 2 | partial | 6/10 | Cclaimed | |
Control data retention and deletion G | ai-native user | Privacy posture — data-handling and privacy storiesPrivacy posture | 2 | partial | 5/10 | Cclaimed | |
First-party and partner connectors cover my sources — SaaS apps, databases, and ETL/ELT tools — with documented setup C Connectors | data-engineer | Ingestion pipelines — stories about ingestion pipelines in this arenaIngestion pipelines | 2 | partial | 4/10 | Cclaimed | |
Schedule recurring jobs or workflows G | ai-native user | Automation depth — how much of the product can run unattendedAutomation depth | 2 | partial | 4/10 | Cclaimed | |
Streaming writes land queryable within seconds through a documented streaming ingestion API C Streaming | data-engineer | Streaming realtime — stories about streaming realtime in this arenaStreaming realtime | 2 | partial | 4/10 | Cclaimed | |
I get a fast local or free dev loop — a local engine, emulator, or sandbox — to develop transformations before touching production compute C Dev loop | data-engineer | Ecosystem integrations — the surrounding ecosystem — integrations, marketplaces, community packagesEcosystem integrations | 2 | none | 0/10 | ||
Choose where my data is stored (region/residency) G | ai-native user | Privacy posture — data-handling and privacy storiesPrivacy posture | 2 | none | untested | none yet | |
Opt out of telemetry and usage tracking G | ai-native user | Privacy posture — data-handling and privacy storiesPrivacy posture | 2 | none | untested | none yet | |
Read the product's source under an open license G | ai-native user | Openness — open source, data portability, and self-hosting storiesOpenness | 2 | n/a | untested | none yet | |
Compliance attestations (SOC 2, HIPAA, PCI) are documented so security review does not stall the rollout C Governance | platform-engineer | Governance access — stories about governance access in this arenaGovernance access | 1 | full | 8/10 | Cclaimed | |
Run continuous or incremental transformations — streams, tasks, declarative pipelines, or continuous queries — inside the platform C Streaming | data-engineer | Streaming realtime — stories about streaming realtime in this arenaStreaming realtime | 1 | full | 8/10 | Cclaimed | |
Business users can ask questions in natural language and get governed, semantically-grounded answers rather than hallucinated joins C Agent ops | ai-native user | Agent analytics — stories about agent analytics in this arenaAgent analytics | 1 | full | 7/10 | Cclaimed | |
Evaluate with a free tier or trial — real queries on real data without a credit card or a sales call G Trial | analyst | Cost economics — stories about cost economics in this arenaCost economics | 1 | partial | 5/10 | Xcommunity | |
Version, review, and roll back my automations G | ai-native user | Automation depth — how much of the product can run unattendedAutomation depth | 1 | partial | 4/10 | Cclaimed | |
A marketplace of third-party datasets lets me enrich my own data directly inside the platform C Sharing | analyst | Sharing marketplace — stories about sharing marketplace in this arenaSharing marketplace | 1 | none | 0/10 | ||
Standard drivers (JDBC/ODBC) and documented BI-tool integrations connect my dashboards without custom glue C Bi | analyst | Ecosystem integrations — the surrounding ecosystem — integrations, marketplaces, community packagesEcosystem integrations | 1 | none | untested | none yet |
Opportunities — the stories that would move this product's scores, from its own judged verdictsOpportunitiestop 8 of 30 stories with headroom
What would move Snowflake’s scores — derived from its own judged verdicts, biggest headroom first. Each line quotes what the judge found missing; shipping it (or evidencing it publicly) is the fix.
Agenticness — how well agents can access and operate the productPlug MCP servers into this product so it can use their tools
nonemoves agent-readyimpact 45
Evidence documents Snowflake's own MCP server that exposes Snowflake's Cortex tools to external AI agents (server-side), but there is no evidence Snowflake can act as an MCP client consuming external MCP servers' tools to extend Cortex Agents or CoWork/CoCo's capabilities.
Privacy posture — data-handling and privacy storiesPrevent my data from being used to train AI models
nonemoves PA Scoreimpact 30
The axis applies since Snowflake offers AI/Cortex features built on third-party LLMs, making data-use-for-training a fair privacy concern, but no evidence pack item documents an opt-out control, data-processing agreement, or explicit statement that customer data is excluded from model training.
Agenticness — how well agents can access and operate the productSubscribe to events via webhooks
nonemoves agent-readyimpact 30
Evidence shows Snowflake supports streams for CDC (polled) and notification integrations for cost alerts, but there is no documentation of a general-purpose webhook subscription mechanism that lets an AI-native user subscribe to events pushed via webhooks.
Agenticness — how well agents can access and operate the productDelegate tasks to a built-in AI assistant inside the product
partialq4/10moves Built-in AIimpact 27
Missing: dedicated CoWork/CoCo documentation detailing task-delegation scope, hands-on or independent corroboration of the assistant performing multi-step tasks, and clarity on how it differs from Cortex Analyst's NL query feature.
Agenticness — how well agents can access and operate the productExplore an interactive API reference with runnable examples
partialq3/10moves API qualityimpact 21
Missing: an in-browser interactive API explorer (e.g., Swagger/Redoc UI) hosted by Snowflake, and any independent confirmation that the Postman-based workflow is commonly used as a live API reference.
Ecosystem integrations — the surrounding ecosystem — integrations, marketplaces, community packagesI get a fast local or free dev loop — a local engine, emulator, or sandbox — to develop transformations before touching production compute
nonemoves PA Scoreimpact 20
Missing: any local engine/emulator, offline dev mode, or a genuinely free (non-credit-consuming) sandbox tier.
Privacy posture — data-handling and privacy storiesChoose where my data is stored (region/residency)
nonemoves PA Scoreimpact 20
The evidence pack includes compliance certifications (SOC 2, ISO, FedRAMP, PCI DSS) but contains no mention of region selection, data residency controls, or ability to choose a storage location/cloud region for an account or database.
Privacy posture — data-handling and privacy storiesOpt out of telemetry and usage tracking
nonemoves PA Scoreimpact 20
Missing: any documentation of a telemetry/usage-data collection policy or an opt-out/opt-in control for such tracking.
Showing the top 8 of 30 — every none/partial verdict in the story verdicts table is headroom.
Think a verdict is wrong? Every verdicts-table row has a Flag link — see the methodology.
Coverage map — which docs area, API section, or community source covers which judged storiesCoverage map7 surfaces · 44 covered stories
Where the cited evidence behind each covered verdict came from — the same citations the verdicts table shows, no extra judging.
En docs43 stories
- My agent can run governed SQL end to end — authenticate, discover schemas, query, and read results back through a CLI or API with no dashboard in the loop
- A built-in AI assistant writes, fixes, and explains SQL against my schemas from natural language, inside the product
- Business users can ask questions in natural language and get governed, semantically-grounded answers rather than hallucinated joins
- Point an agent at llms.txt or agent-oriented docs
- Run the product headlessly / in CI for automation
- Connect an agent via an official MCP server
- Use an official CLI
- Drive the product through a documented public API
- Issue scoped/least-privilege API credentials for an agent
- Build against official SDKs
- Get AI-generated insights and suggestions from my data inside the product
- Set up automations that run autonomously in the background
- Delegate tasks to a built-in AI assistant inside the product
- Operate the product with natural-language commands
- Explore an interactive API reference with runnable examples
- Download a machine-readable API spec (OpenAPI or equivalent)
- Test against a sandbox environment without touching production data
- Rely on versioned APIs with a documented deprecation policy
- Perform bulk operations across many items at once
- Define rules that trigger actions automatically on events
- Schedule recurring jobs or workflows
- Version, review, and roll back my automations
- The pricing model is documented clearly enough that I can estimate a monthly bill for my workload before committing
- Budgets, resource monitors, or auto-suspend stop a runaway query or idle compute from burning money overnight
- Dbt is a first-class citizen — a documented adapter or native dbt project support with vendor docs to match
- Access control reaches tables, columns, and rows — roles plus masking policies — so one warehouse can serve many teams safely
- I get audit logs of who ran what and column-level lineage of where data came from
- Compliance attestations (SOC 2, HIPAA, PCI) are documented so security review does not stall the rollout
- First-party and partner connectors cover my sources — SaaS apps, databases, and ETL/ELT tools — with documented setup
- Bulk-load CSV, JSON, and Parquet from cloud object storage with a single documented command
- A managed service continuously ingests new files or events as they arrive, without me running my own pipeline infrastructure
- First-party notebooks let me mix SQL and Python against warehouse data, with results and charts inline
- Do everything through the API that I can do in the UI
- Export all of my data in open formats and leave
- Control data retention and deletion
- Define a governed semantic model — metrics, dimensions, and joins declared once — that queries and AI tools answer against consistently
- Share live datasets with another account or organization without copying data or building an export pipeline
- Query open table formats and files in object storage — Iceberg, Delta, Parquet — without first loading them into proprietary storage
- Inspect query profiles and execution plans to find why a query is slow or expensive
- Time-travel — query data as of a past point and restore dropped or corrupted tables from history
- I get a full analytical SQL surface — window functions, CTEs, semi-structured JSON, arrays, and rich date/time types — without bolt-on extensions
- Run continuous or incremental transformations — streams, tasks, declarative pipelines, or continuous queries — inside the platform
- Streaming writes land queryable within seconds through a documented streaming ingestion API
Hacker News10 stories
- The pricing model is documented clearly enough that I can estimate a monthly bill for my workload before committing
- Budgets, resource monitors, or auto-suspend stop a runaway query or idle compute from burning money overnight
- Evaluate with a free tier or trial — real queries on real data without a credit card or a sales call
- Dbt is a first-class citizen — a documented adapter or native dbt project support with vendor docs to match
- Bulk-load CSV, JSON, and Parquet from cloud object storage with a single documented command
- A managed service continuously ingests new files or events as they arrive, without me running my own pipeline infrastructure
- First-party notebooks let me mix SQL and Python against warehouse data, with results and charts inline
- Export all of my data in open formats and leave
- Inspect query profiles and execution plans to find why a query is slow or expensive
- I get a full analytical SQL surface — window functions, CTEs, semi-structured JSON, arrays, and rich date/time types — without bolt-on extensions
GitHub README6 stories
- Drive the product through a documented public API
- Build against official SDKs
- Explore an interactive API reference with runnable examples
- Download a machine-readable API spec (OpenAPI or equivalent)
- Rely on versioned APIs with a documented deprecation policy
- Do everything through the API that I can do in the UI
OpenAPI spec4 stories
En docs3 stories
- The pricing model is documented clearly enough that I can estimate a monthly bill for my workload before committing
- Evaluate with a free tier or trial — real queries on real data without a credit card or a sales call
- Share live datasets with another account or organization without copying data or building an export pipeline
snowflake.com2 stories
Probe proofs — replayable recordings from the probe harnessProbe proofs
Replayable recordings from our probe harness — see the Prove-It protocol to submit one.
$uvx --from snowflake-cli snow sql --helpreproduced$ uvx --from snowflake-cli snow sql --help
⠋ Resolving dependencies...
⠙ Resolving dependencies...
⠋ Resolving dependencies...
⠙ Resolving dependencies...
⠙ snowflake-cli==3.26.0
⠙ click==8.1.8
⠙ gitpython==3.1.58
⠙ id==1.5.0
⠙ jinja2==3.1.6
⠙ packaging==25.0
⠙ pip==26.2.1
⠙ pluggy==1.6.0
⠙ prompt-toolkit==3.0.51
⠙ pydantic==2.12.5
⠙ python-dotenv==1.2.2
⠙ pyyaml==6.0.2
⠙ requests==2.33.0
⠙ requirements-parser==0.13.0
⠙ rich==14.0.0
⠙ setuptools==80.8.0
⠙ snowflake-connector-python==4.7.1
⠙ snowflake-connector-python==4.7.1
Usage: snow sql [OPTIONS]
Executes Snowflake query.
Use either query, filename or input option.
Query to execute can be specified using query option, filename option (all
queries from file will be executed) or via stdin by piping output from other
command. For example cat my.sql | snow sql -i.
The command supports variable substitution that happens on client-side.
╭─ Options ────────────────────────────────────────────────────────────────────╮
│ --query -q TEXT Query to │
│ execute. │
│ --filename -f FILE File to execute. │
│ --stdin -i Read the query │
│ from standard │
│ input. Use it │
│ when piping │
│ input to this │
│ command. │
│ --variable -D TEXT String in format │
│ of [redacted]=value. If │
│ provided the SQL │
│ content will be │
│ treated as │
│ template and │
│ rendered using │
│ provided data. │
│ --retain-comments Retains comments │
│ in queries │
│ passed to │
│ Snowflake │
│ --single-transac… --no-single-tr… Connects with │
│ autocommit │
│ disabled. Wraps │
│ BEGIN/COMMIT │
│ around │
│ statements to │
│ execute them as │
│ a single │
│ transaction, │
│ ensuring all │
│ commands │
│ complete │
│ successfully or │
│ no change is │
│ applied. │
│ [default: │
│ no-single-trans… │
│ --enable-templat… [LEGACY|STANDARD Syntax used to │
│ |JINJA|ALL|NONE] resolve │
│ variables before │
│ passing queries │
│ to Snowflake. │
│ [default: │
│ LEGACY, │
│ STANDARD] │
│ --local-only Restrict !source │
│ and !load to │
│ local files. │
│ When set, │
│ !source/!load │
│ directives that │
│ reference │
│ http:// or │
│ https:// URLs │
│ are rejected │
│ instead of being │
│ fetched. Use │
│ this flag in │
│ environments │
│ where SQL inputs │
│ should not │
│ trigger outbound │
│ network │
│ requests, or │
│ when running SQL │
│ files whose │
│ content should │
│ be reviewed │
│ locally before │
│ execution. [env │
│ var: │
│ SNOWFLAKE_CLI_S… │
│ | config: │
│ cli.sql_local_o… │
│ --no-prompt-exit… Do not prompt │
│ before exiting │
│ the REPL. │
│ --project -p TEXT Path where the │
│ Snowflake │
│ project is │
│ stored. Defaults │
│ to the current │
│ working │
│ directory. │
│ --env TEXT String in the │
│ format │
│ [redacted]=value. │
│ Overrides │
│ variables from │
│ the env section │
│ used for │
│ templates. │
│ --help -h Show this │
│ message and │
│ exit. │
╰──────────────────────────────────────────────────────────────────────────────╯
╭─ Connection configuration ───────────────────────────────────────────────────╮
│ --connection,--environment -c TEXT Name of the connection, as │
│ defined in your config.toml │
│ file. Default: default. │
│ --host TEXT Host address for the │
│ connection. Overrides the │
│ value specified for the │
│ connection. │
│ --port INTEGER Port for the connection. │
│ Overrides the value specified │
│ for the connection. │
│ --protocol TEXT Protocol to use for the │
│ connection, for example │
│ https. Overrides the value │
│ specified for the connection. │
│ --account,--accountname TEXT Name assigned to your │
│ Snowflake account. Overrides │
│ the value specified for the │
│ connection. │
│ --user,--username TEXT Username to connect to │
│ Snowflake. Overrides the │
│ value specified for the │
│ connection. │
│ --password TEXT Snowflake password. Overrides │
│ the value specified for the │
│ connection. │
│ --authenticator TEXT Snowflake authenticator. │
│ Overrides the value specified │
│ for the connection. │
│ --workload-identity-provider TEXT Workload identity provider │
│ (AWS, AZURE, GCP, OIDC). │
│ Overrides the value specified │
│ for the connection │
│ --private-[redacted]-file,--privat… TEXT Snowflake private [redacted] file │
│ path. Overrides the value │
│ specified for the connection. │
│ --[redacted] TEXT OAuth [redacted] to use when │
│ connecting to Snowflake. │
│ --[redacted]-file-path TEXT Path to file with an OAuth │
│ [redacted] to use when connecting │
│ to Snowflake. │
│ --database,--dbname TEXT Database to use. Overrides │
│ the value specified for the │
│ connection. │
│ --schema,--schemaname TEXT Database schema to use. │
│ Overrides the value specified │
│ for the connection. │
│ --role,--rolename TEXT Role to use. Overrides the │
│ value specified for the │
│ connection. │
│ --warehouse TEXT Warehouse to use. Overrides │
│ the value specified for the │
│ connection. │
│ --temporary-connection -x Uses a connection defined │
│ with command-line parameters, │
│ instead of one defined in │
│ config │
│ --mfa-passcode TEXT [redacted] to use for multi-factor │
│ authentication (MFA) │
│ --enable-diag Whether to generate a │
│ connection diagnostic report. │
│ --diag-log-path TEXT Path for the generated │
│ report. Defaults to system │
│ temporary directory. │
│ --diag-allowlist-path TEXT Path to a JSON file that │
│ contains allowlist │
│ parameters. │
│ --oauth-client-id TEXT Value of client id provided │
│ by the Identity Provider for │
│ Snowflake integration. │
│ --oauth-client-secret TEXT Value of the client secret │
│ provided by the Identity │
│ Provider for Snowflake │
│ integration. │
│ --oauth-authorization-url TEXT Identity Provider endpoint │
│ supplying the authorization │
│ code to the driver. │
│ --oauth-[redacted]-request-url TEXT Identity Provider endpoint │
│ supplying the access [redacted]s │
│ to the driver. │
│ --oauth-redirect-uri TEXT URI to use for authorization │
│ code redirection. │
│ --oauth-scope TEXT Scope requested in the │
│ Identity Provider │
│ authorization request. │
│ --oauth-disable-pkce Disables Proof [redacted] for Code │
│ Exchange (PKCE). Default: │
│ False. │
│ --oauth-enable-refresh-toke… Enables a silent │
│ re-authentication when the │
│ actual access [redacted] becomes │
│ outdated. Default: False. │
│ --oauth-enable-single-use-r… Whether to opt-in to │
│ single-use refresh [redacted] │
│ semantics. Default: False. │
│ --client-store-temporary-cr… Store the temporary │
│ credential. │
│ --secondary-roles TEXT Secondary roles mode applied │
│ when the session starts. │
│ Supported values are ALL and │
│ NONE; pass NONE to run the │
│ session only with the primary │
│ role. │
│ --server-session-keep-alive Keep the session active │
│ indefinitely, even if there │
│ is no activity from the user. │
╰──────────────────────────────────────────────────────────────────────────────╯
╭─ Global configuration ───────────────────────────────────────────────────────╮
│ --format [TABLE|JSON|JSON_EXT| Specifies the output │
│ CSV] format. │
│ [default: TABLE] │
│ --verbose -v Displays log entries │
│ for log levels info │
│ and higher. │
│ --debug Displays log entries │
│ for log levels debug │
│ and higher; debug logs │
│ contain additional │
│ information. │
│ --silent Turns off intermediate │
│ output to console. │
│ --enhanced-exit-codes Differentiate exit │
│ error codes based on │
│ failure type. │
│ [env var: │
│ SNOWFLAKE_ENHANCED_EX… │
│ --decimal-precision INTEGER Number of decimal │
│ places to display for │
│ decimal values. Uses │
│ Python's default │
│ precision if not │
│ specified. [env var: │
│ SNOWFLAKE_DECIMAL_PRE… │
╰──────────────────────────────────────────────────────────────────────────────╯
$uvx --from snowflake-cli snow --versionreproduced$ uvx --from snowflake-cli snow --version ⠋ Resolving dependencies... ⠙ Resolving dependencies... ⠋ Resolving dependencies... ⠙ Resolving dependencies... ⠙ snowflake-cli==3.26.0 ⠙ click==8.1.8 ⠙ gitpython==3.1.58 ⠙ id==1.5.0 ⠙ jinja2==3.1.6 ⠙ packaging==25.0 ⠙ pip==26.2.1 ⠙ pluggy==1.6.0 ⠙ prompt-toolkit==3.0.51 ⠙ pydantic==2.12.5 ⠙ python-dotenv==1.2.2 ⠙ pyyaml==6.0.2 ⠙ requests==2.33.0 ⠙ requirements-parser==0.13.0 ⠙ rich==14.0.0 ⠙ setuptools==80.8.0 ⠙ snowflake-connector-python==4.7.1 ⠙ snowflake-connector-python==4.7.1 Snowflake CLI version: 3.26.0
Claims vs evidence — vendor claims reconciled against independent verdictsClaims vs evidence
8 of 20 testable claims verified · 1 contradicted → integrity 30/100
31 distinct capability claims found in Snowflake’s own claimed-docs/GitHub materials, reconciled against our judge’s independent verdicts.
8
Verified
11
Unverified
1
Contradicted
24
Undersold
Verified (15)
“CLI lets developers create, manage, update, and view apps across Streamlit, Native Apps, Snowpark Container Services, and Snowpark”
“dbt Projects on Snowflake brings the full dbt lifecycle (develop, deploy, orchestrate, observe) natively into Snowflake”
Dbt is a first-class citizen — a documented adapter or native dbt project support with vendor docs to matchfullproof ↗
“Documented migration path for moving an existing dbt Core project into dbt Projects on Snowflake”
Dbt is a first-class citizen — a documented adapter or native dbt project support with vendor docs to matchfullproof ↗
“Snowpipe loads data from files in micro-batches as soon as they land in a stage, without scheduled COPY jobs”
A managed service continuously ingests new files or events as they arrive, without me running my own pipeline infrastructurefullproof ↗
“Notebooks provide cell-by-cell interactive SQL/Python development and execution”
First-party notebooks let me mix SQL and Python against warehouse data, with results and charts inlinefullproof ↗
“Snowflake-managed MCP server lets AI agents securely retrieve data without deploying separate infrastructure”
“Per-user quotas are generally available for controlling resource/cost limits”
Budgets, resource monitors, or auto-suspend stop a runaway query or idle compute from burning money overnightfullproof ↗
“Anomaly monitors detect cost anomalies (preview)”
Budgets, resource monitors, or auto-suspend stop a runaway query or idle compute from burning money overnightfullproof ↗
“Notification integrations send alerts for cost anomalies (GA)”
Budgets, resource monitors, or auto-suspend stop a runaway query or idle compute from burning money overnightfullproof ↗
“Virtual warehouses are user-managed, letting you directly control their credit consumption”
Budgets, resource monitors, or auto-suspend stop a runaway query or idle compute from burning money overnightfullproof ↗
“Resource monitors can suspend a warehouse or disable an Adaptive Warehouse once a credit limit is reached”
Budgets, resource monitors, or auto-suspend stop a runaway query or idle compute from burning money overnightfullproof ↗
“Query History page in Snowsight lets you monitor individual or grouped queries executed by users”
Inspect query profiles and execution plans to find why a query is slow or expensivefullproof ↗
“MCP server can be configured to expose Cortex Analyst, Cortex Search, Cortex Agents, and custom tools/SQL execution”
“Full SQL window function support for running totals, moving averages, and rankings”
I get a full analytical SQL surface — window functions, CTEs, semi-structured JSON, arrays, and rich date/time types — without bolt-on extensionspartialproof ↗
“Native semi-structured SQL types (VARIANT/OBJECT/ARRAY) make JSON and arrays first-class in queries”
I get a full analytical SQL surface — window functions, CTEs, semi-structured JSON, arrays, and rich date/time types — without bolt-on extensionspartialproof ↗
Unverified (13)
“Time Travel lets you query data as it existed in the past, even after it's been updated or deleted”
Time-travel — query data as of a past point and restore dropped or corrupted tables from historyfullproof ↗
“Stream objects capture DML changes (inserts, updates, deletes) on tables plus metadata so downstream actions can consume the changes”
Run continuous or incremental transformations — streams, tasks, declarative pipelines, or continuous queries — inside the platformfullproof ↗
“Role-based access control assigns privileges to roles which are then granted to users”
Access control reaches tables, columns, and rows — roles plus masking policies — so one warehouse can serve many teams safelypartialproof ↗
“Secure Data Sharing lets you share database objects with other Snowflake accounts without copying or transferring data”
Share live datasets with another account or organization without copying data or building an export pipelinefullproof ↗
“Semantic Views let you store business metrics and model business entities/relationships as a schema-level object”
Define a governed semantic model — metrics, dimensions, and joins declared once — that queries and AI tools answer against consistentlyfullproof ↗
“Cortex AI Functions run unstructured analytics on text and images using LLMs from OpenAI, Anthropic, Meta, Mistral, and DeepSeek”
Get AI-generated insights and suggestions from my data inside the productfullproof ↗
“Cortex Analyst lets business users ask natural-language questions and get direct answers without writing SQL”
Business users can ask questions in natural language and get governed, semantically-grounded answers rather than hallucinated joinsfullproof ↗
“CREATE OR ALTER DYNAMIC TABLE provides declarative, incrementally-refreshed pipeline tables (GA)”
Run continuous or incremental transformations — streams, tasks, declarative pipelines, or continuous queries — inside the platformfullproof ↗
“Snowflake CoWork/CoCo provide an enterprise-wide built-in AI assistant to ask and build things”
Delegate tasks to a built-in AI assistant inside the productpartialproof ↗
“Deleted objects (tables or whole containers) can be restored from history”
Time-travel — query data as of a past point and restore dropped or corrupted tables from historyfullproof ↗
“Access History view tracks when queries read data and when statements perform writes, for auditing”
I get audit logs of who ran what and column-level lineage of where data came frompartialproof ↗
“Apache Iceberg tables combine Snowflake table performance with externally-managed cloud storage”
Query open table formats and files in object storage — Iceberg, Delta, Parquet — without first loading them into proprietary storagefullproof ↗
“Documented compliance certifications include SOC 1/2 Type II, ISO 27001/27017/27018, FedRAMP Moderate/High, and PCI DSS”
Compliance attestations (SOC 2, HIPAA, PCI) are documented so security review does not stall the rolloutfullproof ↗
Contradicted (1)
“Standard edition offers an entry-level tier with core functionality, encryption, Snowpark, and data sharing”
The pricing model is documented clearly enough that I can estimate a monthly bill for my workload before committingdisputedproof ↗
Undersold (24)
My agent can run governed SQL end to end — authenticate, discover schemas, query, and read results back through a CLI or API with no dashboard in the loopfullproof ↗
A built-in AI assistant writes, fixes, and explains SQL against my schemas from natural language, inside the productpartialproof ↗
Point an agent at llms.txt or agent-oriented docsfullproof ↗
Run the product headlessly / in CI for automationfullproof ↗
Drive the product through a documented public APIfullproof ↗
Issue scoped/least-privilege API credentials for an agentpartialproof ↗
Set up automations that run autonomously in the backgroundpartialproof ↗
Operate the product with natural-language commandspartialproof ↗
Explore an interactive API reference with runnable examplespartialproof ↗
Download a machine-readable API spec (OpenAPI or equivalent)fullproof ↗
Test against a sandbox environment without touching production datapartialproof ↗
Rely on versioned APIs with a documented deprecation policypartialproof ↗
Perform bulk operations across many items at oncepartialproof ↗
Define rules that trigger actions automatically on eventspartialproof ↗
Evaluate with a free tier or trial — real queries on real data without a credit card or a sales callpartialproof ↗
First-party and partner connectors cover my sources — SaaS apps, databases, and ETL/ELT tools — with documented setuppartialproof ↗
Bulk-load CSV, JSON, and Parquet from cloud object storage with a single documented commandpartialproof ↗
Do everything through the API that I can do in the UIpartialproof ↗
Export all of my data in open formats and leavepartialproof ↗
Streaming writes land queryable within seconds through a documented streaming ingestion APIpartialproof ↗
Claims outside our story set (2)
Real capability claims found in Snowflake’s own materials, but no story in this arena’s taxonomy covers them yet — that’s feedback on the taxonomy, not a mark against the product.
“Virtual warehouses can be resized at any time, even while running, to add or remove compute”
source ↗“Snowflake data can be used for exploratory data analysis, ML model development, and data science/engineering workflows”
source ↗
Business model
Consumption pricing: compute billed per-second in credits by warehouse size and edition (Standard/Enterprise/Business Critical), storage per TB/month; 30-day free trial with credits, capacity contracts for enterprises.
pricing ↗Score trend
How this product’s scores have moved as evidence and verdicts are re-derived — a point per change, not per day.
Try Experimental
Run it in the microterminal →Recorded agent sessions — and a live MCP handshake where the vendor ships one.
Flag
⚑ Flag a verdictThink a verdict is wrong? Opens a prefilled GitHub issue — or use the ⚑ next to any verdict above.
For agents
Agent surface uptime llms.txt 100% (30d, checked every 6h since Sep 8 '26)