
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.
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.
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.
Summaries like this, in your inbox every morning.
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.
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 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.
Anthropic co-founder Jack Clark told a University of Tokyo audience on October 13 that the chance of an AI str…

At a press briefing for Anthropic Japan's first anniversary, co-founder Jack Clark said on October 14 that AI…

Apple HomeView is now official, a new Apple TV device whose appeal rests on subpar AI

Broadcom expects AI semiconductor revenue to reach $56 billion this year and over $100 billion next year, help…

Thiel Macro, Peter Thiel's investment company, holds 42% of its portfolio in two AI stocks: Amazon at 28% and…

Tencent Holdings sold nearly $5.7 billion of bonds this week to support its AI investments, its largest offeri…
