Build, refactor and discuss dbt models in real-time
Build, refactor and discuss dbt models in real-time
Model to DAG in one click
Explode the SQL of your model into a DAG of connected cells.
- A powerful SQL IDE. Count has contextual auto-complete, SQL linting and everything else you'd expect from a world-class IDE.
- Powerful real-time canvas. Import even your biggest dbt models and explore them visually with your team in real-time.
- Lineage graph. Automatically follow cell dependencies across all cells. See updates flow instantly through all linked cells in real-time.
Visualize, Validate, Annotate
Check the results of each step of your model and tweak the code and see the changes cascade through your DAG in real-time.
- Quick visuals. Rapidly validate the shape of your data using low code visuals.
- Parameters. Parameterize your models with interactive filters.
- Sticky notes. Leave notes for your team (and future you) about why you did what you did.
.gif)
Bring your whole team in
Get feedback and validate key assumptions with your team in real-time to form clear trusted documentation.
- Frames. Organize your cells into groups that make it easier for others to jump right in.
- Deep links. Send your team directly to any part of a canvas to give feedback and resolve issues.
- Locking. Restrict access to the code to avoid mistakes whilst editing.
A perfect union with your database
Recompile your DAG as a chain of CTEs fully compatible with your SQL database and dbt.
- Full SQL support. Count runs queries directly on your database so your data stays put and you can write queries using all your DB's features.
- Export. Export the full query lineage of any cell.
Plus everything else you need to transform data in record time
Scheduling & caching
Control how and when your data refreshes from static snapshots to hourly.
Flexible permissions
Control how and when your data refreshes from static snapshots to hourly.
CSV support
Drag CSV files directly into the canvas to explore and share them with your team.
Whiteboard features
Clarify your scope and prototype designs using Count's whiteboarding features.
Powerful version control
Count saves changes automatically so you never lose your work.
Full SQL support
Count runs queries directly on your database so your data stays put and you can use all your DB’s functions.
World-class security
We pride ourselves on having world-leading security controls. Read about them here.
No pie charts
Yeah sorry, we don’t do pie charts and probably never will. But we can do all of these.
Count has revolutionized our analytics.
We had a huge bottleneck with data modelling that the canvas has helped us completely clear.
