menu

Changelog


dbt 0.20.2

Support for dbt 0.20.2 has been added.

Copy column names

You can now copy a comma-separated list of a table's columns from the right click context menu of tables in the connection explorer.

Quicker Postgres and Redshift syncs

We have improved the synchronization of Postgres and Redshift connections by reducing the number and complexity of queries needed to perform the sync. This means faster sync times for connections of these types, with improvements of up to 500% for larger connections.

Handling of very large connections

We have added some performance tweaks for connections with very large amounts of schemas, tables and columns. This will address the performance impacts there were for connections with several hundred thousand or more total schemas, tables and columns.

Connections determined to be impacted will now hide databases and schemas by default, instead of showing them all. The data for these databases and schemas will only be synced when they are shown, which means changing the selection of shown databases or schemas will automatically resync the connection. Other connections will keep working as before, with changes to shown databases and schemas being instantaneous.

Longer term, we will be working on refining the inner-workings of the app to improve the handling of these large connections, as well as connection syncing in general.

Fixes and tweaks

  • The "Tables" and "Views" folders in the connection explorer will no longer be shown if they are empty. If they aren't empty, they will now be expanded by default.
  • Fixed the opening of web links in terminals.
  • dbt versions will now be sorted with the most recent versions first.
  • When hovering over a target in the dbt target selector, sensitive fields such as passwords will now be masked.

dbt 0.20.0 and 0.20.1

Support for dbt 0.20.0 and dbt 0.20.1 has been added.

Fixes

  • Newly discovered databases and schemas on connections will now be shown by default, instead of being hidden until you manually select them.

Whilst we work on some larger changes behind the scenes, this release brings several minor bug fixes and performance improvements.


dbt 0.19.2

Support for dbt 0.19.2 has been added.

dbt Terminal Support

dbt can now be used in Studio's terminals without needing to have manually installed dbt locally. The version currently selected under "Configure dbt Project" will be injected into your path by modifying the $PATH environment variable.

Studio terminal showing injected dbt

This feature can be turned off in the settings.

Terminal Support Toggle

Cleaning up dbt versions

dbt versions can now be deleted, allowing you to clean up old or unused versions to save some disk space. You can delete a version by hovering over it in the version selector and pressing the "Delete" button.

Version selector with Delete button

Improved dbt target selection

When you hover over a target under "Configure dbt Project", you will now see the config for that target displayed in a popup.

Target selection with target config in popup

Also, when a target cannot be parsed, instead of just not being disaplyed, it will now be shown in the selector as disabled along with an error that shows on hover explaining exactly what the problem was.

Toggle Theme Shortcut

A new shortcut of Cmd+Shift+T on macOS or Ctrl+Shift+T on Windows and Linux has been added for toggling between light mode and dark mode. This toggle has also been added to the application menu under "View".

Copy model name

A new "Copy Model Name" entry has been added to the right-click context menu for dbt models.

Target selection with target config in popup

Support for service-account BigQuery dbt targets

BigQuery dbt targets using the service-account method are now supported and will have an associated connection created when selected.

Improved autocompletion for ref and source tags

Both packages and models or seed files inside packages are now autocompleted when using the ref tag. Seed files will also now be autocompleted for source tags.

Target selection with target config in popup

Fixes

  • Columns of a binary type on Snowflake connections will now be correctly displayed as hex strings.
  • Downloaded CSVs of results for Snowflake connections will now have the field names correctly escaped when they contain commas.
  • You will now be shown a warning if you try to use an unsupported flag in the dbt command input.
  • Toggling the dbt command bar (Cmd+Enter/Ctrl+Enter) now also works whilst on the "Terminal" tab.

More consistent handling of environment variables

If you are using environment variables in your dbt project configs, you now should be able to declare those variables anywhere in your shell config, not only in shell config that is loaded for non-interactive terminals. Basically - if the environment variable is available in your native terminal, it will be available to dbt in Studio.

Studio's terminals also should now have exactly the same environment as your native terminals. Previously there could be discrepancies leading to programs no longer being in your path, most noticeably with zsh on macOS.

Fixes

  • dbt commands that include quotes will now be correctly parsed on Windows.
  • Fixed a potential crash when copying extremely long results to the clipboard.
  • Fixed a bug where clicking the new tab button for a non-focussed split would open the new tab in the wrong split.
  • Moving a dbt project file by dragging and dropping it will now correctly update the paths of any tabs for that file that were open.
  • Closing a tab that has in-progress actions will no longer cause errors.
  • Multiple minor stability and bug fixes.