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.