AIToday
Large Language ModelsAI Business & IndustrySnowflake AI BlogPublished: Aug 19, 2026, 04:00 JST

Snowflake builds internal semantic layer to unify data for AI agents

Snowflake builds internal semantic layer to unify data for AI agents

3 Key Points

  1. What happened

    Snowflake built an internal semantic layer—a governed data abstraction that translates raw database tables into consistent business metrics and dimensions accessible to both AI agents and dashboards. In July 2025 alone, over 400 internal users ran more than 5,400 queries through the product data science agent using this semantic layer, while over 5,600 Snowflake employees across all teams ran over 320,000 queries through a broader semantic layer covering sales, HR, support and other functions.

  2. Why it matters

    Without a shared semantic context, the same question (e.g., 'What is an active customer?') yields conflicting answers across different tables and metric definitions. The semantic layer solves this by establishing one source of truth for data meaning, enabling AI agents to execute queries faster (avoiding the overhead of finding and understanding raw data sources) and more cost-efficiently (reducing token consumption and repeated computation). In AtScale's benchmark testing, adding semantic context increased text-to-SQL accuracy from 20% to more than 90% across 40 business questions.

  3. What to watch

    Snowflake integrated semantic views with dbt (a data build tool) for version control and CI/CD, and paired them with semantic view materializations that intelligently preaggregate metrics across specified dimension combinations to reduce query latency. The semantic views are also interoperable with Apache Ossie, an open standard for semantic models, allowing portability across tools and platforms.

Not sure about something? Ask the AI

Questions and answers are published on this page.

Summaries like this, in your inbox every morning.

Context & Analysis

Snowflake's internal challenge was not a shortage of data but a surfeit of conflicting context. The company collects petabytes of telemetry across queries, warehouses and user interactions, yet the same business question could yield multiple answers depending on which table and metric definition was consulted. This fragmentation makes it impossible for either humans or AI agents to trust a single version of the truth—a problem that compounds when AI systems are trained at scale on inconsistent definitions.

The semantic layer solves this by introducing a standardized translation layer between physical tables and downstream consumers. Instead of exposing raw data directly to dashboards or agents, a semantic view wraps those tables with governed business logic, dimensions (like region), and metrics (like compute spend). This consolidation delivers three concrete benefits: AI agents execute faster because they bypass the discovery and sampling phase; they consume fewer tokens because the semantic layer pre-materializes relationships and preaggregated data; and text-to-SQL accuracy soars because the model receives precise business context rather than raw column names.

Snowflake's own adoption metrics validate the pattern. Over 5,600 employees across multiple teams ran more than 320,000 queries in a single month (July 2025) through the unified layer, and the accuracy uplift from semantic context—jumping from 20% to over 90% in benchmark tests—demonstrates that this abstraction is not a convenience but a necessity for enterprises relying on AI agents to interpret data at scale.

FAQ
How many internal Snowflake users are using the semantic layer?
In July 2025 alone, more than 400 distinct internal users ran over 5,400 queries through the product data science agent and the semantic layer, while over 5,600 internal employees across all Snowflake teams and agents ran over 320,000 queries using the broader semantic layer in sales, HR, support and other areas.
What was the accuracy improvement from adding semantic context?
In AtScale's benchmark testing, adding semantic context increased text-to-SQL accuracy from 20% to more than 90% across 40 business questions on TPC-DS.
What tools does Snowflake use to manage and version the semantic layer?
Snowflake uses dbt (a native data build tool) integration for version control, peer review and continuous integration and continuous delivery (CI/CD) of metrics. The company also uses Snowflake CoCo (which has built-in semantic view skills) to draft and refine semantic and data processes.
Snowflake AI BlogRead Original Article

AI news that matters for your work, delivered every morning.

Pick your industry and the AI tools you use, and get news related to your work every day.

Free · 30 seconds with Google · unsubscribe anytimeWhat is AIToday? →

Ask AI

Ask AI anything about this article. The AI reads this article, earlier AIToday articles, and Wikipedia, and cites its sources. Q&As are published on this page for other readers too.

Questions and answers are published on this page.

Related Articles

Next articleAI Policy Careers Face Uncertainty as Superintelligence Looms