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.
