v.21.11Improvements

Query Obfuscator Enhancements in ClickHouse

Official CH changelog text
Query obfuscator: clickhouse-format --obfuscate now works with more types of queries. #29672 (alexey-milovidov).
Query obfuscator: The command clickhouse-format --obfuscate has been enhanced to support obfuscation for a wider range of query types.

Why it matters

This feature improves query security and privacy by enabling users to obfuscate sensitive information across more diverse SQL queries. It helps in sharing and analyzing query patterns without exposing confidential data.

How to use it

Use the clickhouse-format tool with the --obfuscate flag to obfuscate queries, for example:

clickhouse-format --obfuscate < your_query.sql

This now works for a broader spectrum of queries beyond previous limitations.

Related resources

PreviousNext