v.24.2Improvement

Connections Enhanced for MySQL Port to Improve BI Tool Compatibility

Official CH changelog text
Connections through the MySQL port now automatically run with setting prefer_column_name_to_alias = 1 to support QuickSight out-of-the-box. Also, settings mysql_map_string_to_text_in_show_columns and mysql_map_fixed_string_to_text_in_show_columns are now enabled by default, affecting also only MySQL connections. This increases compatibility with more BI tools. #60365 (Robert Schulze).
Connections to ClickHouse via the MySQL protocol now automatically apply settings to enhance compatibility with BI tools like QuickSight.

Why it matters

This feature improves out-of-the-box support for BI tools by enabling settings that prioritize column names over aliases and map string types appropriately in SHOW COLUMNS commands executed through MySQL connections. It addresses compatibility issues and reduces manual configuration for users integrating ClickHouse with BI tools.

How to use it

No action is required from users. When connecting through the MySQL port, ClickHouse automatically enables prefer_column_name_to_alias = 1, and both mysql_map_string_to_text_in_show_columns and mysql_map_fixed_string_to_text_in_show_columns settings are enabled by default to improve BI tool support.

Related resources

PreviousNext