
Abstract This paper introduces a scalable, low-latency framework for real-time data replication from Google Cloud Spanner to BigQuery, leveraging Change Data Capture (CDC) via Google Cloud Dataflow. The proposed architecture captures transactional changes including inserts, updates, and deletions from Spanner using Change Streams and ensures their consistent delivery to BigQuery with minimal latency. Building upon Google's foundational CDC solution, the framework extends its capabilities through support for complex and nested data types, dynamic schema evolution, robust null value handling, and advanced exception processing. Key features such as checkpointing, dead-letter queue (DLQ) integration, and automated recovery enhance fault tolerance and system resiliency. This work also addresses limitations in Google's reference CDC implementation by introducing targeted enhancements for schema flexibility, fault resilience, and operational observability. The solution empowers enterprises to maintain continuously synchronized analytical datasets, enabling real-time insights and improved decision-making across business domains. Performance evaluations demonstrate high throughput, sub-second latency, and operational reliability, positioning the framework as a strong candidate for production-grade cloud-native data integration pipelines.
Data Integration, Cloud Dataflow, Google Cloud Spanner, BigQuery, Streaming Data Pipelines
Data Integration, Cloud Dataflow, Google Cloud Spanner, BigQuery, Streaming Data Pipelines
| selected citations These citations are derived from selected sources. This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | 0 | |
| popularity This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network. | Average | |
| influence This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | Average | |
| impulse This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network. | Average |
