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 tea

Announcing PopSQL's dbt Integration

submited by

Style Pass

2021-06-10 21:30:04

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.