The data modeling platform for Segment

The data modeling platform for Segment

+

Segment helps organizations collect user event data across web and mobile apps. This gives analysts data across the entirety of the users lifecycle. Segment provides connectors to export the data into BigQuery. Dataform then makes it easy to model the data into clean, reliable, tested datasets that power your company’s analytics.

</>

Set up core Segment data models in minutes

The raw data tables Segment create are just a starting point. Transforming the datasets into well structured, de-normalised tables - for example sessions or page_views - speeds up future analysis. With Dataform you can set up the core Segment data models with just a few lines of code.

</>

Version control your SQL

The Dataform web IDE is natively integrated with GitHub and GitLab. Version controlling your SQL has never been easier: create branches, commit changes, revert files and create pull requests without ever needing to touch the command line.

</>

Intuitive dependency management

Dataform’s built in SQLX functions enable us to infer dependencies and automatically build the dependency graph for your transformation pipeline.

Kaleva
Livup
Echo
Charlotte Tilbury
Acordo Certo
Big Tree
Teatime Games
Slite
Tasman Analytics
Butternut Box
Outshine
Dreamdata
Mittelbayerische
SME Capital
Mixcloud
Rapidoo
Prolific
Unbound Solar

Learn more about the Dataform data modeling platform

Dataform brings open source tooling, best practices, and software engineering inspired workflows to advanced data teams that are seeking to scale, enabling you to deliver reliable data to your entire organization.

What our customers say

Mike Lee

Head of Data

speech marks

Being able to produce analytics tables that we are confident in the output of (because of assertions) and are as up to date as we need them to be (because of scheduling) makes our lives really easy. The UI is incredibly easy and intuitive to use, meaning we spend little of our time setting these things up, and most of our time writing SQL!

Echo Logo
Jim Lumsden

Growth Analyst

speech marks

I love the dependency tree in Dataform. For me this is a central place for sanity checking my data flows, understanding if I'm reimplementing a dataset which already exists, and verifying logic. Secondly, I love SQLX for generating SQL of a similar structure again and again, it really speeds up development and let's your abstract away logic.

Prolific Logo
Saadat Photo
Saadat Qadri

Analytics Practice Lead

speech marks

Having modeled data using other tools in the past, this is much simpler and an easier environment to code in. The code compiles in real time and lets you know if there are errors in the syntax. It also helps generate a dependency graph for the data pipeline which is insanely useful.

Outshine Logo