In this blog, we’ll walk through an example of using Kafka Connect to consume writes to PostgreSQL, and automatically send them to Redshift. With this configuration, your analytics database can be updated with the latest production data in real-time, without any manual ETL jobs. Interested in transitioning to a career in data engineering? Find out more about the Insight Data Engineering Fellows Pr
![Syncing Redshift & PostgreSQL in real-time with Kafka Connect](https://cdn-ak-scissors.b.st-hatena.com/image/square/7c50f3e60bec529d66640facc22f54eca2363d27/height=288;version=1;width=512/https%3A%2F%2Fmiro.medium.com%2Fv2%2Fresize%3Afit%3A790%2F1%2ApYpurugpdz35peaoDNB93A.png)