Introducing PopSQL + dbt. The first SQL editor with built-in dbt supportRead more →

Announcing PopSQL's dbt Integration

June 10th, 2021
Post Cover Image

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.

workflow

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.

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 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?