PopSQL's dbt Integration
June 10, 2021 at 21:10
dbt has become an important part of the data team's workflow. It was recently voted as the most popular open source project in data.
For data teams that are using dbt, there is an inefficient workflow between writing a model in your code editor (eg VS Code), using your terminal to compile the model, and then copying and pasting the compiled code into your SQL editor to test things out. With PopSQL's new dbt integration, now you can write dbt code right in your SQL editor.
For data teams not using dbt yet, our integration is an easy way to get started. If you have SQL that you're often copying/pasting between queries, save that as a reusable snippet/macro and eliminate repetitive SQL.
Or if you have long SQL queries with multiple CTEs, you can break that down into a dbt model and save it in your database as a view or table to simplify your BI queries.
Next, we plan on showing your dbt documentation inside of PopSQL. So if you're writing table/column descriptions in your dbt source files, we'll show those descriptions in autocomplete as you're writing SQL, and in our schema browser.
Our dbt integration is currently in beta and we're gradually rolling it out. If you're interested in trying it, please sign up for the beta.