Back to Cube

Metabase

docs/content/product/configuration/visualization-tools/metabase.mdx

1.6.432.2 KB
Original Source

Metabase

Metabase 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 for Metabase.

<InfoBox>

Webinar recording: Instant Insights Unlocked with Cube & Metabase

</InfoBox>

Connect from Cube Cloud

You can connect Cube Cloud to Metabase using the SQL API.

Navigate to the Integrations page, click <Btn>Connect to Cube</Btn>, and choose <Btn>Metabase</Btn> 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

<div style={{ textAlign: "center" }}> </div>

Querying data

Your cubes will be exposed as tables, where both your measures and dimensions are columns.

<div style={{ textAlign: "center" }}> </div>

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.

<div style={{ textAlign: "center" }}> </div>

If you prefer using the UI interface to "Ask a question", you can do that as well.

<div style={{ textAlign: "center" }}> </div>