<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/dynamic-model-routing-open-models-in-snowflake-cortex-ai-rfbvecf1g" -->

---
title: Dynamic Model Routing &amp; Open Models in Snowflake Cortex AI
description: Snowflake is adding dynamic model routing to its Cortex AI Gateway, which automatically selects the cheapest model capable of confidently completing each step...
canonical: https://daily.dev/posts/dynamic-model-routing-open-models-in-snowflake-cortex-ai-rfbvecf1g
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: Dynamic Model Routing &amp; Open Models in Snowflake Cortex AI | daily.dev
og:description: Snowflake is adding dynamic model routing to its Cortex AI Gateway, which automatically selects the cheapest model capable of confidently completing each step...
og:url: https://daily.dev/posts/dynamic-model-routing-open-models-in-snowflake-cortex-ai-rfbvecf1g
og:image: https://api.daily.dev/og/posts/RFbVEcF1g.png
og:image:alt: Dynamic Model Routing &amp; Open Models in Snowflake Cortex AI
og:image:width: 1200
og:image:height: 630
og:locale: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Dynamic Model Routing & Open Models in Snowflake Cortex AI

**[Snowflake](https://daily.dev/sources/snowflake)** · 6 min read · 0 upvotes · 0 comments

## Summary

Snowflake is adding dynamic model routing to its Cortex AI Gateway, which automatically selects the cheapest model capable of confidently completing each step of an agent task, escalating to frontier models only when deeper reasoning is needed. The feature (private preview soon) works within existing governance controls, respects data residency, and logs every routing decision. Internal tests showed up to 3x token efficiency on a dbt pipeline workload and about 25% fewer tokens on a coding workload with similar throughput. Snowflake is also expanding open model access with DeepSeek-V4-Flash 0731 (private preview) and GLM-5.3 (coming soon), joining existing models from Anthropic, Google, OpenAI, xAI, Mistral and Meta. DeepSeek-V4-Flash reportedly scored 74.4% on ADE-bench using Snowflake's CoCo agent harness, ahead of the leading proprietary model tested, while GLM-5.2 scored 66% with the lowest token footprint in the benchmark.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.snowflake.com/en/blog/dynamic-model-routing-open-models-cortex-ai>

## Questions this post answers

### What is dynamic model routing in Snowflake Cortex AI Gateway?

Dynamic model routing is a Cortex AI Gateway capability (private preview soon) that automatically selects the most affordable model able to confidently complete each step of an agent task, escalating to frontier models only when deeper reasoning is required. It operates within existing governance controls, only considers administrator-approved models, respects data residency settings, and logs every routing decision for compliance visibility.

_Enterprises weighing AI cost control against quality can follow routing approaches like this via daily.dev._

### How much can AI model routing reduce token usage compared to always using a frontier model?

In internal Snowflake testing, dynamic model routing completed a dbt pipeline workload with up to three times greater token efficiency than a frontier-model-only approach while maintaining comparable quality, and in a separate coding-workload test engineering teams kept the same pull-request throughput while using roughly 25% fewer tokens.

_Teams tracking real-world token efficiency gains from AI routing can follow these benchmarks on daily.dev._

### How does DeepSeek-V4-Flash perform compared to proprietary models on data engineering benchmarks?

DeepSeek-V4-Flash scored 74.4% on ADE-bench when evaluated using Snowflake's CoCo agent harness, outperforming the leading proprietary model tested in that evaluation. ADE-bench is a framework created by dbt for evaluating AI agents on real-world analytics and data engineering tasks, and the earlier GLM-5.2 model scored 66% with the lowest token footprint among models tested.

_Developers comparing open versus proprietary models for data engineering agents can track benchmarks like this on daily.dev._

## Similar posts on daily.dev

- [Snowflake Unlocks Better AI Economics with Dynamic Model Routing](https://daily.dev/posts/snowflake-unlocks-better-ai-economics-with-dynamic-model-routing-ia2m0zeyl) · SD Times · 0 upvotes · 0 comments
- [Maximize AI Impact: More Model Choice, Smarter Routing](https://daily.dev/posts/maximize-ai-impact-more-model-choice-smarter-routing-4poexm3e3) · Snowflake · 0 upvotes · 0 comments
- [Snowflake adds Google Gemini support](https://daily.dev/posts/snowflake-adds-google-gemini-support-0cxkgm4ev) · The Register · 0 upvotes · 0 comments
- [Snowflake Cortex Code CLI adds dbt and Apache Airflow support for AI-powered data pipelines](https://daily.dev/posts/snowflake-cortex-code-cli-adds-dbt-and-apache-airflow-support-for-ai-powered-data-pipelines-yrixxu8v0) · The New Stack · 1 upvotes · 0 comments
- [Mastering AI Cost and Access: The Imperative of Governance for Snowflake Cortex Code](https://daily.dev/posts/mastering-ai-cost-and-access-the-imperative-of-governance-for-snowflake-cortex-code-ildudcind) · Snowflake Community · 1 upvotes · 0 comments

---

Tags: [#snowflake](https://daily.dev/tags/snowflake), [#deepseek](https://daily.dev/tags/deepseek)

[View this post on daily.dev](https://daily.dev/posts/dynamic-model-routing-open-models-in-snowflake-cortex-ai-rfbvecf1g)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@type":"TechArticle","headline":"Dynamic Model Routing & Open Models in Snowflake Cortex AI","url":"https://daily.dev/posts/dynamic-model-routing-open-models-in-snowflake-cortex-ai-rfbvecf1g","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/dynamic-model-routing-open-models-in-snowflake-cortex-ai-rfbvecf1g"},"datePublished":"2026-08-18T14:25:26.355Z","dateModified":"2026-08-18T14:46:24.768Z","description":"Snowflake is adding dynamic model routing to its Cortex AI Gateway, which automatically selects the cheapest model capable of confidently completing each step...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/70dcc527d94e34a0b3abe31ca98fb6e4?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/70dcc527d94e34a0b3abe31ca98fb6e4?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Snowflake","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Snowflake","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/fd3e7ffcdf2c438db701a0c6b34281ca","url":"https://daily.dev/sources/snowflake"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/dynamic-model-routing-open-models-in-snowflake-cortex-ai-rfbvecf1g","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"snowflake,deepseek","timeRequired":"PT6M"}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Snowflake","item":"https://daily.dev/sources/snowflake"},{"@type":"ListItem","position":3,"name":"Dynamic Model Routing & Open Models in Snowflake Cortex AI"}]}
{"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/dynamic-model-routing-open-models-in-snowflake-cortex-ai-rfbvecf1g#faq","mainEntity":[{"@type":"Question","name":"What is dynamic model routing in Snowflake Cortex AI Gateway?","acceptedAnswer":{"@type":"Answer","text":"Dynamic model routing is a Cortex AI Gateway capability (private preview soon) that automatically selects the most affordable model able to confidently complete each step of an agent task, escalating to frontier models only when deeper reasoning is required. It operates within existing governance controls, only considers administrator-approved models, respects data residency settings, and logs every routing decision for compliance visibility. Enterprises weighing AI cost control against quality can follow routing approaches like this via daily.dev."}},{"@type":"Question","name":"How much can AI model routing reduce token usage compared to always using a frontier model?","acceptedAnswer":{"@type":"Answer","text":"In internal Snowflake testing, dynamic model routing completed a dbt pipeline workload with up to three times greater token efficiency than a frontier-model-only approach while maintaining comparable quality, and in a separate coding-workload test engineering teams kept the same pull-request throughput while using roughly 25% fewer tokens. Teams tracking real-world token efficiency gains from AI routing can follow these benchmarks on daily.dev."}},{"@type":"Question","name":"How does DeepSeek-V4-Flash perform compared to proprietary models on data engineering benchmarks?","acceptedAnswer":{"@type":"Answer","text":"DeepSeek-V4-Flash scored 74.4% on ADE-bench when evaluated using Snowflake's CoCo agent harness, outperforming the leading proprietary model tested in that evaluation. ADE-bench is a framework created by dbt for evaluating AI agents on real-world analytics and data engineering tasks, and the earlier GLM-5.2 model scored 66% with the lowest token footprint among models tested. Developers comparing open versus proprietary models for data engineering agents can track benchmarks like this on daily.dev."}}]}
```

