video1.0<iframe src="https://www.loom.com/embed/9d966c60f92e4eabb5e09d65fc9a3907" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/9d966c60f92e4eabb5e09d65fc9a3907-62fd3e4d9deaa1f2.gif155.806In this video, I demonstrate replicating a Postgres database table to Clickhouse while masking the SSN column using Lua scripts. I create a CDC-based mirror named "mask_SSN" and validate it before kicking off the replication process. The demo showcases how the SSN column is masked in Clickhouse, ensuring data security.