analytics-dictionary / term / data infrastructure

Materialized view

A materialized view stores the precomputed result of a query, so reports read it quickly instead of recomputing it.

Written by Reflective Data experts · updated Oct 5, 2026

Unlike a normal view, which runs its query every time, a materialized view is refreshed on a schedule or incrementally. It trades storage and freshness for speed and lower query cost.

Good candidates are heavy aggregations used by many dashboards.

Data mart Data modeling Partitioning and clustering

// how we can help

We design, build and optimise data warehouses and the cloud infrastructure around them. Data infrastructure services → · Managed data pipelines

GA4 BigQuery export

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

etl.md

ETL (extract, transform, load)

ETL is a process that extracts data from sources, transforms it, and then loads it into…

data-warehouse-migration.md

Data warehouse migration

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

data-retention.md

Data retention

Data retention policies define how long different data is kept before it is deleted or archived.

data-masking.md

Data masking

Data masking hides or obscures sensitive values, so people can work with data without seeing personal…

elt.md

ELT (extract, load, transform)

ELT loads raw data into the warehouse first and transforms it there afterwards, using the warehouse…

← full analytics dictionary