The best IDE for dbt.

The canvas lets you see your data models like never before. Import a model and all of its dependencies, explode each CTE as its own cell, and work with live results from your database. Identify bugs quickly, test changes, and deploy code back to dbt, all while collaborating in real-time.

We are building models 3x faster with the canvas, and they are actually being understood and used by the business because we built them together.
Justin Freels
Data Engineering Senior Manager, Accenture

Import your existing models

Count makes it easy to work with your data models no matter where they are. Choose which models, and macros to import directly from dbt Cloud and dbt Core, or simply paste in your SQL scripts into the canvas.

  • Import your code directly from Github or dbt Cloud
  • View all of your models at once or one by one
  • Run your code side by side in different environments and databases
Responsive Video Loop

Explore, debug, and explain models with ease

Stop digging through 1,000s of lines of someone else's code to find bugs. The canvas makes it easier than ever to visualize, and understand the logic behind complex data models. Explode models into DAGs of connected CTEs. Edit and run queries against your database for realtime results of every step in your model.

  • Explode your models and see the results of each CTE
  • Edit your code, compile Jinja on-the-fly and see results instantly
  • Validate your models with test queries and visuals
Responsive Video Loop

Prototype and deploy changes back to dbt

Testing code changes becomes as easy as comparing two cells side by side. Export the new code directly to GitHub, export Jinjia-fied or compiled SQL to go into any tool you need.

  • Commit code back to Github with one click
  • Export logic as SQL or a dbt model
  • Review logic changes using code diff

Build together with stakeholders

Annotate and explain core business logic with business stakeholders. Work through data quality issues in real-time and showcase your work to the whole business.

  • Work through your models and code side-by-side in real-time
  • Add sticky notes, screenshots and diagrams to give your code context
  • Share code instantly with secure but flexible permissions
Responsive Video Loop
Responsive Video Loop

Getting started tutorials

It's time to actually understand your DAGs.

Start solving your organization's biggest problems with Count today.