Connect ClickHouse to Tableau with an ODBC/JDBC driver, a valid connection string, and Tableau’s native query interface to visualize fast-moving analytics data.
Download the official ClickHouse ODBC or JDBC driver that matches your OS and Tableau version. Run the installer and confirm the driver appears in your system’s ODBC Data Sources or Java classpath.
Tableau Desktop can reach ClickHouse through “Other Databases (ODBC),” “Other Databases (JDBC),” or a custom connector (.taco).Choose ODBC for Windows/macOS simplicity or JDBC for cross-platform deployments.
Host, Port, Database, User, and Password are mandatory. Optional flags include SSLMode, Timeout, and Compression.Use a service account with read-only access for production dashboards.
Driver=ClickHouse ODBC Driver;Host=analytics.db;Port=9000;Database=ecommerce;User=tableau;Password=$ecret;SSLMode=1;
1️⃣ Open Tableau → Data → Connect → "Other Databases (ODBC)".
2️⃣ Pick the ClickHouse DSN or enter the driver class.
3️⃣ Supply the connection string, test, then press "Sign In".
4️⃣ Drag the desired tables or write a custom SQL query.
Yes.Click “New Custom SQL,” paste your query, and Tableau will treat the result set as a logical table. Use parameterization to make dashboards interactive.
Aggregate in-database, limit result columns, and leverage ClickHouse’s materialized views for pre-computed metrics. Enable “Live” connection instead of extracts for real-time charts.
After testing locally, publish the data source to Tableau Server with “Embedded Credentials” so refreshes run automatically.Assign the Server a matching ClickHouse DSN or JDBC jar.
Enforce SSL/TLS in the driver, restrict IPs at the ClickHouse firewall, and use LDAP/SAML roles so Tableau users inherit granular permissions.
Verify the Server’s driver version, check that port 9000 is open, and confirm the service account still has SELECT on referenced tables.
.
No. Use the generic ODBC/JDBC option or a community .taco file. Functionality is equivalent once connected.
Yes. Select “Prompt User” during publishing to let each viewer supply personal ClickHouse credentials.