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
• 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.

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.

Toucan

Creating a new ClickHouse® connector for your deployment

Toucan is a business intelligence platform that transforms raw data into actionable insights through customizable visualizations and dashboards. Toucan's ClickHouse® connector allows you to use your Data Warehouse for ClickHouse® deployment as a data source.

1. Log in to your Toucan account.

2. From your Toucan App Store, create a new app, or select the one you want to connect to Data Warehouse for ClickHouse®.

3. From the My datasources tab of your Datahub, click Add a connector. A pop-up displays.

4. Select the ClickHouse® from the list, then fill in the fields with the following information:

   Field	Description
   Name	The name you want to give to your new connection
   Host	Data Warehouse deployment host (available from the Scaleway Console)
   Port	9440
   User	A user with read (SELECT) permissions
   Password	The user's password
   SSL_connection	Must be enabled to connect to your deployment via SSL
   Retry Policy (optional)	(Optional) enables a retry policy if the connection is unstable
   Slow Queries Cache Expiration Time (optional)	(Optional) slow queries cache expiration time in seconds

5. Click Save. Your new ClickHouse® connector appears in the list.

Your Data Warehouse for ClickHouse® is now connected to your Toucan app, and can be used as a data source.

Refer to the official Toucan documentation for more information on the ClickHouse® connector.

Creating new datasets from your deployment

1. Click the + icon in your new connector to create a new dataset. A form displays.

2. Select the desired database from the Database drop-down menu.

3. Select the desired table from the Table or view drop-down menu.

4. Select the columns you want to import from the Columns drop-down menu. Tick/untick the checkboxes to filter data.

5. Click Next. A preview of the data displays, showing the selected columns only.

6. Click Create to proceed.

   Note

   Use the available YouPrep™ pipeline tools to transform data before using it as a data set. Refer to the official Toucan documentation for more information on the YouPrep™ interface.

7. Enter a name for your data set, select Data requested live, then click Save to finish.

Your data set now appears in the Datasets tab of your Datahub, and is now ready to be used.

Refer to the official Toucan documentation for more information on how to create visualizations using your new data set.