![](https://popsql.com/static/features/dbt/dbtpopsql.png)
The first SQL editor with built-in dbt Core™ support
Create dbt macros and models, all within your SQL editor
![](https://popsql.com/static/features/dbt/video_thumbnail.jpg)
Eliminate repetitive SQL using macros
Instead of copying/pasting SQL between queries, create reusable snippets of SQL called macros.
Before
select created_at at time zone ‘utc’ at time zone ‘pdt’from users
After
select {{ to_pt(‘created_at’) }} from users
Simplify BI queries with data models
Use models to break down long, complicated queries.
Read the docsBefore
with activated_users as ( select users.id as user_id, count(orders.id) as num_orders from users left join orders on orders.user_id = users.id group by 1 having count(orders.id) > 0)select *from events einner join activated_users auon au.user_id = e.user_id
After
select * from events einner join {{ ref('activated_users') }} au on au.user_id = e.user_id
Create a data catalog backed by dbt docs
Write table/column descriptions in dbt, and have those descriptions available in PopSQL autocomplete.
![](https://popsql.com/static/features/dbt/docs.png)
Streamline your dbt workflow
Do your entire dbt workflow within PopSQL rather than switching between your code editor, terminal, and SQL editor.
![](https://popsql.com/static/features/dbt/workflow.png)
The most powerful workspace for data teams
dbt, dbt Core, and the dbt logo are trademarks of dbt Labs, Inc.