v.23.9Improvement

MySQL Interface Gains Minimal Prepared Statements for Tableau Online Connection to ClickHouse

Official CH changelog text
The MySQL interface gained a minimal implementation of prepared statements, just enough to allow a connection from Tableau Online to ClickHouse via the MySQL connector. #54115 (Serge Klochkov). Please note: the prepared statements implementation is pretty minimal, we do not support arguments binding yet, it is not required in this particular Tableau online use case. It will be implemented as a follow-up if necessary after extensive testing of Tableau Online in case we discover issues.
The MySQL interface in ClickHouse now supports a minimal implementation of prepared statements to enable connections from Tableau Online via the MySQL connector.

Why it matters

This feature allows Tableau Online to connect to ClickHouse using the MySQL protocol by providing basic prepared statements support. It addresses compatibility issues without yet implementing full prepared statement functionality such as argument binding, ensuring Tableau Online integration works smoothly.

How to use it

Users can connect Tableau Online to ClickHouse through the MySQL interface as usual. The minimal prepared statements support is enabled automatically to facilitate this connection. No additional configuration is currently required.

Related resources

PreviousNext