Streaming MySQL to BigQuery with the binlog: how CDC works, and the parts that bite

Most teams start syncing MySQL to BigQuery with a nightly dump or a query like SELECT * FROM orders WHERE updated_at > :last_run. It works until someone asks why deleted orders still show up in the da