PopSQL

Changelog

Latest product updates.
Follow us on Twitter to hear first.

Autocomplete for dbt Files Now Available!

December 11th, 2023

We're excited to announce a significant update to PopSQL – the introduction of autocomplete support in dbt files! This enhancement marks the first phase of our journey towards providing a comprehensive autocomplete experience for dbt references like macros and models.

Watch a brief demo of autocomplete in the PopSQL dbt editor or keep reading for more info.

What's New?

Seamless Autocomplete in dbt File Editor

  • Standard Autocomplete Features: Utilize PopSQL's trusted autocomplete functionality within the dbt file editor.
  • Broad Scope: Autocomplete support now extends to schemas, tables, views, columns, functions, keywords, and even column aliases defined in CTEs in your current file.
  • Enhanced Productivity: Spend less time typing and more time analyzing. Our autocomplete feature streamlines your workflow by suggesting relevant database objects and SQL syntax.

What's Next?

This release lays the groundwork for:

  • Advanced dbt References Autocomplete: We are gearing up to incorporate autocomplete for more complex dbt references, including macros and models.
  • dbt File Linting: Alongside autocomplete, we are developing linting capabilities specifically for dbt files, aiming to enhance code quality and consistency.

Get Started

To experience the new autocomplete functionality, simply open a dbt file in PopSQL. The autocomplete features are ready to assist you right out of the box.

Check out PopSQL's dbt documentation for more info!

As always, we are eager to hear your feedback and suggestions as we continue to improve and expand our features.

Happy querying,

The PopSQL Team

December 8th, 2023

We've rolled out an exciting update to our global search functionality. Now, you can effortlessly search for dbt files from PopSQL's global search (shortcut: cmd+k).

How to Use:

  • Global Search: Access global search with the cmd+k keyboard shortcut.
  • Basic Search: Enter your search terms to find dbt file names matching your query.
  • Expand for Advanced Search: Hit "Enter" or click on 'Search within queries and dbt files...' for a more in-depth search that will scan file contents for your search term.

dbt files in search

This new feature enables you to navigate your dbt files more efficiently, making your workflow smoother and faster. Whether you're looking for a specific dbt model or need to reference a macro, our enhanced search has got you covered.

Check out PopSQL's dbt documentation for more info.

We're excited for you to try out this new capability and see how it streamlines your work in PopSQL. As always, we're here to support you. If you have any questions or feedback, feel free to reach out through our chat widget or at hi@popsql.com.

Happy searching with PopSQL's enhanced global search!

The PopSQL Team

Enhanced dbt Integration: Sync Your dbt Docs to PopSQL's Data Catalog

December 5th, 2023

We're excited to announce a significant update to our dbt integration in PopSQL! Now, you can seamlessly sync your dbt docs information directly into PopSQL's Data Catalog. This enhancement brings a more comprehensive and informative experience to data exploration for you and your team.

What's New

Easily sync table and column descriptions from your dbt docs into PopSQL's Data Catalog. This information will be readily accessible in these areas of PopSQL:

  • Schema Pages: View detailed descriptions when exploring your schema.
  • Schema Tree Hover: Get quick insights by hovering over tables and columns.
  • Autocomplete widget: Enhanced autocomplete with detailed context about tables and columns.

dbt docs in data catalog

How to Use

  1. Set Up Sync: Navigate to your Organization's dbt preferences in PopSQL.You'll find a new section dedicated to syncing dbt docs.
  2. Select Correct Target: Ensure you select the appropriate target for your production dbt docs.
  3. Sync to Data Catalog: Click 'Sync to Data Catalog' to initiate the sync process. Note that each sync will overwrite the current data catalog values in PopSQL with the latest from your dbt docs.

Once the sync is complete, you'll receive a notification detailing how many table and column descriptions have been updated in PopSQL. Remember, only newly added or changed descriptions are counted in this update.

Read more details in PopSQL's dbt documentation.

Get Started: Excited to try this new feature? We're here to help you get started! For any questions or to request access to data catalog, feel free to reach out. You can email us directly at hi@popsql.com.

SQLFluff Integration Now Available in PopSQL!

November 9th, 2023

We're thrilled to announce that PopSQL has partnered with SQLFluff to bring real-time SQL linting to your query editor! This new feature is designed to streamline your workflow, enhance code quality, and enforce consistent SQL coding practices within your team.

Watch a brief demo of SQLFluff in PopSQL or keep reading for more information.

Real-time Linting

