Tableau
Overview⚓︎
You can connect Tableau Desktop and Server to Hydrolix using the official ClickHouse Tableau Connector. The ClickHouse connector send queries to the Hydrolix built-in ClickHouse-compatible HTTP interface.
Configuration⚓︎
Use the following settings for a connection between Tableau and Hydrolix.
| Setting | Description | Example |
|---|---|---|
| Server | The Hydrolix cluster hostname. | ${myhost}.hydrolix.live |
| Port | The ClickHouse HTTP interface port. | 8088 |
| Username | Hydrolix user account with read privileges. | username@domain.tld |
| Password | The user account's password. | sekret |
Tableau is limited to Basic Auth for authorization
Hydrolix supports query access for clients using HTTP basic auth and authorization (bearer) tokens associated with user or service accounts. See access enforcement. Tableau ClickHouse Connector is unable to set an HTTP Authorization header on the request. The Authorization header is required to use service account or user auth tokens.
Connecting with Tableau requires HTTP basic auth with user credentials.
Before you begin⚓︎
| Prerequisite | Description |
|---|---|
| Hydrolix cluster | A running Hydrolix cluster |
| Tableau environment | A Tableau Desktop or Server instance |
| User permissions | A Hydrolix user account with read privileges on the target tables |
| Network access | Connectivity from Tableau to the Hydrolix host on port 8088 |
ClickHouse Connector Instructions⚓︎
The following instructions integrate Tableau Desktop or Server with Hydrolix by installing and configuring the ClickHouse Tableau Connector.
Install the ClickHouse Connector⚓︎
Install the ClickHouse driver and connector following the instructions on the ClickHouse JDBC Connector page for the appropriate Tableau product.
Create a connection in Tableau⚓︎
- Open Tableau.
- Verify the ClickHouse connector is installed:
- Navigate to Connect > To a Server > More > ClickHouse JDBC by ClickHouse, Inc.
- Enter the configuration values from Configuration.
- If your Hydrolix cluster enforces TLS, select Require SSL.
- (Optional) Open Initial SQL to specify a SQL command to run at the beginning of every connection.
- Click Sign In.
After signing in, the Hydrolix cluster's projects should be listed in the left nav under Database in the Select Database dropdown.
Build the data source⚓︎
On the data source page:
- Select one or more tables from the Hydrolix project, or click New Custom SQL to write a query.
- Choose a connection type:
- Live: queries run directly against Hydrolix in real time.
- Extract: Tableau caches data and can refresh on a schedule after publishing.
- Drag tables onto the canvas to define joins or relationships.
- Click Sheet to preview data and confirm the results.