- Home
- Semantic Layer Software
- Sidemantic
On the recordRead 9 Oct 202619 facts
Sidemantic
On the record
- Aggregation correctness
- Symmetric aggregates are used to prevent double-counting across one-to-many joins.sidemantic.com · read 4 Oct 2026
- AI access
- Sidemantic can expose metrics to LLMs through MCP, with built-in guardrails for governed access.sidequery.dev · read 9 Oct 2026
- Format imports
- It imports semantic models from formats including Cube, dbt MetricFlow, LookML, Hex, Rill, Superset, Omni, Malloy, Snowflake Cortex, OSI, AtScale, GoodData, Holistics, and ThoughtSpot.sidequery.dev · read 9 Oct 2026
- Interactive demo
- The site offers an interactive workbench with built-in demo data that does not require a database.sidemantic.com · read 4 Oct 2026
- Join handling
- Cross-model queries can infer join paths from declared relationships, and symmetric aggregates are designed to prevent double-counting across one-to-many joins.sidequery.dev · read 9 Oct 2026
- Join inference
- Cross-model queries infer join paths from declared relationships without requiring a JOIN keyword in semantic SQL.sidequery.dev · read 4 Oct 2026
- License
- The GitHub repository identifies the project as open source under the AGPL-3.0 license.github.com · read 4 Oct 2026
- Maker
- The site footer identifies Sidequery Corporation as the company.sidemantic.com · read 4 Oct 2026
- Maturity
- The project describes itself as young and notes that format conversion and its Postgres protocol server may have rough patches.github.com · read 4 Oct 2026
- Model authoring
- You can define semantic models in YAML, SQL DDL, or Python.sidequery.dev · read 9 Oct 2026
- Model imports
- It imports semantic models from more than 15 formats, including Cube, MetricFlow, LookML, Malloy, and Snowflake Cortex.sidequery.dev · read 4 Oct 2026
- Not a BI or ETL tool
- Sidemantic runs on top of a warehouse and is described as neither an ETL tool nor a BI tool.sidequery.dev · read 4 Oct 2026
- Pre-aggregation limit
- Pre-aggregation routing is disabled by default and must be explicitly enabled.sidequery.dev · read 9 Oct 2026
- Purpose
- Sidemantic is a semantic layer for defining metrics once and querying them consistently across tools.sidequery.dev · read 9 Oct 2026
- Query interfaces
- Sidemantic provides a SQL interface, Python API, CLI, MCP server, and Postgres wire protocol.sidequery.dev · read 9 Oct 2026
- Support
- The maker links to documentation and a Discord community for the project.sidemantic.com · read 4 Oct 2026
- Warehouse connections
- Documented database connections include DuckDB, MotherDuck, PostgreSQL, BigQuery, Snowflake, ClickHouse, Databricks, and Spark SQL.sidequery.dev · read 9 Oct 2026
- Warehouse support
- Native adapters are listed for Snowflake, BigQuery, Postgres, ClickHouse, Databricks, and Spark, with additional databases supported via ADBC.sidemantic.com · read 4 Oct 2026
