Metabase
Metabase (opens in a new tab) is an open-source way to help everyone in your company to ask questions and learn from data. There's also a fully-managed cloud service (opens in a new tab) for Metabase.
Webinar recording: Instant Insights Unlocked with Cube & Metabase (opens in a new tab)
Connect from Cube Cloud
It is recommended to use Semantic Layer Sync to connect Cube Cloud to Metabase. It automatically synchronizes the data model with Metabase.
Navigate to the Integrations page, click Connect to Cube, and choose Metabase to get detailed instructions.
Connect from Cube Core
You can connect a Cube deployment to Metabase using the SQL API.
In Cube Core, the SQL API is disabled by default. Enable it and configure the credentials to connect to Metabase.
Connecting from Metabase
Metabase connects to Cube as to a Postgres database.
Creating a connection
Querying data
Your cubes will be exposed as tables, where both your measures and dimensions are columns.
You can write SQL in Metabase that will be executed in Cube. Learn more about Cube SQL syntax on the reference page. You can also create a visualization of the executed SQL query.
If you prefer using the UI interface to "Ask a question", you can do that as well.