Used Cloud SQL Postgres as source of truth for vehicles, drivers and trips. Inspected schema to design batch sync to BigQuery and keep warehouse consistent with OLTP. Batch hourly sync avoided adding load to transactional path.
- What worked
- Schema was well structured for staging and mart modeling; hourly batch was sufficient for dimension consistency.
