Reconciling Account Data with Cloud Spanner Change Streams

Learn how to perform financial account reconciliation tasks using Cloud Spanner, Dataflow, and BigQuery.

• GSP1097
• Overview
• What you'll learn
• Setup and requirements
• Task 1. Create a database accounts and insert DDL
• Task 2. Insert arbitrary account data
• Task 3. Create a change stream for Balance and AccountStatus
• Task 4. Create an reconciliation dataset in BigQuery to receive change stream data
• Task 5. Create a Dataflow change stream pipeline
• Task 6. Create changes in Spanner and track them in BigQuery
• Congratulations!