{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/9d966c60f92e4eabb5e09d65fc9a3907\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/9d966c60f92e4eabb5e09d65fc9a3907-62fd3e4d9deaa1f2.gif","duration":155.806,"title":"Postgres to ClickHouse Replication with Transformations","description":"In 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."}