Cube Semantic Layer and Headless BI API

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

Overview

Cube is the open source semantic layer and headless business intelligence platform (formerly Cube.js). It sits in front of your data warehouse or database and exposes a single, consistent data model through REST, GraphQL and SQL APIs, with built in caching, pre aggregations and row level access control, so every dashboard, notebook and application queries the same governed metrics. This AMI delivers Cube fully installed and configured, with the developer Playground and query APIs published behind authentication, so your semantic layer is running within minutes of launch.

The Problem This Solves

Without a semantic layer, teams duplicate SQL logic across every BI tool, notebook and application. Metrics drift, definitions conflict and data consumers lose trust in dashboards. Deploying Cube manually means configuring Docker, systemd services, an nginx reverse proxy, secret management and TLS, hours of work before a single query runs. This image removes that operational burden, delivering a production ready Cube instance with hardened security from the first boot.

How It Works

Cube does not store your data. You point it at your existing data source, Postgres, MySQL, BigQuery, Snowflake, Redshift, ClickHouse, Databricks and many more, by editing the environment configuration. Define your metrics and dimensions once in the data model and serve them everywhere. To make the Playground useful immediately, this image ships a small self contained sample dataset and a matching data model, which you replace with your own.

Application Stack

Cube runs from the official Cube Docker image, pinned to a fixed version and managed by a systemd service that starts on boot and restarts on failure, under a dedicated unprivileged service account. The data model, the sample dataset and the query cache live on a dedicated data disk so they are independently resizable. An nginx reverse proxy publishes the Playground and the REST, GraphQL and SQL APIs on port 80 behind HTTP Basic authentication, with WebSocket upgrade for the live Playground.

One Semantic Layer for Every Tool

Define measures, dimensions and joins once and query them from anywhere over REST, GraphQL or the Postgres compatible SQL API. Cube adds caching and pre aggregations for fast queries over large tables, and access control so each consumer sees only the data it should. Connect BI tools, notebooks, spreadsheets and your own applications to a single consistent set of metrics instead of duplicating SQL in every tool.

Secure First Boot

On the first boot of your instance a one shot service generates a fresh API secret, the key used to sign the JSON Web Tokens your applications present to the Cube APIs, unique to that instance, and a fresh administrator password for the Playground. No shared or default credentials ship in the image, and two instances launched from this image never share a secret. The Cube server binds to loopback only and is reachable exclusively through the authenticating proxy.

Use Case: Embedded Customer Facing Analytics

A SaaS product team connects Cube to their Postgres or Snowflake warehouse, defines tenant scoped metrics such as revenue, usage and engagement in the data model, and applies row level security so each customer sees only their own data. The application queries the Cube REST API with a signed JWT carrying the tenant id. Pre aggregations keep dashboard load times fast even over millions of rows, and the single data model ensures every embedded chart matches the internal reporting numbers exactly.

Ready To Use

Sign in to the developer Playground on port 80 with the generated administrator credentials. Explore the data model, build queries visually, inspect the generated SQL and see results from the bundled sample dataset immediately. Then point Cube at your own warehouse by editing the environment file, replace the data model, and query it from your applications over REST, GraphQL or SQL using the generated API secret.

cloudimg Support

24/7 technical support by email and chat. Our engineers help with deployment, connecting Cube to your data source, authoring the data model, JWT and API security, caching and pre aggregations, TLS and reverse proxy configuration.

Use Cases

A governed semantic metrics layer shared across every BI tool. Embedded analytics APIs for your own applications over REST and GraphQL. A consistent metrics definition in front of Postgres, BigQuery, Snowflake or your existing warehouse. A caching and access control layer over a large database. A single source of truth for dashboard data.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.