Connecting to Metabase

You can connect to Cube from Metabase by using the Cube SQL API. Metabase is the easy, open-source way to help everyone in your company work with data like an analyst.

Here's a short video guide on how to connect Metabase to Cube.

Don't have a Cube project yet? Learn how to get started here.

Click Deploy SQL API and then the How to connect your BI tool link on the Overview page of your Cube deployment. Navigate to the BIs and Visualization Tools tab. You should see the screen like the one below with your connection credentials:

You need to set the following environment variables to enable the Cube SQL API. These credentials will be required to connect to Cube from Metabase later.

CUBEJS_PG_SQL_PORT=5432
CUBEJS_SQL_USER=myusername
CUBEJS_SQL_PASSWORD=mypassword

Metabase connects to Cube as to a Postgres database.

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.

Did you find this page useful?