Tableau Connects to Lakehouse

Tableau is a Business Intelligence (BI) product. Lakehouse supports data access to Tableau for visualization analysis. You can use Tableau's simple drag-and-drop interface to customize views, layouts, shapes, colors, etc., to help you present your data perspective. This article introduces how to connect Tableau through the Lakehouse JDBC driver and perform visual data analysis.

Background Information

Tableau Desktop is a software application developed by Tableau based on breakthrough technology from Stanford University. It can help you vividly analyze any structured data that actually exists and generate beautiful charts, coordinate graphs, dashboards, and reports within minutes. For more information on Tableau Desktop, please refer to Tableau Desktop.

Prerequisites

Before starting, please ensure you meet the following conditions:

Lakehouse service has been activated.
Lakehouse JDBC driver has been downloaded.
Tableau has been downloaded and installed. This article uses Professional Edition 2024.3.1 as an example.
Lakehouse provides the Tableau plugin.

Connect to Lakehouse

Step 1: Place the Lakehouse JDBC Driver

Place the downloaded Lakehouse JDBC driver JAR package in the corresponding directory of Tableau Desktop according to the operating system type:

Windows: C:\Program Files\Tableau\Drivers
macOS: ~/Library/Tableau/Drivers
Linux: /opt/tableau/tableau_driver/jdbc

Step 2: Place the Lakehouse Tableau Plugin

Download the Lakehouse provided Tableau plugin. This plugin is written according to the official Tableau plugin documentation.

Place the downloaded plugin in the corresponding directory of Tableau Desktop:

Windows: C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors
macOS: /Users/[user]/Documents/My Tableau Repository/Connectors
Linux: /opt/tableau/connectors

In this article, macOS is used, so the location is: /Users/xxx/Documents/My Tableau Repository/Connectors

Step 3: Start Tableau

Start Tableau Desktop. Since the above plugin is not digitally signed, you need to disable signature verification when starting.


--mac open command line and run  
/Applications/Tableau\ Desktop\[version].app/Contents/MacOS/Tableau -DDisableVerifyConnectorPluginSignature=true
-- Windows command line run  
tableau.exe -DDisableVerifyConnectorPluginSignature=true

In the To Server section of the left navigation bar, select More... > Lakehouse x Singdata.
Preview
In Lakehouse x Singdata, configure the parameter information
Preview

Parameter	Required	Description
Server	Y	You can see the jdbc connection string in Lakehouse Studio Management -》Workspace
Username	Y	Username
Password	Y	Password

Click Login to enter the Tableau Desktop interface.
Select the target Lakehouse Schema from the schema dropdown list on the left.
Preview

Step 4: Use Tableau to Query and Analyze Data

In this case, we use the clickzetta_sample_data.tpch_100g.orders table from the public dataset to analyze data

Double-click New Custom SQL

Enter, click OK


select *  from    clickzetta_sample_data.tpch_100g.orders

Click on the worksheet to analyze the dataset in the clickzetta_sample_data.tpch_100g.lineitem table