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.
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