PopSQL

Announcing PopSQL's dbt Core Integration

PopSQL Team
June 10th, 2021
Post Cover Image

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.

workflow

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.

macro

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.

model

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.

dbt docs

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:

Ready for a modern SQL editor?