As you type your SQL queries in PopSQL, SQLFluff will now lint your code in real-time. This means immediate feedback on your SQL syntax, style, and any potential errors, saving you time and hassle with instant visibility into areas of improvement.

Enable in Organization Preferences

This powerful new feature can be easily enabled within your organization's preferences in PopSQL. Here's how:

  1. Go to your preferences.

  2. Navigate to the 'Linter' section.

  3. Toggle on the integration for SQLFluff linting and add your configuration rules.

Custom SQLFluff Configuration

PopSQL understands that different teams have different coding standards. That's why we've made it possible for you to add your own SQLFluff configuration file. Customize linting rules to align with your team's conventions and maintain the integrity of your codebase. Here's how to customize:

  1. Create a .sqlfluff configuration file with your desired rules.

  2. Paste it into the SQLFluff configuration box in your Linter settings in PopSQL.

  3. SQLFluff will use your custom rules to lint queries.

Benefits of SQLFluff Integration:

  • Consistency: Maintain a consistent code style across your entire team's SQL scripts.

  • Quality Assurance: Catch potential errors early in the development process.

  • Efficiency: Reduce the need for manual code reviews for stylistic or simple logical errors.

Get Started

To get started, update your PopSQL to the latest version and explore the organization preferences to enable SQLFluff linting. Should you need any assistance or have feedback, check out the SQL Linting documentation, or reach out to our support team!

Feedback

We're excited to see how this integration will help improve your team's productivity and code quality. If you have any feedback or suggestions, please reach out to us!

Happy querying,

The PopSQL Team

Search filter added to dbt file tree

November 9th, 2023

You can now filter dbt files by typing a search string in the PopSQL dbt file tree.

The filter can be accessed by hovering over the dbt file tree and clicking on the magnifying glass.

dbt file filter

This new feature was designed to make it easier to find the files you're looking for to speed up dbt development. You can also use PopSQL's global search to find dbt files and search for functions or references inside file contents.

Happy querying!

PopSQL Editor Now Offers 50+ Color Themes!

November 1st, 2023
Post Cover Image

At PopSQL, we believe in giving you the freedom to customize your experience. That's why we're thrilled to announce that our editor now supports over 50 vibrant color themes, providing you with a plethora of options to make your work environment truly your own.

A World of Color Awaits

Our updated theme selection includes not only the two classic PopSQL themes (one dark and one light) but also a wide array of themes available for the Monaco editor (see the full list here). Whether you're a fan of light or dark themes, prefer higher contrast, or want to mix a light app theme with a dark editor theme, we've got something to suit your style.

To explore the full spectrum of themes available, simply visit the editor preferences page. Here, you'll be able to toggle themes and settings with a preview editor to see how it'll look.

How to Change Your Theme

Changing your theme is a breeze! Follow these simple steps:

  1. Click on your profile picture or initials in the bottom left corner of the PopSQL app.

  2. Select "Preferences" from the menu.

  3. In the preferences panel, click on "Editor."

  4. You'll find the "Theme" section, where you can choose your desired theme from the extensive list.

  5. Your new theme will be applied instantly.

Thank you for being a part of the PopSQL community, and happy querying!

The PopSQL Team

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

New Integration: Stream Results Directly to Google Sheets

September 9th, 2023
Post Cover Image

Introducing a new integration with Google Sheet! Now, you can seamlessly stream your query results right into Google Sheets from PopSQL.

  • Direct Streaming: Stream results directly to Google Sheets without having to wait for them to load in PopSQL and copy-paste results. This ensures a smoother experience, especially with large results.

  • Ease of Setup: All it takes is a simple authentication with your Google account. Once you approve the PopSQL app within Google Sheets, you're all set to use this integration.

  • Performance and Stability: Worried about large results slowing down your PopSQL app or browser? Fear not! Since results aren't cached in PopSQL with this method, your app won't slow down or crash.

  • Use Case Clarity: While this feature shines for one-time exports of results to Google Sheets, if you're looking to refresh data periodically and push it to Sheets, we recommend using PopSQL's CSV links feature with scheduled queries.

  • Results Limitations: While PopSQL doesn't cap the size of your results, remember that Google Sheets has a ceiling of 10 million cells per sheet.

With PopSQL's new Google Sheets integration you can collaborate and capitalize on your data in a familiar, user-friendly environment. Dive in today and redefine how you visualize and share your insights!

Check out a demo video in the docs.

Note: This feature currently only works for cloud connections to Postgres, Redshift, BigQuery, Snowflake, Trino, Presto, Materialize. Support will be added for other connection types soon.

Ready for a modern SQL editor?