analytics-dictionary / tool overview / transformation & metrics

SQLMesh

SQLMesh is a data transformation framework with virtual environments and strong change management.

Written by Reflective Data experts · updated Oct 5, 2026

It understands SQL, tracks changes and shows the impact of a change before it is applied, while avoiding unnecessary recomputation.

It is an alternative to dbt for teams that value safe, incremental deployments.

// how we can help

We build tested data models and semantic layers, or host them for you. Semantic layer build → · Hosted dbt on the platform

A data mart is a focused subset of a warehouse built for one team or subject,…

A dbt test is an automated check that a model meets expectations, such as unique, not…

A slowly changing dimension is a descriptive attribute, like a customer segment, whose value changes over…

A surrogate key is a generated identifier, with no business meaning, used to uniquely identify a…

A metric is a quantitative measure of performance, such as revenue, conversion rate or active users.

A dimension is an attribute used to slice or group metrics, such as country, device or…