Connect Tableau to Tinybird

Tableau can connect to Tinybird using the ClickHouse® JDBC driver, taking advantage of Tinybird's ClickHouse® HTTP protocol compatibility. This enables you to use Tinybird data in Tableau.

The ClickHouse® connection to Tinybird is read-only. You can use it to analyze and visualize data from your Tinybird data sources, but you cannot modify data through this connection.

Prerequisites

  • A Tinybird workspace with data sources
  • A Tinybird Auth Token with read permissions for the workspace data sources

Add Tinybird as a data source

  1. Download the ClickHouse® JDBC Driver, use the latest clickhouse-jdbc-x.y.z-all-dependencies.jar version.
  2. Save the ClickHouse JDBC driver in any of these folders depending on your OS:
  • macOS: ~/Library/Tableau/Drivers
  • Windows: C:\Program Files\Tableau\Drivers
  1. In Tableau Desktop, select Connect > More and type ClickHouse. Select ClickHouse by ClickHouse and follow the wizard.
  2. After installing the connector, select Connect > To a Server > ClickHouse JDBC
  3. Configure the connection with these settings:

Connection configuration

Server: clickhouse.tinybird.co
Port: 443
Username: <WORKSPACE_NAME>  # Your workspace name
Password: <TOKEN>  # Your Tinybird auth token
SSL: Yes

See the list of ClickHouse hosts to find the correct one for your region.

Click on Sign In to see your data sources

Tableau ClickHouse® connection configuration
Tableau ClickHouse® connection configuration

Learn more

Updated