{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/a872562608864995b9016e67c3221693\" frameborder=\"0\" width=\"1512\" height=\"1134\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1134,"width":1512,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1134,"thumbnail_width":1512,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/a872562608864995b9016e67c3221693-00001.gif","duration":215.62,"title":"Real-time CDC from PostgreSQL","description":"In this demo, I will show you how to sync changes from Postgres to Snowflake in real time using change data capture. I will guide you through the process of creating a Postgres peer and a Snowflake peer, and then demonstrate how to use the create mirror command to capture CDC changes. We will insert and update data in the devices table on the Postgres peer and see the changes reflected in the Snowflake peer. By the end of this video, you will have a clear understanding of how to keep your Postgres and Snowflake databases in sync."}