dbt adapter for SQL Server and Azure SQL
Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/compare/v1.7.3...v1.7.4
NOTE: as of this release, the patch number is not indicative of upstream dbt-core
version. We will be using patch versions for patch releases and matching dbt-core
on minor version until their new versioning schema for adapters is adopted.
Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/compare/v1.7.2...v1.7.3
Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/compare/v1.4.3...v1.7.2
Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/compare/v1.4.3...v1.7.2rc1
Another minor release to follow up on the 1.4 releases.
Replacing the usage of the dm_sql_referencing_entities
stored procedure with a query to sys.sql_expression_dependencies
for better compatibility with child adapters.
Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/blob/master/CHANGELOG.md
Minor release to follow up on 1.4.1 and 1.4.0.
Adding nolock to information_schema and sys tables/views can be overridden with the dispatched information_schema_hints
macro. This is required for adapters inheriting from this one.
Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/blob/master/CHANGELOG.md
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.
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
DATETIMEOFFSET
as type to be used in dbt source freshness tests. #254 #346
login_timeout
and query_timeout
.
The default values are 0
(no timeout). #162 #395
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
{{ hash(...) }}
for null values. #392
__init__.py
files. #171 #202
Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/blob/master/CHANGELOG.md
nolock
query hint to several metadata queries to avoid deadlocks by @Elliot2718 in https://github.com/dbt-msft/dbt-sqlserver/pull/204
Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/compare/v1.3.2...v1.4.0
dbt-core
that is compatible with the library by @l-j in https://github.com/dbt-msft/dbt-sqlserver/pull/356
Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/compare/v1.3.1...v1.3.2
Full Changelog: https://github.com/dbt-msft/dbt-sqlserver/compare/v1.3.0...v1.3.1