v.23.9Improvement

Enhancements to ClickHouse's Information Schema for MySQL Compatibility

Official CH changelog text
Made the views in schema information_schema more compatible with the equivalent views in MySQL (i.e. modified and extended them) up to a point where Tableau Online is able to connect to ClickHouse. More specifically: 1. The type of field information_schema.tables.table_type changed from Enum8 to String. 2. Added fields table_comment and table_collation to view information_schema.table. 3. Added views information_schema.key_column_usage and referential_constraints. 4. Replaced uppercase aliases in information_schema views with concrete uppercase columns. #54773 (Serge Klochkov).
Enhanced compatibility of information_schema views with MySQL for better integration with Tableau Online.

Why it matters

This feature improves ClickHouse's compatibility with MySQL by modifying and extending the information_schema views. It addresses issues preventing Tableau Online from connecting to ClickHouse by aligning the schema more closely with MySQL's expectations—such as adjusting data types, adding missing fields, and creating additional views that represent key constraints.

How to use it

Users benefit from this improvement automatically after upgrading to the new ClickHouse version containing these changes. The updated information_schema views require no special configuration, enabling tools like Tableau Online to connect seamlessly without manual intervention.

Related resources

PreviousNext