How to connect your deployment to BI tools

Reviewed on June 03, 2025

This page explains how to integrate your Data Warehouse for ClickHouse® deployment with your preferred Business Intelligence (BI) tools.

Before you start

To complete the actions presented below, you must have:

• A Scaleway account logged into the console
• Owner status or IAM permissions allowing you to perform actions in the intended Organization
• Signed up to the private beta and received a confirmation email.
• Created a Data Warehouse deployment

Tableau

Tableau is a powerful data visualization and business intelligence tool that enables users to transform complex data into interactive and shareable dashboards and reports, providing actionable insights through intuitive drag-and-drop interfaces.

Download and install the ClickHouse® connector for Tableau

1. Download and install Tableau Desktop.

2. Follow the instructions for clickhouse-tableau-connector-jdbc to download the compatible version of the ClickHouse® JDBC driver.

3. Store the JDBC driver in the Drivers folder. If the directory does not exist, create it:

   • macOS/Linux: ~/Library/Tableau/Drivers
   • Windows: C:\Program Files\Tableau\Drivers

Configure a ClickHouse® data source in Tableau

1. Start or restart Tableau.

2. From the Connect left-side menu, click on More under the To a Server section.

3. Select ClickHouse® by ClickHouse® from the connectors list.

4. Enter the following connection parameters:

5. Enter your connection details:

   Setting	Value
   Server	Your ClickHouse® host (with no prefixes or suffix)
   Port	8443
   Database	default
   Username	default
   Password	Password set at deployment creation

   Note

   Make sure to enable the SSL if you are using ClickHouse® Cloud.

6. Click Sign In. A new Tableau workbook appears.

7. Select default from the Schema dropdown menu in the left side panel. A list of tables appears.

8. Your Data Warehouse for ClickHouse® is now integrated into your Tableau platform.

Refer to the official ClickHouse® and Tableau documentation portals for more information.

Metabase

Metabase is an open-source business intelligence tool that allows users to create and share customizable dashboards and reports from various data sources.

Integrating ClickHouse® into Metabase enhances query performance and scalability, for faster data analysis on large datasets, and provides robust support for complex queries and real-time analytics.

Download the ClickHouse® plugin for Metabase

1. Download the latest version of the plugin (JAR file named clickhouse.metabase-driver.jar) from the official CLickHouse® GitHub repository.

2. Save clickhouse.metabase-driver.jar in your Metabase plugins folder.

   Note

   If you do not have a plugins folder, create it in the same directory as the metabase.jar file. Refer to the official Metabase documentation for more information on plugins.

3. Start (or restart) Metabase to load the new plugin.

4. Access your Metabase server.

   Note

   On the initial startup, if prompted to select a database, select I'll add my data later.

Connect Metabase to ClickHouse®

1. Click on the gear icon in the top-right corner and select Admin Settings to visit your Metabase admin page.

2. Click Add a database. Alternatively, you can click the Add database button from the Databases tab.

3. If your driver installation worked, you will see ClickHouse® in the dropdown menu for Database type.

4. Enter a display name for your database.

5. Enter the credentials Data Warehouse for ClickHouse® deployment. Toggle on **Use a secure connection (SSL)**if your ClickHouse® server is configured to use SSL.

6. Click Connect database to finish.

Your Data Warehouse for ClickHouse® is now integrated into your Metabase platform.

Refer to the official ClickHouse® and Metabase documentation portals for more information.

PowerBI Desktop

Power BI Desktop is a robust data visualization tool that allows users to create dynamic reports and dashboards from various data sources. To connect to your Data Warehouse for ClickHouse® deployment, PowerBI requires a MySQL connection using a dedicated user with a plain text password.

Creating a dedicated MySQL user

1. Connect to your deployment.

2. Run the SQL query below to create a user with a plain text password. Replace the placeholders with the appropriate values:

   CREATE USER mysql_user IDENTIFIED WITH plaintext_password BY 'mysql_user_password';

3. Run the SQL query below to grant the user access to the database:

   GRANT SELECT(id) ON my_database.my_table TO mysql_user WITH GRANT OPTION;

Your user can now access the specified database using the credentials you just defined.

Connecting PowerBI to your deployment

Your Data Warehouse for ClickHouse® is now integrated into your PowerBI platform.

Refer to the official ClickHouse® and PowerBI documentation portals for more information.