Skip to content
~/reflective_data

analytics-dictionary / term / data infrastructure

SQL

SQL is the standard language for querying and managing data in relational databases and warehouses.

Written by Reflective Data experts · updated Oct 5, 2026

Analysts use it to select, filter, join and aggregate data. Almost every warehouse, BI tool and transformation tool such as dbt is built around it.

Readable, well-structured SQL with clear naming is a major part of a maintainable data stack.

related

Data modelingData warehousedbt

// how we can help

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

more in data infrastructure

data-latency.md

Data latency

Data latency is the delay between something happening and it being available for analysis.
infrastructure-as-code.md

Infrastructure as code

Infrastructure as code defines cloud resources in version-controlled files, so environments are reproducible and reviewable.
data-warehouse-migration.md

Data warehouse migration

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

Idempotency

An idempotent process gives the same result no matter how many times it runs.
data-quality.md

Data quality

Data quality describes how accurate, complete, consistent and timely your data is.
databricks.md

Databricks

Databricks is a data and AI platform built around the lakehouse approach and Apache Spark.

← full analytics dictionary