v1.4.1

[sdebruyn]

v1.4.1

This is a minor release following up on 1.4.0 with fixes for long outstanding issues.
Contributors to this release are @cbini, @rlshuhart, @jacobm001, @baldwicc and @sdebruyn.

Features

• Added support for a custom schema owner. You can now add schema_authorization (or schema_auth) to your profile.
  If you do so, dbt will create schemas with the authorization option suffixed by this value.
  If you are authorizing dbt users or service principals on Azure SQL based on an Azure AD group,
  it's recommended to set this value to the name of the group. #153 #382
• Documentation: added more information about the permissions which you'll need to grant to run dbt.
• Support for DATETIMEOFFSET as type to be used in dbt source freshness tests. #254 #346
• Added 2 options related to timeouts to the profile: login_timeout and query_timeout.
  The default values are 0 (no timeout). #162 #395

Bugfixes

• Fixed issues with databases with a case-sensitive collation
  and added automated testing for it so that we won't break it again. #212 #391
• Index names are now MD5 hashed to avoid running into the maximum amount of characters in index names
  with index with lots of columns with long names. #317 #386
• Fixed the batch size calculation for seeds. Seeds will run more efficiently now. #396 #179 #210 #211
• Added nolock to queries for all information_schema/sys tables and views.
  dbt runs a lot of queries on these metadata schemas.
  This can often lead to deadlock issues if you are using a high number of threads or dbt processes.
  Adding nolock to these queries avoids the deadlocks. #379 #381
• Fixed implementation of {{ hash(...) }} for null values. #392

Under the hood

• Fixed more concurrency issues with automated Azure integration testing.
• Removed extra __init__.py files. #171 #202
• Added commits to be ignored in git blame for easier blaming. #385

Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/blob/master/CHANGELOG.md

---

This discussion was created from the release v1.4.1.