Powered by OpenAIRE graph
Found an issue? Give us feedback
ZENODOarrow_drop_down
ZENODO
Article . 2025
License: CC BY
Data sources: Datacite
ZENODO
Article . 2025
License: CC BY
Data sources: Datacite
versions View all 2 versions
addClaim

Cloud-Native Change Data Capture: Real-Time Data Integration from Google Spanner to BigQuery

Authors: Gadi Parthi, Ashok; Kodali, Ravi Kiran; Pothineni, Balakrishna; Veerapaneni, Prema kumar; Maruthavanan, Durgaraman; Sankiti, Srivenkateswara Reddy;

Cloud-Native Change Data Capture: Real-Time Data Integration from Google Spanner to BigQuery

Abstract

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.

Keywords

Data Integration, Cloud Dataflow, Google Cloud Spanner, BigQuery, Streaming Data Pipelines

  • BIP!
    Impact byBIP!
    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
Powered by OpenAIRE graph
Found an issue? Give us feedback
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).
BIP!Citations provided by BIP!
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.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
0
Average
Average
Average
Upload OA version
Are you the author of this publication? Upload your Open Access version to Zenodo!
It’s fast and easy, just two clicks!