Use Metabase to connect to Databend Cloud to realize large-screen display

Metabase is an open source BI tool. This article mainly introduces how to use Databend Cloud | Databend in Metabase to read and analyze data.

Download metabase.jar

Metabase is a Java application that can be run by downloading the JAR file and executing java -jar metabase.jar. Metabase connects to Databend Cloud | Databend using JDBC Driver.

Download Metabase Databend Driver

  1. Create a directory plugins under the directory where you downloaded metabase.jar

$ ls
metabase.jar
$ mkdir plugins

  1. Download the latest Databend metabase driver: https://github.com/databendcloud/metabase-databend-driver/releases/latest to the plugins directory

  1. Start Metabase

java -jar metabase.jar

If you see the following log during startup, it means that the Databend driver is loaded normally

2019-05-07 23:27:32 INFO plugins.lazy-loaded-driver :: Registering lazy loading driver :databend...
2019-05-07 23:27:32 INFO metabase.driver :: Registered driver :databend (parents: #{:sql-jdbc})

  1. Visit http://localhost:300d 0 to open the metabase home page

Connect Metabase to Databend

  1. Fill in the basic information, select I’ll add my data later

  1. Click Add your own data to create a databend database connection

Select databend (databend version >=DatabendQuery v1.0.17)

Fill in the database connection information and click Save

Connect to the Databend deployed in privatization. Note that the port selects the listening port of http_handler_port, the default is 8000

  1. Exit background management

Run query

  1. After exiting the background management, click the + New menu in the upper right corner to run SQL queries and build dashboards.

  1. Here is an example of Query query and display

  1. Click the visualization button in the lower left corner to build a dashboard

Large screen display

Each query in Metabase can generate a graphic display and then add a Dashboard, and finally a simple large-screen display can be made.

Learn more

For more information on Metabase and how to build dashboards, visit the Metabase documentation.

Related

Databend metabase driver: https://github.com/databendcloud/metabase-databend-driver

Connect With Us

Databend is an open source, flexible, low-cost, new data warehouse that can also perform real-time analysis based on object storage. Looking forward to your attention, let’s explore cloud-native data warehouse solutions together to create a new generation of open source Data Cloud.

  • Databend Website

  • GitHub Discussions

  • twitter

  • Slack Channel