Skip to content
~/reflective_data

analytics-dictionary / tool overview / transformation & metrics

Dataform

Dataform is a Google Cloud service for developing and orchestrating SQL transformations in BigQuery.

Written by Reflective Data experts · updated Oct 5, 2026

It offers a workflow similar to dbt: SQL models with dependencies, tests, documentation and scheduling, tightly integrated with BigQuery.

It suits teams that want a native Google Cloud option for in-warehouse transformation.

related

dbtELT (extract, load, transform)Google BigQuery

// how we can help

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

more in transformation & metrics

dbt-macro.md

dbt macro

A dbt macro is a reusable piece of SQL logic written with Jinja templating.
metric.md

Metric

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

Data contract

A data contract is an agreement between data producers and consumers about the structure and meaning…
semantic-layer.md

Semantic layer

A semantic layer defines your business metrics and dimensions once, so every tool and person gets…
slowly-changing-dimension.md

Slowly changing dimension (SCD)

A slowly changing dimension is a descriptive attribute, like a customer segment, whose value changes over…
data-grain.md

Data grain

The grain of a table is what a single row represents, such as one order line…

← full analytics dictionary