How Snowflake’s scores are calculated
The full audit trail, recomputed from the verdict data at build time through the same code that produced the leaderboard: verdict × quality × story weight per cell, cells sum to dimension scores, dimensions blend into the PA Score. Every number on the product page is reproducible from this page alone; for why the formula looks like this, see the methodology.
verdict factors: full ×1.0 · partial ×0.6 · disputed ×0.3 · none ×0.0 · n/a excluded from both sides · cell points = weight × quality × factor · cell max = weight × 10
PA Score43/100
Agent-ready 57.6 × 0.30 = 17.28
API quality 42.6 × 0.20 = 8.52
Openness 32.4 × 0.20 = 6.48
Built-in AI 41.8 × 0.15 = 6.27
Automation 31.5 × 0.15 = 4.72
(17.28 + 8.52 + 6.48 + 6.27 + 4.72) ÷ (0.30 + 0.20 + 0.20 + 0.15 + 0.15) = 43.27 ÷ 1.00 = 43.3
Scores are stored to 1 decimal; the product page’s pills round to whole numbers for display. Each dimension below shows the stories, verdicts, and cited evidence behind its number.
Agent-ready57.6/100×0.30 of the PA blend
Outside-in: can YOUR agent reach and drive this product — API, MCP, CLI, headless runs, agent docs.
Point an agent at llms.txt or agent-oriented docsweight 2
2 (weight) × 9 (quality) × 1.0 (full) = 18.0 of 20 max
- [probe] https://docs.snowflake.com/llms.txt“PROBE llms.txt: HTTP 200 at https://docs.snowflake.com/llms.txt # Snowflake Documentation > Snowflake is a cloud data platform providing data warehousing, > data lakes, data sharing,”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowpark/llms.txt“Snowpark API for Python, Java, and Scala — process data at scale inside Snowflake.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/streamlit/llms.txt“Build and deploy interactive Streamlit apps directly inside Snowflake.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-postgres/llms.txt“Managed Postgres instances running directly inside Snowflake.”
Run the product headlessly / in CI for automationweight 2
2 (weight) × 8 (quality) × 1.0 (full) = 16.0 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-cli/index“With Snowflake CLI, developers can create, manage, update, and view apps running on Snowflake across workloads such as Streamlit in Snowflake, the Snowflake Native App Framework, Snowpark Container Services, and Snowpark.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“You can use this API to develop custom applications and integrations that: Perform queries, Manage your deployment (e.g. provision users and roles, create tables, etc.)”
- [probe] https://docs.snowflake.com/en/developer-guide/snowflake-cli/index“official CLI documented at https://docs.snowflake.com/en/developer-guide/snowflake-cli/index”
Plug MCP servers into this product so it can use their toolsweight 3
3 (weight) × 0 (quality) × 0.0 (none) = 0.0 of 30 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“The Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to deploy separate infrastructure.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“You can configure the MCP server to serve Cortex Analyst, Cortex Search, and Cortex Agents as tools, along with custom tools and SQL executions”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“The Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to”
- [probe] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“official MCP server documented at https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp”
Connect an agent via an official MCP serverweight 3
3 (weight) × 9 (quality) × 1.0 (full) = 27.0 of 30 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“The Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to deploy separate infrastructure.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“You can configure the MCP server to serve Cortex Analyst, Cortex Search, and Cortex Agents as tools, along with custom tools and SQL executions”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“The Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to”
- [probe] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“official MCP server documented at https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp”
Use an official CLIweight 2
2 (weight) × 8 (quality) × 1.0 (full) = 16.0 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-cli/index“With Snowflake CLI, developers can create, manage, update, and view apps running on Snowflake across workloads such as Streamlit in Snowflake, the Snowflake Native App Framework, Snowpark Container Services, and Snowpark.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-cli/index“developers can create, manage, update, and view apps running on Snowflake across workloads”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-cli/index“developers can create, manage, update, and view apps running on Snowflake across workloads such as Streamlit in Snowflake, the Snowflake Native App Framework, Snowpark Container Services, and Snowpark”
- [probe] https://docs.snowflake.com/en/developer-guide/snowflake-cli/index“official CLI documented at https://docs.snowflake.com/en/developer-guide/snowflake-cli/index”
Drive the product through a documented public APIweight 3
3 (weight) × 8 (quality) × 1.0 (full) = 24.0 of 30 max
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“You can use this API to develop custom applications and integrations that: Perform queries, Manage your deployment (e.g. provision users and roles, create tables, etc.)”
- [claimed-docs] https://github.com/snowflakedb/snowflake-rest-api-specs“Official snowflakedb/snowflake-rest-api-specs repo (specifications/ + collections/): "These REST APIs are compliant with the OpenAPI specification. Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications", with importable Postman collections.”
- [probe] https://docs.snowflake.com/openapi.json“PROBE openapi: all candidate paths 404 (https://docs.snowflake.com/openapi.json, https://docs.snowflake.com/swagger.json, https://docs.snowflake.com/api/openapi.json, https://docs.snowflake.com/.well-known/openapi.json)”
Issue scoped/least-privilege API credentials for an agentweight 2
2 (weight) × 5 (quality) × 0.6 (partial) = 6.0 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/security-access-control-overview“Role-based Access Control (RBAC): Access privileges are assigned to roles, which are in turn assigned to users.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/security-access-control-overview“Access privileges are assigned to roles, which are in turn assigned to users.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/security-access-control-overview“Role-based Access Control (RBAC): Access privileges are assigned to roles, which are in turn assigned to users”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“The Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to deploy separate infrastructure.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“You can configure the MCP server to serve Cortex Analyst, Cortex Search, and Cortex Agents as tools, along with custom tools and SQL executions”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“The Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to”
Build against official SDKsweight 2
2 (weight) × 7 (quality) × 1.0 (full) = 14.0 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowpark/llms.txt“Snowpark API for Python, Java, and Scala — process data at scale inside Snowflake.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“You can use this API to develop custom applications and integrations that: Perform queries, Manage your deployment (e.g. provision users and roles, create tables, etc.)”
- [claimed-docs] https://github.com/snowflakedb/snowflake-rest-api-specs“Official snowflakedb/snowflake-rest-api-specs repo (specifications/ + collections/): "These REST APIs are compliant with the OpenAPI specification. Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications", with importable Postman collections.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“The Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to deploy separate infrastructure.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“You can configure the MCP server to serve Cortex Analyst, Cortex Search, and Cortex Agents as tools, along with custom tools and SQL executions”
- [probe] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“official MCP server documented at https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp”
Subscribe to events via webhooksweight 2
2 (weight) × 0 (quality) × 0.0 (none) = 0.0 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/streams-intro“A stream object records data manipulation language (DML) changes made to tables, including inserts (including COPY INTO), updates, and deletes, as well as metadata about each change, so that actions can be taken using the changed data.”
- [claimed-docs] https://docs.snowflake.com/en/release-notes/new-features“Notification integrations for cost anomaly alerts (General availability)”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/streams-intro“A stream object records data manipulation language (DML) changes made to tables... so that actions can be taken using the changed data”
Agent-ready = 121.0 ÷ 210 × 100 = 57.6
API quality42.6/100×0.20 of the PA blend
The programmable surface once an agent is there — machine-readable spec, interactive docs, sandbox, versioning discipline.
Explore an interactive API reference with runnable examplesweight 2
2 (weight) × 3 (quality) × 0.6 (partial) = 3.6 of 20 max
- [claimed-docs] https://github.com/snowflakedb/snowflake-rest-api-specs“Official snowflakedb/snowflake-rest-api-specs repo (specifications/ + collections/): "These REST APIs are compliant with the OpenAPI specification. Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications", with importable Postman collections.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“You can use this API to develop custom applications and integrations that: Perform queries, Manage your deployment (e.g. provision users and roles, create tables, etc.)”
- [probe] https://docs.snowflake.com/openapi.json“PROBE openapi: all candidate paths 404 (https://docs.snowflake.com/openapi.json, https://docs.snowflake.com/swagger.json, https://docs.snowflake.com/api/openapi.json, https://docs.snowflake.com/.well-known/openapi.json)”
Download a machine-readable API spec (OpenAPI or equivalent)weight 2
2 (weight) × 8 (quality) × 1.0 (full) = 16.0 of 20 max
- [claimed-docs] https://github.com/snowflakedb/snowflake-rest-api-specs“Official snowflakedb/snowflake-rest-api-specs repo (specifications/ + collections/): "These REST APIs are compliant with the OpenAPI specification. Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications", with importable Postman collections.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.”
- [probe] https://docs.snowflake.com/openapi.json“PROBE openapi: all candidate paths 404 (https://docs.snowflake.com/openapi.json, https://docs.snowflake.com/swagger.json, https://docs.snowflake.com/api/openapi.json, https://docs.snowflake.com/.well-known/openapi.json)”
Test against a sandbox environment without touching production dataweight 1
1 (weight) × 5 (quality) × 0.6 (partial) = 3.0 of 10 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/object-clone“the clone inherits all granted privileges on the clones of all child objects contained in the source object”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/object-clone“If the source object is a database or schema, the clone inherits all granted privileges on the clones of all child objects contained in the source object”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/security-access-control-overview“Role-based Access Control (RBAC): Access privileges are assigned to roles, which are in turn assigned to users.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/security-access-control-overview“Access privileges are assigned to roles, which are in turn assigned to users.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/security-access-control-overview“Role-based Access Control (RBAC): Access privileges are assigned to roles, which are in turn assigned to users”
Rely on versioned APIs with a documented deprecation policyweight 2
2 (weight) × 6 (quality) × 0.6 (partial) = 7.2 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database.”
- [claimed-docs] https://github.com/snowflakedb/snowflake-rest-api-specs“Official snowflakedb/snowflake-rest-api-specs repo (specifications/ + collections/): "These REST APIs are compliant with the OpenAPI specification. Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications", with importable Postman collections.”
- [claimed-docs] https://docs.snowflake.com/en/release-notes/behavior-changes“Docs, "Behavior change announcements": "To help you manage your operations and minimize disruption to your Snowflake service, we document behavior changes that may impact your usage", organized into dated behavior change bundles plus "Unbundled behavior changes".”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“You can use this API to develop custom applications and integrations that: Perform queries, Manage your deployment (e.g. provision users and roles, create tables, etc.)”
API quality = 29.8 ÷ 70 × 100 = 42.6
Openness32.4/100×0.20 of the PA blend
Can you leave, inspect, or self-host — data export, open source, portability.
Do everything through the API that I can do in the UIweight 2
2 (weight) × 6 (quality) × 0.6 (partial) = 7.2 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“You can use this API to develop custom applications and integrations that: Perform queries, Manage your deployment (e.g. provision users and roles, create tables, etc.)”
- [claimed-docs] https://github.com/snowflakedb/snowflake-rest-api-specs“Official snowflakedb/snowflake-rest-api-specs repo (specifications/ + collections/): "These REST APIs are compliant with the OpenAPI specification. Snowflake REST APIs enable developers and partners to use the language of their choice to build integrations with Snowflake using the openAPI specifications", with importable Postman collections.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-cli/index“With Snowflake CLI, developers can create, manage, update, and view apps running on Snowflake across workloads such as Streamlit in Snowflake, the Snowflake Native App Framework, Snowpark Container Services, and Snowpark.”
- [probe] https://docs.snowflake.com/openapi.json“PROBE openapi: all candidate paths 404 (https://docs.snowflake.com/openapi.json, https://docs.snowflake.com/swagger.json, https://docs.snowflake.com/api/openapi.json, https://docs.snowflake.com/.well-known/openapi.json)”
Export all of my data in open formats and leaveweight 3
3 (weight) × 5 (quality) × 0.6 (partial) = 9.0 of 30 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/tables-iceberg“Apache Iceberg™ tables for Snowflake combine the performance and query semantics of typical Snowflake tables with external cloud storage that you manage.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/tables-iceberg“They are ideal for existing data lakes that you cannot, or choose not to, store in Snowflake.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database.”
- [community] https://news.ycombinator.com/item?id=32551212“I predict we'll see more people choosing Clickhouse over Snowflake in the next 5 years... and give people a better escape hatch if they want to self-host their data stack.”
Read the product's source under an open licenseweight 2
n/a — not applicable to this product: excluded from numerator and denominator
no evidence cited — the verdict rests on absence of evidence, re-checked on refresh
Self-host the core productweight 3
n/a — not applicable to this product: excluded from numerator and denominator
no evidence cited — the verdict rests on absence of evidence, re-checked on refresh
Openness = 16.2 ÷ 50 × 100 = 32.4
Built-in AI41.8/100×0.15 of the PA blend
Inside-out: how agentic the product itself is for its users — built-in assistants, autonomous features.
Get AI-generated insights and suggestions from my data inside the productweight 2
2 (weight) × 8 (quality) × 1.0 (full) = 16.0 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/aisql“Use Cortex AI Functions in Snowflake to run unstructured analytics on text and images with industry-leading LLMs from OpenAI, Anthropic, Meta, Mistral AI, and DeepSeek.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-analyst“With Cortex Analyst, business users can ask questions in natural language and receive direct answers without writing SQL.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-analyst“business users can ask questions in natural language and receive direct answers without writing SQL”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/aisql“Use Cortex AI Functions in Snowflake to run unstructured analytics on text and images with industry-leading LLMs”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/views-semantic/overview“You can store semantic business concepts directly in the database in a Semantic View, which is a schema-level object. You can define business metrics and model business entities and their relationships.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/views-semantic/overview“You can store semantic business concepts directly in the database in a Semantic View ... define business metrics and model business entities and their relationships.”
Set up automations that run autonomously in the backgroundweight 2
2 (weight) × 5 (quality) × 0.6 (partial) = 6.0 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro“Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule”
- [claimed-docs] https://docs.snowflake.com/en/release-notes/new-features“CREATE OR ALTER DYNAMIC TABLE (General availability)”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/streams-intro“A stream object records data manipulation language (DML) changes made to tables, including inserts (including COPY INTO), updates, and deletes, as well as metadata about each change, so that actions can be taken using the changed data.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-engineering/dbt-projects-on-snowflake“dbt Projects on Snowflake brings the full dbt lifecycle into Snowflake: develop, deploy, orchestrate, and observe your transformations”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-engineering/dbt-projects-on-snowflake“No infrastructure to manage: Snowflake provides managed dbt Core and dbt Fusion runtimes.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“The Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to deploy separate infrastructure.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“You can configure the MCP server to serve Cortex Analyst, Cortex Search, and Cortex Agents as tools, along with custom tools and SQL executions”
Delegate tasks to a built-in AI assistant inside the productweight 3
3 (weight) × 4 (quality) × 0.6 (partial) = 7.2 of 30 max
- [claimed-docs] https://www.snowflake.com“Ask anything with Snowflake CoWork. Build anything with Snowflake CoCo. Welcome to your one-stop shop for everyone in the enterprise.”
- [claimed-docs] https://www.snowflake.com“Build anything with Snowflake CoCo.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-analyst“With Cortex Analyst, business users can ask questions in natural language and receive direct answers without writing SQL.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-analyst“business users can ask questions in natural language and receive direct answers without writing SQL”
Operate the product with natural-language commandsweight 2
2 (weight) × 7 (quality) × 0.6 (partial) = 8.4 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-analyst“With Cortex Analyst, business users can ask questions in natural language and receive direct answers without writing SQL.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-analyst“business users can ask questions in natural language and receive direct answers without writing SQL”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/aisql“Use Cortex AI Functions in Snowflake to run unstructured analytics on text and images with industry-leading LLMs from OpenAI, Anthropic, Meta, Mistral AI, and DeepSeek.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/aisql“Use Cortex AI Functions in Snowflake to run unstructured analytics on text and images with industry-leading LLMs”
- [claimed-docs] https://www.snowflake.com“Ask anything with Snowflake CoWork. Build anything with Snowflake CoCo. Welcome to your one-stop shop for everyone in the enterprise.”
- [claimed-docs] https://www.snowflake.com“Build anything with Snowflake CoCo.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“The Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to deploy separate infrastructure.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“You can configure the MCP server to serve Cortex Analyst, Cortex Search, and Cortex Agents as tools, along with custom tools and SQL executions”
Built-in AI = 37.6 ÷ 90 × 100 = 41.8
Automation31.5/100×0.15 of the PA blend
Depth of automation primitives — rules, scheduling, bulk operations, webhooks.
Perform bulk operations across many items at onceweight 2
2 (weight) × 6 (quality) × 0.6 (partial) = 7.2 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro“Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/streams-intro“A stream object records data manipulation language (DML) changes made to tables, including inserts (including COPY INTO), updates, and deletes, as well as metadata about each change, so that actions can be taken using the changed data.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api“Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/sql-api/index“The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database.”
- [claimed-docs] https://docs.snowflake.com/en/developer-guide/snowpark/llms.txt“Snowpark API for Python, Java, and Scala — process data at scale inside Snowflake.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“The Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to deploy separate infrastructure.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp“You can configure the MCP server to serve Cortex Analyst, Cortex Search, and Cortex Agents as tools, along with custom tools and SQL executions”
Define rules that trigger actions automatically on eventsweight 3
3 (weight) × 6 (quality) × 0.6 (partial) = 10.8 of 30 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/streams-intro“A stream object records data manipulation language (DML) changes made to tables, including inserts (including COPY INTO), updates, and deletes, as well as metadata about each change, so that actions can be taken using the changed data.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/streams-intro“A stream object records data manipulation language (DML) changes made to tables... so that actions can be taken using the changed data”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro“Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro“Snowpipe enables loading data from files as soon as they’re available in a stage”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/resource-monitors“You can use a resource monitor to monitor credit usage by virtual warehouses ... You can also set up a resource monitor to suspend a standard virtual warehouse or disable an Adaptive Warehouse when it reaches a credit limit.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/resource-monitors“you can set up a resource monitor to suspend a standard virtual warehouse or disable an Adaptive Warehouse when it reaches a credit limit”
- [claimed-docs] https://docs.snowflake.com/en/release-notes/new-features“Anomaly monitors for cost anomalies (Preview)”
- [claimed-docs] https://docs.snowflake.com/en/release-notes/new-features“Notification integrations for cost anomaly alerts (General availability)”
Schedule recurring jobs or workflowsweight 2
2 (weight) × 4 (quality) × 0.6 (partial) = 4.8 of 20 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-engineering/dbt-projects-on-snowflake“dbt Projects on Snowflake brings the full dbt lifecycle into Snowflake: develop, deploy, orchestrate, and observe your transformations in the same place your data already lives.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-engineering/dbt-projects-on-snowflake“dbt Projects on Snowflake brings the full dbt lifecycle into Snowflake: develop, deploy, orchestrate, and observe your transformations”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-engineering/dbt-projects-on-snowflake“No infrastructure to manage: Snowflake provides managed dbt Core and dbt Fusion runtimes.”
Version, review, and roll back my automationsweight 1
1 (weight) × 4 (quality) × 0.6 (partial) = 2.4 of 10 max
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-engineering/dbt-projects-on-snowflake“dbt Projects on Snowflake brings the full dbt lifecycle into Snowflake: develop, deploy, orchestrate, and observe your transformations in the same place your data already lives.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-engineering/dbt-projects-on-snowflake“dbt Projects on Snowflake brings the full dbt lifecycle into Snowflake: develop, deploy, orchestrate, and observe your transformations”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-time-travel“Using Time Travel, you can perform the following actions within a defined period of time: Query data in the past that has since been updated or deleted.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-time-travel“Restoring objects that might have been accidentally or intentionally deleted.”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/data-time-travel“Restoring objects that might have been accidentally or intentionally deleted. You can restore individual objects, such as tables, or restore all the objects inside a container object”
- [claimed-docs] https://docs.snowflake.com/en/user-guide/object-clone“the clone inherits all granted privileges on the clones of all child objects contained in the source object”
- [claimed-docs] https://docs.snowflake.com/en/release-notes/behavior-changes“Docs, "Behavior change announcements": "To help you manage your operations and minimize disruption to your Snowflake service, we document behavior changes that may impact your usage", organized into dated behavior change bundles plus "Unbundled behavior changes".”
Automation = 25.2 ÷ 80 × 100 = 31.5