Skip to main content

Connect Databend Cloud To Metabase

Metabase is a simple but powerful analytics tool that enables everyone to make business decisions using their data without requiring any technical skills.

Before connecting to Metabase, sign in to your account on Databend Cloud.

Install Metabase​

Metabase is a Java application that can be executed by simply downloading the JAR file. To install Metabase, simply run this command:

Note: Metabase requires that you have Java 8 or higher versions installed on your system.

java -jar metabase.jar

This will launch a Metabase server on port 3000 by default.

Download the ClickHouse plugin for Metabase​

Because Databend is compatible with the ClickHouse protocol, we can use ClickHouse plugin to help Databend connect to Metabase.

  1. In the folder where you saved the file metabase.jar, create a subfolder called plugins.

  2. Download the latest version of the ClickHouse Metabase plugin to the folder you created in step 1. The plugin comes with a JAR file called clickhouse.metabase-driver.jar.

  3. Run the command java -jar metabase.jar to restart Metabase to load the driver properly.

  4. Access Metabse at http://127.0.0.1:3000.

Connect Metabase to Databend​

  1. Click on the gear icon in the top-right corner and select Admin Settings to visit the Metabase admin page.
  1. Click on Add database. Alternatively, you can click on the Databases tab and select the Add database button.
  1. Enter the connection details of your Databend database. The host is provided by Databend Cloud. For example:

  1. Click the Save button and Metabase will scan your metadata in Databend.

  2. Click on Exit admin.

Run query​

  1. Click on the + New in the top-right corner and select SQL query to view the Databend data.
  1. Select the database name you created when connecting to Databend.
  1. Run a query.