ZICQ
中 Log in / Sign up
ZICQ Info Agentic #Semantic Layer #Data Processing #Non-Technical Users #Intelligent Routing #AI Tools

Strata Released: A Semantic Layer Solution for Non-Technical Users

Avatar of Mr.Xu

By Mr.Xu Community Post

Published: · 6 views

中文阅读 (Chinese) English Version
Co-reading Select any sentence in the article to highlight, annotate, or copy a quote card. Join discussion ↓

Summary:Ajo has released Strata, a semantic layer solution designed to provide intuitive and powerful data processing capabilities for non-technical users. Strata employs strict naming conventions, supports automatic data blending across domains, and features intelligent query routing that selects the optimal data source based on query granularity and speed. Additionally, it supports complex measure calculations, custom calculations, and dynamic filtering, offering a new option for enterprise-level data


Strata: A Semantic Layer Solution for Non-Technical Users

Strata, developed by Ajo, is a full-stack semantic layer solution designed to address the pain points of non-technical users in data processing. Here are the main features and characteristics of Strata:

  • Strict Naming Conventions: Only one object named "Revenue" can exist in a project. If "Revenue" is mapped to multiple tables, the system will select the optimal data source based on query granularity and speed.
  • Automatic Data Blending Across Domains: Thanks to strict naming conventions, Strata enables automatic data blending across fact domains, improving data processing efficiency.
  • Intelligent Query Routing: Strata supports partition and aggregate-aware routing, allowing portions of data to be loaded into faster compute engines like Druid or ClickHouse while retaining full history in cheaper storage. The query engine selects the optimal compute layer based on query requirements.
  • Complex Measure Support: Strata includes built-in support for snapshot, LOD (include/exclude), compound, and auto-leveling compound measures.
  • Custom Calculations: Users can create custom calculations that span fact domains on top of the semantic layer.
  • Dynamic Filtering: Strata supports creating dynamic filter sets and applying them to entire queries or individual measures.

Strata offers a full-stack solution with dashboards, subscriptions, and Google Sheets export capabilities, with all operations accessible via agent conversation or MCP. Although Strata is currently in an early beta stage and not open source, its free tier supports up to 25 users and can be run entirely on a local machine using Docker.

Technical Highlights

  1. Strict Naming and Data Blending: Strata's strict naming conventions enable efficient data blending across domains, addressing traditional data processing naming conflicts.
  2. Intelligent Query Routing: Dynamically selects the optimal data source based on query requirements, enhancing query efficiency.
  3. Complex Measure Support: Built-in support for various complex measures meets enterprise-level data processing needs.
  4. Customization and Dynamic Filtering: Provides flexible custom calculation and dynamic filtering capabilities to adapt to different scenarios.

Industry Impact and Developer Recommendations

Strata's release offers a more convenient data processing tool for non-technical users, particularly suitable for small and medium-sized enterprises that need to quickly build data-driven applications. For developers, Strata's API and MCP interfaces provide rich extension capabilities for customized development based on specific needs. Additionally, Strata's strict naming and intelligent routing mechanisms offer new ideas for data governance and data quality management.

Developers are advised to follow Strata's updates and actively participate in testing and feedback to help improve product features. Meanwhile, developers can use Strata's free version for prototyping and proof-of-concept work, exploring its potential in practical applications.


Source: Hacker News AI Feed (2026-09-30)

— END —

Tags: #Semantic Layer #Data Processing #Non-Technical Users #Intelligent Routing #AI Tools

Editorial & Fact-Checking Note: This article is compiled from primary research, official release documentation, and source papers by the ZICQ Newsroom pipeline with automated entity verification and human editorial review. If you notice any technical inaccuracy, please submit a correction via our corrections policy or email our editorial desk directly.

What's your take on this story?
🚀 Explore & Submit Works

Community Comments

Loading live comments and annotations…