Learn how to perform financial account reconciliation tasks using Cloud Spanner, Dataflow, and BigQuery.
Overview
Syllabus
- 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!