https://popsql.com/updates/dbt-integration

Announcing our $3.4M seed round from Gradient Ventures, FundersClub,
and Y Combinator  Read more -
 

  * Product
        Shared queriesEditorVersion historyData catalog
        Query variablesDashboardsScheduled queriesCharts
        SearchConnections
     

    Featured case study

    [logo]

    FactoryFix democratizes data access across their company with
    PopSQL ->

  * Pricing
  * Resources
        DocsCustomers
        TutorialsTemplates
  * Updates
  * Contact

Sign InGet Started
Sign In

PopSQL

Product

    Shared queriesEditorVersion historyData catalog

    Query variablesDashboardsScheduled queriesCharts

    SearchConnections

---------------------------------------------------------------------
Pricing
---------------------------------------------------------------------
Resources

    DocsCustomersTutorialsTemplates

---------------------------------------------------------------------
Updates
Get Started

Announcing PopSQL's dbt Integration

byAuthor profile imagePopSQL Team
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.

[swatch]

More information:

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

---------------------------------------------------------------------

Spread the word

Tweet

Ready for a modern SQL editor?

Get started for free
Cta

  * About
  * Jobs
  * Security
  * Terms of Service
  * Privacy Policy

(c) PopSQL, Inc. 2021

  *  
  *