Change Data Capture (CDC)

Problem

You need to replicate database changes to a downstream search index in real time. Instead of polling the tables, you decide to stream the database transaction logs. Write a query that outputs concept with the value: "CDC tracks inserts, updates, and deletes from a source database transaction log and streams them to target systems in near real-time."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution