ClickHouse

ClickHouse JDBC 커넥터를 사용하면 Tableau와 ClickHouse 테이블 간의 원활한 통합이 가능하므로, Tableau의 강력한 비주얼리제이션 및 분석 기능을 활용하여 ClickHouse에 저장된 데이터를 분석할 수 있습니다.

Requirements

• Tableau 2020.4+
• ClickHouse 20.7+

Tableau Desktop

1. Download the Clickhouse JDBC Driver (version 0.8.X required), and place the clickhouse-jdbc-0.8.X-shaded-all.jar to:
   • macOS: ~/Library/Tableau/Drivers
   • Windows: C:\Program Files\Tableau\Drivers
   • You need to create the folder if it doesn't already exist
2. Download the latest clickhouse-jdbc.taco from the Releases page, and place it to:
   • macOS: ~/Documents/My Tableau Repository/Connectors
   • Windows: C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors
3. Run Tableau Desktop
4. In Tableau Desktop: Connect ➔ To a Server ➔ ClickHouse JDBC by ClickHouse, Inc.

Tableau Prep Builder

1. Download the Clickhouse JDBC Driver (version 0.8.X required) and place the clickhouse-jdbc-0.8.X-shaded-all.jar to:
   • macOS: ~/Library/Tableau/Drivers
   • Windows: C:\Program Files\Tableau\Drivers
   • You need to create the folder if it doesn't already exist
2. Download the latest clickhouse-jdbc.taco from the Releases page and place it to:
   • macOS: ~/Documents/My Tableau Prep Repository/Connectors
   • Windows: C:\Users\[Windows User]\Documents\My Tableau Prep Repository\Connectors
3. Run Tableau Prep Builder
4. In Tableau Prep Builder: Connections ➔ + ➔ To a Server ➔ ClickHouse JDBC by ClickHouse, Inc.

Tableau Server

1. Download the Clickhouse JDBC Driver (version 0.8.X required) and place the clickhouse-jdbc-0.8.X-shaded-all.jar to:

   • Linux: /opt/tableau/tableau_driver/jdbc
   • Windows: C:\Program Files\Tableau\Drivers
   • You need to create the directory if it doesn't already exist
   • For Linux: make sure directory is readable by the "tableau" user. To do this:

     • Create the directory:

       sudo mkdir -p /opt/tableau/tableau_driver/jdbc
       

     • Copy the downloaded driver file to the location, replacing [/path/to/file] with the path and [driver file name] with the name of the driver you downloaded:

       sudo cp [/path/to/file/][driver file name].jar /opt/tableau/tableau_driver/jdbc
       

     • Set permissions so the file is readable by the "tableau" user, replacing [driver file name] with the name of the driver you downloaded:

       sudo chmod 755 /opt/tableau/tableau_driver/jdbc/[driver file name].jar
       

2. Download the latest clickhouse-jdbc.taco from the Releases page and place it into these folders on each node:

   • Linux: /opt/tableau/connectors
   • Windows: C:\Program Files\Tableau\Connectors

3. Restart the server.

   tsm restart
   

   • Note that whenever you add, remove, or update a connector, you need to restart the server to see the changes.

For more information, please visit the connector's GitHub repository