Cube Semantic Layer

Embed APIs allow you to integrate Cube's analytics capabilities directly into your own applications. They provide a secure, session-based authentication mechanism to ensure that users can interact with your data without exposing sensitive API keys.

There are two primary API types available:

1. Chat API: An API-first approach for building custom, AI-powered Analytics Chat experiences within your application.
2. Generate Session API: Used to create secure, temporary sessions required for signed embedding, allowing you to authenticate users for embedded content safely.

The cube_dbt package simplifies the process of creating a semantic layer by leveraging existing dbt models. It provides tools to:

• Load metadata from a dbt project.
• Inspect dbt models.
• Render dbt models as Cubes using YAML syntax.

The GraphQL API allows Cube to deliver data over HTTP to GraphQL-enabled applications, such as front-end applications and embedded analytics use cases. It is exposed via the /graphql endpoint of the REST API.

Current Limitations compared to the REST API:

• No support for WebSockets transport.
• No support for subscriptions to changes.
• No support for referencing segments in queries.
• No support for compare date range queries.
• No support for querying data model metadata.
• No ability to apply a pivot config on the front-end.

The MDX API allows Microsoft Excel (on Windows) to connect directly to Cube Cloud using standard XMLA protocols. This enables users to use Cube data within native Excel PivotTables and execute sophisticated OLAP queries using Multidimensional Data Expressions (MDX).

Key Features:

• Direct connectivity: Connect Excel to Cube Cloud via XMLA.
• Advanced analytical functions: Supports slicing, dicing, drilling down, and rolling up.
• Real-time access: Fetches live data from Cube Cloud.

Requirements & Limitations:

• Plan: Available on Enterprise and above plans.
• Deployment: Requires the M deployment tier.
• Platform: Works only with Excel on Microsoft Windows.
• Scope: The MDX API works with views, not cubes.

The @cubejs-backend/druid-driver is a pure JavaScript driver designed to allow Cube.js to connect to and query Apache Druid databases.

Note on Support: This package is community-supported and is not actively developed by the Cube Dev team. It should be used at your own risk. The team is open to reviewing community contributions and is actively looking for maintainers via their Slack channel.