analytics-dictionary / term / data infrastructure

Change data capture (CDC)

Change data capture tracks inserts, updates and deletes in a source database and replicates only those changes.

Written by Reflective Data experts · updated Oct 5, 2026

Instead of copying whole tables again and again, CDC reads the database log and streams just what changed. It keeps a warehouse nearly in sync with the source with much lower load.

It is the preferred approach for replicating large operational databases.

Batch vs streaming Data pipeline ETL (extract, transform, load)

// how we can help

Moving data into your warehouse? Our managed pipelines run it for you. Managed data pipelines → · Browse integrations

Row-level security

Row-level security restricts which rows of a table a user can see, based on who they…

data.md

Data

Data is recorded information, such as numbers, text or events, that can be stored and analysed.

ga4-bigquery-export.md

GA4 BigQuery export

The GA4 BigQuery export sends your raw GA4 event data to a BigQuery dataset for custom…

data-warehouse-migration.md

Data warehouse migration

A warehouse migration moves data, models and reports from one warehouse platform to another.

data-lakehouse.md

Data lakehouse

A data lakehouse combines the low-cost storage of a data lake with the management and query…

microsoft-azure.md

Microsoft Azure

Azure is Microsoft cloud platform, with data services such as Synapse, Data Lake Storage and Fabric.

← full analytics dictionary