dbt Core integration now in general release!

October 25th, 2023

We are thrilled to announce that our dbt Coreâ„¢ integration is now available for everyone, as we transition from private beta to general release. This is a significant milestone in our journey to empower data teams with powerful SQL and dbt capabilities, and we can't wait to see how it transforms your workflow. Check out our dbt documentation or login to try it out!

Access on All Self-Service Plans

Starting today, you can access our dbt Core integration on any of PopSQL's self-service plans. Our Free and Premium plans include up to 10 dbt actions per month. For those on our Business plan, you'll be able to enjoy unlimited dbt actions. This means you can leverage the full potential of dbt within PopSQL, whether you're just getting started or need robust data transformation capabilities.

New Features to Enhance Your Workflow

To make your experience even more seamless, we've introduced two exciting improvements to our dbt integration:

1) Merge Conflict Handling within PopSQL's dbt Editor

Handling merge conflicts can be a daunting task, especially when working collaboratively on data transformations. With PopSQL's dbt integration, you can now tackle merge conflicts directly within the dbt editor. Say goodbye to the hassle of switching between tools, and effortlessly resolve conflicts to keep your data pipelines running smoothly.

2) Multiple Targets for Enhanced Flexibility

We understand that managing multiple database connections and target schemas is a common need for data teams that use dbt Core. That's why we're introducing the ability to add multiple targets within PopSQL. This feature allows you to toggle between different connections and target schemas effortlessly, streamlining your dbt command execution. PopSQL generates unique profiles for each target, making your workflow even more organized and efficient.

3) Canceling dbt Commands

dbt commands can now be canceled by clicking the X in the CLI.

4) Other updates

  • PopSQL's dbt integration now supports using Redshift instances that require login through Okta.

  • We've also added support for Snowflake's OAuth login.

  • dbt logs panel is now resizable

  • Update from main git action, which merges the configured main into current branch.

Get Started Today

Whether you're a Free, Premium, or Business plan user, you can start leveraging these new features and the power of dbt within PopSQL right away. Our goal is to empower data teams to work smarter and faster, and we're excited to continue supporting you on this journey.

Thank you for being a part of the PopSQL community. We can't wait to see the amazing things you'll achieve with our dbt Core integration!

If you have any questions or feedback, please don't hesitate to reach out to our support team. Your input helps us continue to improve and evolve PopSQL to meet your data needs.

Happy querying and transforming!

The PopSQL Team

Ready for a modern SQL editor?