Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes
Power BI Fundamentals - Create visualizations and dashboards from scratch
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Learn how to perform financial account reconciliation tasks using Cloud Spanner, Dataflow, and BigQuery.
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!