How to Stream data to snowflake using change data capture

Data is the new oil, but it’s only useful if you can move, analyze, and act on it quickly. A Nucleus Research study shows that tactical data loses half its value 30 minutes after it’s generated, while operational data loses half its value after eight hours.

Change data capture (CDC) plays a vital role in the efforts to ensure that data in IT systems is quickly ingested, transformed, and used by analytics and other types of platforms. Striim is a unified data streaming and integration platform that offers non-intrusive, high-performance CDC from production databases to a wide range of targets.

In this live technical demo, we will walk you through a use case where data is replicated from PostgreSQL to Snowflake in real time, using CDC. We will demonstrate how change events are extracted from a PostgreSQL database as they are created and then streamed to Snowflake hosted on Microsoft Azure.