cube-js/cube.js
Cube.js
Cube is a semantic layer data platform that maps raw SQL databases to standardized business metrics and dimensions. It functions as a SQL dialect translator, converting abstract semantic queries into optimized SQL statements for various cloud data warehouses.
The platform operates as a multi-tenant data gateway, isolating information and security permissions for different customers within a single deployment. It includes a relational caching engine that stores pre-aggregated query results to reduce latency and decrease the load on primary data warehouses.
The system provides a REST-based interface for serving modeled data and visualizations as an embedded analytics API. It supports connecting modeled data to external business intelligence software and exposing metrics through web interfaces for use by external applications. Access is managed through role-based controls to restrict data visibility.
Features
- SQL-Based Semantic Layer - Provides a semantic layer that maps raw SQL databases to standardized business metrics and dimensions.
- Semantic Data Models - Maps raw SQL database schemas to a standardized semantic layer of business metrics and dimensions using code.
- Business Metrics - Maps raw data sources to consistent business-level performance indicators and derived metrics.
- Semantic Data APIs - Provides web interfaces to serve standardized metrics and dimensions to external applications and automated agents.
- Multi-Tenant Data Management - Functions as a multi-tenant data gateway that isolates information and security permissions for different customers.
- SQL Database Connectivity - Integrates with various cloud warehouses and SQL-compliant databases to fetch and process raw information.
- SQL Dialect Adapters - Translates abstract semantic queries into optimized SQL statements tailored for various cloud data warehouses.
- RESTful API Interfaces - Exposes modeled business metrics and dimensions through a standardized REST API for external consumption.
- Multi-Tenancy Security - Isolates data and access for different customers within a single deployment to ensure privacy.
- Multi-Tenant Isolation Layers - Provides a dedicated mapping layer to ensure strict data isolation between different customers within a single deployment.
- Role-Based Access Control - Restricts data visibility and platform actions based on specific user roles to ensure secure access.
- Role-Based Access Controls - Enforces data visibility and platform permissions by mapping user identities to predefined security roles.
- Embedded Analytics - Provides a REST-based interface for serving modeled data and visualizations directly into customer-facing applications.
- Metric Delivery APIs - Serves defined business metrics and dimensions through standard web interfaces for use by external applications.
- BI Tool Integration - Connects modeled data to external business intelligence software for visualization in spreadsheets and dashboards.
- Query Result Caching - Implements a relational caching engine that stores pre-aggregated query results to reduce primary data warehouse load.
- BI Tool Connectors - Enables connecting modeled semantic data to external business intelligence software for visualization in dashboards.
- Interactive Embeds - Provides the ability to embed interactive data visualizations and analytics surfaces directly into customer-facing applications.
- Databases - Headless BI platform providing GraphQL APIs for data warehouses.
