SolutionsTalk to us
Coming Soon

Dataform

The transformation layer that turns raw data into tested, version-controlled models in BigQuery.

FAQs

Frequently asked questions

What does an analytics engineer actually do?

An analytics engineer transforms raw data into clean, tested, documented models that the rest of the business can trust and query directly, sitting between data engineering (getting data in) and data analysis (using the data). In practice, this usually means building and maintaining Dataform models on top of a warehouse like BigQuery or Snowflake.

What is Dataform, and why do so many companies use it?

Dataform is Google Cloud's framework for transforming data inside BigQuery using SQL, with built-in testing, documentation, and version control. Companies use it because it turns ad-hoc, undocumented SQL scripts into a maintainable, auditable system that multiple people can safely work on at once.

Is Dataform overkill for a small or mid-sized company?

No, Dataform scales down as well as it scales up, and even a small team benefits from having tested, version-controlled data models instead of one-off queries no one remembers the logic behind. The complexity of Dataform itself doesn't grow with company size; what grows is the number of models you need.

Do you build custom Dataform models, or do you use templates?

We build custom Dataform models specific to your business logic and metrics definitions, because templated models rarely match how a specific business actually defines revenue, churn, or other core metrics. Generic templates can be a useful starting scaffold, but the modeling layer needs to reflect your actual business rules to be trustworthy.

What happens to our existing SQL scripts and reports during a Dataform migration?

Existing SQL logic is typically audited and rebuilt as tested Dataform models rather than copied over as-is, since most legacy SQL scripts have accumulated undocumented assumptions and edge cases over time. Reports connected to the old logic are then repointed to the new, tested models once validated side-by-side.