--- title: How to connect your deployment to BI tools description: Learn how to connect your Scaleway Data Warehouse for ClickHouse® deployment to Business Intelligence (BI) tools. tags: connect bi-tools deployment data warehouse ClickHouse® integrate integration dates: validation: 2025-06-03 posted: 2025-06-03 --- import Requirements from '@macros/iam/requirements.mdx' This page explains how to integrate your Data Warehouse for ClickHouse® deployment with your preferred Business Intelligence (BI) tools. If your Data Warehouse deployment is inside a Private Network, see [how to connect your deployment to PowerBI in a Private Network](/data-warehouse/how-to/connect-powerbi-vpc/). - A Scaleway account logged into the [console](https://console.scaleway.com) - [Owner](/iam/concepts/#owner) status or [IAM permissions](/iam/concepts/#permission) allowing you to perform actions in the intended Organization - Created a [Data Warehouse deployment](/data-warehouse/how-to/create-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. ### Tableau Desktop #### Downloading and installing the ClickHouse® connector for Tableau 1. Download and install [Tableau Desktop](https://www.tableau.com/products/desktop/download). 2. Download the **latest** [ClickHouse JDBC Driver](https://github.com/ClickHouse/clickhouse-java/releases), and store the `clickhouse-jdbc-0.9.X-all-dependencies.jar` file in the appropriate folder: - macOS/Linux: `~/Library/Tableau/Drivers` - Windows: `C:\Program Files\Tableau\Drivers` - If the directory does not exist, create it. - The minimal required version is `0.9.X`. - Make sure to download the file with a name ending with `all-dependencies.jar`. 3. Download the latest `clickhouse-jdbc.taco` [connector file](https://github.com/ClickHouse/clickhouse-tableau-connector-jdbc/releases), and store it in the appropriate folder: - macOS/Linux: `~/Documents/My Tableau Repository/Connectors` - Windows: `C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors` The JDBC connector is now installed, and can be used to configure a new data source in Tableau Desktop. Refer to the [ClickHouse® Tableau JDBC connector repository](https://github.com/ClickHouse/clickhouse-tableau-connector-jdbc) for more information. #### Configuring a ClickHouse® data source in Tableau Desktop 1. Start or restart Tableau Desktop. 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: | Setting | Value | |----------|---------------------------------------------------------------------------------------------------------------------| | Server | Data Warehouse deployment host (available from the [Scaleway console](https://console.scaleway.com/data-warehouse)) | | Port | 8443 | | Database | default | | Username | A [user](/data-warehouse/how-to/manage-users/) with read (`SELECT`) permissions | | Password | The user's password | 5. Click **Sign In**. A new Tableau workbook appears. 6. Select **default** from the **Schema** dropdown menu in the left side panel. A list of tables appears. 7. Your Data Warehouse for ClickHouse® is now integrated into your Tableau platform. Refer to the official [ClickHouse®](https://clickhouse.com/docs/integrations/tableau) and [Tableau](https://exchange.tableau.com/products/1064) documentation portals for more information. ### Tableau Cloud To connect your Data Warehouse deployment to Tableau Cloud, you must use a MySQL connection. #### Creating a dedicated user with the appropriate permissions for the MySQL connection 1. Create a dedicated [user](/data-warehouse/how-to/manage-users/#how-to-create-a-user-using-the-scaleway-console) in your deployment for the MySQL connection. 2. [Connect](/data-warehouse/how-to/connect-applications/?tab=clickhouser-cli-0) to your deployment using the ClickHouse® CLI, as a user with admin rights (`scwadmin` by default). 3. Grant `SELECT` permissions to the newly created MySQL user on the information schema and its alias: ```sql GRANT SELECT ON INFORMATION_SCHEMA.* TO new_mysql_user; GRANT SELECT ON information_schema.* TO new_mysql_user; ``` Make sure to grant on both schemas, in uppercase and lowercase. 4. Grant the `SELECT` permission on the tables you want to query in Tableau Cloud: ```sql GRANT SELECT ON your_table TO new_mysql_user; ``` Your new user now has the appropriate permissions and can be used to connect to Tableau Cloud via MySQL. #### Configure a ClickHouse® data source in Tableau Cloud 1. Log into Tableau Cloud. 2. From the **Home** menu, select **Published Data Source** from the **New** drop-down menu. 3. Click the **Connectors** tab, then select **MySQL** from the connectors list. 4. Enter the following connection parameters: | Setting | Value | |----------|---------------------------------------------------------------------------------------------------------------------| | Server | Data Warehouse deployment host (available from the [Scaleway console](https://console.scaleway.com/data-warehouse)) | | Port | 9004 | | Database | default | | Username | Username of the dedicated MySQL user previously created | | Password | The user's password | 5. Click **Sign In**. A new Tableau workbook appears. 6. Select **default** from the **Databases** dropdown menu in the left side panel. A list of tables appears. Your Data Warehouse for ClickHouse® is now integrated into your Tableau platform. ## 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®](https://clickhouse.com/docs/integrations/metabase) and [Metabase](https://www.metabase.com/docs/latest/databases/connections/clickhouse) 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](/data-warehouse/how-to/connect-applications/). 2. Run the SQL query below to create a user with a plain text password. Replace the placeholders with the appropriate values: ```sql 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: ```sql 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 1. Make sure you have installed [PowerBI Desktop](https://www.microsoft.com/en-us/download/details.aspx?id=58494/), and [MySQL Connector/NET](https://dev.mysql.com/downloads/connector/net/). 2. Open PowerBI Desktop. 3. Click **Get Data** from the top ribbon, then select **More...** at the bottom of the drop-down menu. A pop-up displays. 4. Select the **Database** category, select **MySQL database** in the list, then click **Connect**. A connection pop-up displays. 5. Enter the values below, then click **OK**. - **Server**: `.dtwh..scw.cloud` - **Database**: the name of the database to import A credentials pop-up displays. 6. Select **Database** from the left menu, enter the values below, then click **Connect**. - **User name**: your dedicated MySQL user [previously created](#creating-a-dedicated-mysql-user) - **Password**: the password you set at deployment creation The **Navigator** pop-up displays, showing the different schemas and tables contained in your Data Warehouse for ClickHouse® deployment. 7. Select the desired tables, then **Load** to import data, or **Transform Data** to start working with your dataset. 1. Access [PowerBI Service](https://app.powerbi.com). 2. From the PowerBI Service interface, click the **+ New** button from the toolbar. A list of data sources displays. 3. Select **MySQL Database** from the list. A connection wizard displays. 4. Enter the following values. - **Server**: `.dtwh..scw.cloud` - **Database**: the name of the database to import (`default` if you did not create additional databases in your deployment) - **Connection**: `.dtwh..scw.cloud` - **Connection name**: `.dtwh..scw.cloud` - Authentication type: `Basic` - Username: your dedicated MySQL user [previously created](#creating-a-dedicated-mysql-user)) - Password: The plain text password assigned to your MySQL user - Privacy level: `None` 5. Click **Next**. The **Power Query** interface displays, allowing you to use the `MySQL.Database` function from this interface. Your Data Warehouse for ClickHouse® is now integrated into your PowerBI platform. Refer to the official [ClickHouse®](https://clickhouse.com/docs/integrations/powerbi) and [PowerBI](https://learn.microsoft.com/en-us/power-query/connectors/clickhouse) documentation portals for more information. ## Toucan ### Creating a new ClickHouse® connector for your deployment [Toucan](https://www.toucantoco.com/en/) 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](https://console.scaleway.com/data-warehouse)) | | Port | `9440` | | User | A [user](/data-warehouse/how-to/manage-users/) 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](https://docs-v3.toucantoco.com/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-a-clickhouse-connector) 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. Use the available YouPrep™ pipeline tools to transform data before using it as a data set. Refer to the [official Toucan documentation](https://docs-v3.toucantoco.com/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm) 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](https://docs-v3.toucantoco.com/visualizations-and-layouts/creating-visualizations/viz-gallery) for more information on how to create visualizations using your new data set. ## Superset [Apache Superset](https://superset.apache.org/) is an open-source data exploration and visualization platform that allows users to create interactive dashboards and charts. It connects to various data sources and supports complex data analysis through a user-friendly web interface. This procedure assumes you have access to a Superset deployment with admin rights. For testing purposes, you can install Superset on a [Scaleway Instance](/instances/how-to/create-an-instance/) by following the [official Superset Quickstart documentation](https://superset.apache.org/docs/quickstart/). 1. Make sure you have installed the [ClickHouse® connector](https://superset.apache.org/docs/databases/supported/clickhouse) in Superset. 2. Log in to your Superset account. You must have the **Admin** role. 3. Click **Settings** in the top-right corner of the interface, then select **Database Connections** from the drop-down menu. 4. Click the top-right **+ Database** button to add a new database. A connection wizard displays. 5. Under **Supported databases**, select **ClickHouse® Connect (Superset)** from the drop-down menu. 6. Enter the following information: - **Host**: the host of your Data Warehouse deployment in the `.dtwh..scw.cloud` format. - **Port**: `8443`. - **Database name**: `default` (or any other database from your deployment). - **Username**: the user from your deployment you want to use (such as `scwadmin`). - **Password**: the password associated with the selected user. - Edit the other parameters as needed, or leave the default values. 7. Click **Connect**. Your ClickHouse® database is added to Superset. 8. Click **Finish**. Your Superset dashboard displays, showing the database you just added. Refer to the [official Superset documentation](https://superset.apache.org/docs/intro) for comprehensive documentation on how to leverage data from your Data Warehouse for ClickHouse® deployment.