METABASE INTEGRATIONS DRIVER
METABASE INTEGRATIONS PASSWORD
METABASE INTEGRATIONS LICENSE
METABASE INTEGRATIONS FREE

Now we can run analysis and visualise the data. You can take all the necessary properties (such as host, port and user credentials) from your Aiven for ClickHouse page in the section ClickHouse HTTPS & JDBC. The connection between Metabase and ClickHouse happens over HTTPS. If you don't see ClickHouse there, try restarting the container. If all went well installing a driver, you'll see ClickHouse in the list of available databases types. To add a database, click on Add your own data, this will navigate you to the Add Database form. In order to connect to the ClickHouse server you need to add a database to Metabase and provide all necessary credentials for access. Skip adding data, we'll do it separately in the next step

METABASE INTEGRATIONS PASSWORD

Remember the email and password you enter, they are needed for logins. The first time you open Metabase, it will ask you several questions. Time to start Metabase! If you used the default ports when running the container, go to if you used a different port, adjust it accordingly.

METABASE INTEGRATIONS DRIVER

This will allow Metabase to access the ClickHouse driver and therefore work with ClickHouse data. Load the driver by going to the latest release and selecting from the list of assets.Īdd this file to the folder that you mounted in the previous step. You can find the ClickHouse driver (and extra documentation, in case you need it) in the ClickHouse driver for Metabase GitHub repository. ClickHouse is not in the list of officially supported drivers, but we can include it as a third-party community driver. Metabase comes with a predefined set of supported databases. Here is a preview of how that should work:

We'll need this folder for the next step. When starting your Docker container, make sure that you have access to the mounted folder located in /path-to-plugins-folder.

METABASE INTEGRATIONS LICENSE

If you don't have a license token for a paid version of Metabase and you don't need a production installation, these steps for the quick start plus a minor adjustment to include a ClickHouse driver is what you need. However, similar results can be achieved using the. However, the same techniques are applicable to your data.ĭepending on your operating system and preferences, you can choose between two approaches when setting up the open source edition of Metabase: using a Docker image or running Metabase as a JAR. We'll be utilizing the data from the 'What's on the Menu?' dataset in the examples below. The official documentation of ClickHouse offers a convenient set of instructions to create the tables and load the data. This dataset is easy to setup and it has ample opportunities for exploration.

METABASE INTEGRATIONS FREE

If you already have data in your ClickHouse database for analysis, feel free to skip this step and visualise your data.Īlternatively, you can use a dataset from New York Public Library 'What's on the Menu?' as an example. We also have documentation for detailed instructions. Once you're logged into the Aiven platform, click on Create service and follow the wizard to set up the preferences. You'll get free credits that you can use for this tutorial. If you still don't have an Aiven account, register over here. We recommend you use Aiven for ClickHouse when following this tutorial. In this section we'll set up the cluster and load the data that we can use for analysis. After completing this tutorial you'll have a dashboard in Metabase with insights from the data you have in ClickHouse.Īfter all, a picture is worth a thousand words. In this tutorial, you'll learn how you can integrate a ClickHouse® database with the open source BI tool Metabase to visualise the data stored in your database. BI tools allow organisations to transform their data into visual, actionable insights that support informed decision-making. That's where Business Intelligence (BI) tools can help us. As organizations generate more and more data, it becomes increasingly difficult to extract meaningful insights from the raw information. Data analysis is a critical component of modern business operations.

Metabase integrations