Synmetrix provides a production-ready, open-source semantic layer for centralized metrics management, built on Cube.js. It targets data engineers and analysts seeking to unify, model, transform, and distribute metrics across an organization, enabling data democratization and seamless integration with BI tools and applications.

How It Works

Synmetrix leverages Cube.js for flexible data modeling, allowing metrics and dimensions to be defined using SQL and Cube's data modeling files. This creates an abstraction layer over raw data sources, enabling the generation of optimized analytical SQL queries. Cube Store, a purpose-built distributed cache and query execution layer, enhances performance through fast aggregations, columnar storage, and advanced caching, making it suitable for large datasets and operational analytics.

Quick Start & Requirements

• Install/Run: Download docker-compose.yml from the repository and run docker-compose pull stack && docker-compose up -d.
• Prerequisites: Docker and Docker Compose.
• Setup Time: 5-7 minutes.
• Docs: Website, Docs, Cube.js Models docs
• Demo: app.synmetrix.org (demo@synmetrix.org / demodemo)

Highlighted Details

• Consolidates metrics from various sources into a unified, governed data model.
• Supports scheduled reports, alerts, versioning, and role-based access control.
• Offers a SQL API for integration with any BI tool and embedded analytics.
• Enhances LLM accuracy for data handling and queries.
• Utilizes Cube Store for distributed querying and advanced caching.

Maintenance & Community

• Active community support via Slack.
• Updates and news on Twitter.
• Video tutorials and demos on Youtube.
• Roadmap available.

Licensing & Compatibility

• Core Synmetrix: Apache License 2.0 (Apache-2.0).
• Other contents: MIT License.
• Compatible with commercial use and closed-source linking under Apache-2.0 terms.

Limitations & Caveats

The project has specific hardware requirements including a 3.2 GHz+ CPU, 8GB+ RAM, and 30GB disk space. ARM64v8 architecture requires specific Cubestore version adjustments.