Changelog

dbt 1.4.5

Support for dbt 1.4.5 has been added.

Fixes and Tweaks

• BigQuery: Fixed issue causing Preview to query all records of a model, rather than a limit of 500 records
• Fixed an issue preventing sources with CamelCase names from being recognized

dbt 1.1.4, 1.2.5, 1.3.3, and 1.4.4

Support for dbt 1.1.4, dbt 1.2.5, dbt 1.3.3, and dbt 1.4.4 has been added.

Fixes and Tweaks

• Fixed issue causing errors when running dbt test when using dbt v1.2.X
• Fixed an issue preventing the using the Customer profiles.yml path setting

dbt 1.4.2 and 1.4.3

Support for dbt 1.4.2 and dbt 1.4.1 has been added.

Databricks support (beta)

Databricks is now a supported adapter, available as a beta feature for preview!

Trigger SQL Compilation and Preview

Clicking Compiled SQL or Preview will now trigger those actions automatically.

.env file support

Deep Channel will now parse any .env files found in the root of your open dbt project and load the environment variables defined within it. This allows you, for example, to easily define project-specific env vars that can then be referenced in your dbt project via the env_var macro.

Fixes and Tweaks

• Fixed issue preventing Format code using SQLFluff from showing up
• Fixed an issue causing a crash when calling the parse_xml function
• Fixed an issue treating quoted strings starting with -- as comments
• Fixed an issue that reported a problem when Jinja was used in the definition of a dbt source
• Fixed an issue allowing multiple dbt commands to be run simultaneously
• Copying results to the clipboard will now include the header row
• Fixed an issue preventing opening dbt projects whose dbt_project.yml is malformed
• Adjusted the schema of dbt_project.yml to not require + in certain keys

Come join us on Discord!

Swing by our new Discord Server to ask questions, request features, report bugs, and meet the team!

Link not working? Copy this and paste it in your browser: https://discord.com/invite/TBhUZvFGD6

dbt 1.4.0 and 1.4.1

Support for dbt 1.4.0 and dbt 1.4.1 has been added.

Preview shortcut

You can preview the contents of a dbt model by pressing the cmd+enter shortcut.

Easily rerun dbt commands

The dbt command history now shows a rerun when you hover it, allowing you to easily rerun a dbt command without typing.

New project, profile, and dbt version switchers

A slimmer and streamlined set of components let you easily open and close dbt projects, change profiles and targets, and jump between different versions of dbt. This sets the stage for an upcoming feature: a faster way to jump between dbt projects.

Fixes and Tweaks

• Suggest {{source}} for direct table references in dbt Project
• Fixed an issue with profiles.yml not being refreshed when changed
• Fixed an issue preventing edges from models to metrics from rendering in the lineage graph
• Fixed an issue causing "Loaded profiles.yml" toast to show on every dbt deps run
• Fixed an issue that would prevent dbt projects from opening
• Fixed an issue causing the current model name to be suggested inside {{ref}}
• Added support for {% block body %}{% endblock %} syntax

Fixes and Tweaks

• Significantly improved speed at which dbt projects are parsed for errors
• Fixed an issue that prevent the lineage graph from rendering models from other packages
• Fixed an issue that would prevent dbt projects from opening
• Improved specificity of errors for unknown dbt sources
• Provide more detailed error message when data warehouse connections fail
• Support for grants in .yml files
• Support for embedded Jinja expressions inside string literals