Skip to content

Releases: SimonKDirect4me/dbt-sqlserver

dbt-sqlserver v1.11.7

19 Mar 01:08

Choose a tag to compare

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 Function relation type

T-SQL function materialization macros

  • Scalar functions: CREATE OR ALTER FUNCTION with @param syntax, BEGIN/RETURN/END body, WITH SCHEMABINDING for 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

18 Mar 20:55
62ca26e

Choose a tag to compare

Upgrade to dbt-core 1.10.20. No adapter changes needed — all 1.10.x patches are internal fixes.

dbt-sqlserver v1.10.1

18 Mar 20:48
3aefb5f

Choose a tag to compare

Upgrade dbt-adapters to >=1.22.0. Fix unit test materialization for 3-arg get_expected_sql.

dbt-sqlserver v1.10.0

18 Mar 20:37
5698bba

Choose a tag to compare

Upgrade to dbt-core 1.10.0.

Changes

  • Update snapshot macro to use new strategy.hard_deletes API (replaces strategy.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

18 Mar 18:11
a772467

Choose a tag to compare

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.