Changelog

dbt 1.3.2

Support for dbt dbt 1.3.2 has been added.

Fixes and Tweaks

• Fixed an issue with the sort icon not pointing the correct direction when sorting results
• Added support for +docs to all config objects when validating dbt_project.yml
• Added View Problem button to see full problem of a dbt_project.yml
• Added better support for TIMETZ and TIMESTAMPTZ data types

Fixes and Tweaks

• Allow for opening of project whose dbt_project.yml is malformed
• Allow for profiles.yml in project's root directory or the location specified by DBT_PROFILES_DIR environment variable
• Fixed issue where source declarations would not fall back to the database defined in profiles.yml
• Fixed issue causing multi line text selection to highlight more than the actual selected text
• Added support aliases on {{ref}} macros
• Added support for EXCLUDE, RENAME and CONNECT BY syntax
• BigQuery: INTERVAL expression now accept expressions as inputs
• Added support for Jinja expressions in SQL strings

Click to open a query against a dbt model

You can now quickly open a new tab to query a dbt model by clicking on the arrow next to the model's Relation on the Overview tab.

Refresh profiles.yml and environment variables

Click Refresh to detect any changes to your profiles.yml for environment variables.

Fixes and Tweaks

• Fixed an issue with large database connections consuming excessive amounts of memory
• Fixed an issue that would reset scroll location when switching between tabs
• Database connection errors are now displayed in the Problems tab
• Added setting to toggle linting
• Added support for triple quotes in Jinja templates
• BigQuery: add support for JSON literals
• Added support for TOP {n} syntax

Fixes and Tweaks

• Fixed a critical memory leak that could cause the app to crash

Fixes and Tweaks

• Fixed an issue preventing SQLFLuff from downloading on Windows
• Fixed an issue with dbt not connected being show in the dbt Command Bar
• Fixed an issue that could cause a crash due to virtual environments in the dbt project
• Fixed an issue that would cause the Problems tab to report an incorrect number of problems
• Added support for PIVOT and UNPIVOT
• Added support for SUBSTR
• BigQuery: Added support for date part parameters in date_diff and date_trunc functions
• Added support for EXTRACT
• Treat PRIMARY as a keyword