Releases: SimonKDirect4me/dbt-sqlserver
Releases · SimonKDirect4me/dbt-sqlserver
dbt-sqlserver v1.11.7
What's Changed
dbt-core 1.11.7 upgrade
- Bumped dbt-core dependency to >=1.11.0
- Bumped dbt-adapters dependency to >=1.22.0
- Added
Functionrelation type
T-SQL function materialization macros
- Scalar functions:
CREATE OR ALTER FUNCTIONwith@paramsyntax,BEGIN/RETURN/ENDbody,WITH SCHEMABINDINGfor deterministic volatility - Table functions: inline table-valued functions with
RETURNS TABLE AS RETURN (...) - Aggregate functions: clear compiler error (SQL Server aggregates require CLR assemblies)
Tests
- 10 functional tests for function materialization (scalar, table, aggregate)
Fixes
- Release workflow Python bumped from 3.9 to 3.11 (required by dbt-adapters>=1.22.0)
dbt-sqlserver v1.10.20
Upgrade to dbt-core 1.10.20. No adapter changes needed — all 1.10.x patches are internal fixes.
dbt-sqlserver v1.10.1
Upgrade dbt-adapters to >=1.22.0. Fix unit test materialization for 3-arg get_expected_sql.
dbt-sqlserver v1.10.0
Upgrade to dbt-core 1.10.0.
Changes
- Update snapshot macro to use new
strategy.hard_deletesAPI (replacesstrategy.invalidate_hard_deletes) - Fix concurrency test for new dbt output format
- Compatible with dbt-fabric 1.9.8+
All functional tests passing against SQL Server 2022.
dbt-sqlserver v1.9.10
Upgrade to dbt-core 1.9.10. Fix unit test materialization for dbt-adapters 1.22.x compatibility. All functional tests passing against SQL Server 2022.