v.19.8Improvements

Clickhouse-obfuscator: Derive Seed for Individual Columns by Combining Initial Seed with Column Name, Not Column Position

Official CH changelog text
clickhouse-obfuscator: derive seed for individual columns by combining initial seed with column name, not column position. This is intended to transform datasets with multiple related tables, so that tables will remain JOINable after transformation. #5178 (alexey-milovidov)
clickhouse-obfuscator now derives the seed for obfuscating individual columns by combining the initial seed with the column name instead of the column position.

Why it matters

This change ensures that datasets with multiple related tables remain consistent and JOINable after obfuscation, as the transformation for each column is stable regardless of the column order. It improves usability when anonymizing complex data schemas.

How to use it

When using clickhouse-obfuscator, the column seed derivation automatically combines the initial seed with the column name. Users do not need to change their commands, but can rely on consistent obfuscation for JOINable keys across related tables.

Related resources

PreviousNext