3 hints available

HardData EngineeringTheorySnowflake Streaming Data

CDC — Designing a Debezium Pipeline and Handling Schema Changes

Your team is setting up CDC from PostgreSQL to Snowflake for three tables: users 10M rows, orders 500M rows, events 10B rows. (1) Describe the complete CDC architecture from PostgreSQL to Snowflake, naming each component. (2) The source team tells you they are renaming user_email to email next week. What exactly breaks in your CDC pipeline and what do you do? (3) For the users table, records are sometimes deleted when a user closes their account for GDPR right to erasure. How do you handle these deletes in Snowflake while remaining GDPR-compliant?

Sign in to attempt this problem

Free account gives you full access to community problems with the complete solution reveal: golden answer, senior walkthrough, and score breakdown, after submission.

Start free →Already have an account? Sign in