Announcing PopSQL's dbt Core Integration

The dbt™ platform 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 the dbt platform, there is an inefficient workflow between writing dbt models 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 Core™ integration, now you can write dbt code right in your SQL editor.

For data teams not using the dbt platform 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 Core 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.

More information:

• popsql.com/docs/dbt for documentation
• popsql.com/dbt to learn more about the benefits
• sign up for the beta