v1.10.1rc1

Generated notes: Changelog.md

What's Changed

• (typo) Fix Spelling by @joshmarkovic in #694
• feat: start v1.10.1rc1 by @axellpadilla in #700
• chore(deps): bump the github-actions-updates group across 1 directory with 2 updates by @dependabot[bot] in #689
• fix to make drop_schema_name usable and test pass by @axellpadilla in #563
• Feat/mssql python Add optional mssql-python backend and update docs / CI by @axellpadilla in #681
• Add implementation of persist_docs using extending properties by @semcha in #289
• chore: consolidate isort, flake8, pycln and absolufy-imports into ruff by @joshmarkovic in #707
• Empty unit test fixtures (rows: []) emit invalid LIMIT 0 syntax by @Benjamin-Knight in #699
• chore(deps-dev): bump mypy from 1.11.2 to 2.1.0 in the pip-updates group across 1 directory by @dependabot[bot] in #691
• fix: guard run_hooks commit with @@trancount check for autocommit safety by @axellpadilla in #709
• Correctness fixes: LABEL escaping, dead columnstore guard, init port, misc by @joshmarkovic in #706
• #535 Postgres style indexes by @Benjamin-Knight in #714
• Implements dbt_sqlserver_use_dbt_transactions behavior flag by @axellpadilla in #710
• Quick-win fixes: badge, exception type, is_integer, CI matrix, dead code by @joshmarkovic in #716
• Relocate SQLSERVER_TEST_DRIVER to setup_env.sh to comply with no spaces. by @axellpadilla in #722
• Use uv sync --all-extras and run instead of explicit pip install commands by @axellpadilla in #723
• feat: safe type expansion, NVARCHAR/NCHAR catalog fix, seed empty cell fix by @axellpadilla in #702

Full Changelog: v1.10.0...v1.10.1rc1

v1.10.0

What's Changed

• Modernize packaging: migrate setup.py to PEP 621 pyproject.toml by @joshmarkovic in #645
• chore(dependabot): switch Dependabot to weekly and separate security by @axellpadilla in #666
• UV usage by @Benjamin-Knight in #668
• Update adapter to dbt 1.10. by @Benjamin-Knight in #669
• Fix snapshot meta column name overrides on second run (#639). by @Benjamin-Knight in #670
• Add opt-in native string type mappings via behaviour flag (#626). by @Benjamin-Knight in #671
• Add regression tests for connection-string port handling (#496). by @Benjamin-Knight in #672
• Add DML table refresh method for table materializations (#641). by @Benjamin-Knight in #673
• Add regression tests for limit handling in test SQL generation (#638). by @Benjamin-Knight in #675
• Fix CTE detection with comments (#621) by @Benjamin-Knight in #676
• Fix reserved-keyword quoting in table-create DROP VIEW (#619). by @Benjamin-Knight in #677
• Add TABLOCK hint to contract-enforced INSERT INTO (#640). by @Benjamin-Knight in #678
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in #412
• Update the catalog macros to support multiple databases by @Benjamin-Knight in #603
• Fix: Handle view materialization alterations by @axellpadilla in #610
• fix: Update model constraints functional test expectation for SQL Server contract INSERT semantics by @axellpadilla in #684
• ✨ feat: add default schema concatenation flag support and update documentation by @axellpadilla in #685
• perf: make hot-path adapter catalog queries sargable by @joshmarkovic in #686
• Update dbt-core dependency version range by @axellpadilla in #690
• Add query_options model config for SQL Server OPTION clauses (#613). by @Benjamin-Knight in #674
• Update SQL server relations to not require an alias by @Benjamin-Knight in #604
• Test tablock and query options interaction by @Benjamin-Knight in #679
• Update changelog for v1.10.0 by @axellpadilla in #693
• Improve environment setup and update dependencies for v1.10.0 by @axellpadilla in #696

Full Changelog: v1.9.1...v1.10.0

v1.10.0rc1

What's Changed

• Modernize packaging: migrate setup.py to PEP 621 pyproject.toml by @joshmarkovic in #645
• chore(dependabot): switch Dependabot to weekly and separate security by @axellpadilla in #666
• UV usage by @Benjamin-Knight in #668
• Update adapter to dbt 1.10. by @Benjamin-Knight in #669
• Fix snapshot meta column name overrides on second run (#639). by @Benjamin-Knight in #670
• Add opt-in native string type mappings via behaviour flag (#626). by @Benjamin-Knight in #671
• Add regression tests for connection-string port handling (#496). by @Benjamin-Knight in #672
• Add DML table refresh method for table materializations (#641). by @Benjamin-Knight in #673
• Add regression tests for limit handling in test SQL generation (#638). by @Benjamin-Knight in #675
• Fix CTE detection with comments (#621) by @Benjamin-Knight in #676
• Fix reserved-keyword quoting in table-create DROP VIEW (#619). by @Benjamin-Knight in #677
• Add TABLOCK hint to contract-enforced INSERT INTO (#640). by @Benjamin-Knight in #678
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in #412
• Update the catalog macros to support multiple databases by @Benjamin-Knight in #603
• Fix: Handle view materialization alterations by @axellpadilla in #610
• Fix: Update model constraints functional test expectation for SQL Server contract INSERT semantics by @axellpadilla in #684
• Feat: add default schema concatenation flag support and update documentation by @axellpadilla in #685
• Perf: make hot-path adapter catalog queries sargable by @joshmarkovic in #686
• Update dbt-core dependency version range by @axellpadilla in #690
• Add query_options model config for SQL Server OPTION clauses (#613). by @Benjamin-Knight in #674
• Update SQL server relations to not require an alias by @Benjamin-Knight in #604
• Test tablock and query options interaction by @Benjamin-Knight in #679
• Update changelog for v1.10.0 by @axellpadilla in #693
• Improve environment setup and update dependencies for v1.10.0 by @axellpadilla in #696

Full Changelog: v1.9.1...v1.10.0rc1

v1.9.2

What's Changed

• fix: backport to v1.9.2 add default schema concatenation flag support and update documentation by @axellpadilla in #687

Important schema behavior note

dbt-sqlserver==1.9.0 inherited schema-generation behavior through dbt-fabric. In dbt-fabric>=1.9.3, the Fabric custom schema override was removed, so projects could effectively fall back to dbt-core’s standard schema behavior:

<target.schema>_<custom_schema_name>
Starting with dbt-sqlserver==1.9.1, the Fabric dependency has been removed. SQL Server now keeps its legacy schema behavior by default:
<custom_schema_name>

To opt in to dbt-core’s standard schema concatenation behavior, add:

flags:
  dbt_sqlserver_use_default_schema_concat: true  # Enable standard schema concatenation

Projects should override with a custom generate_schema_name if they want to keep dbt-sqlserver legacy behavior.

Full Changelog: v1.9.1...v1.9.2

v1.9.1

Headline

This release removes this adapters upstream dependency on the dbt-fabric adapter.

Important schema behavior note

dbt-sqlserver==1.9.0 inherited schema-generation behavior through dbt-fabric. In dbt-fabric>=1.9.3, the Fabric custom schema override was removed, so projects could effectively fall back to dbt-core’s standard schema behavior:

<target.schema>_<custom_schema_name>

Starting with dbt-sqlserver==1.9.1, the Fabric dependency has been removed. SQL Server now keeps its legacy schema behavior by default:

<custom_schema_name>

To opt in to dbt-core’s standard schema concatenation behavior, add:

vars:
  dbt_sqlserver_use_default_schema_concat: true

Projects with a custom generate_schema_name macro should review whether it still matches the intended behavior.

This release also includes development, CI, and packaging updates that should not impact normal users.

What's Changed

• Remove Fabric Dependency by @Benjamin-Knight in #628
• ci: add Python 3.13 to workflows and packaging metadata by @axellpadilla in #625
• fix: (dev) container version upgrade, uv initial and small bugfixes by @axellpadilla in #647
• feat: Gate integration matrix by relevant paths by @axellpadilla in #658
• Bump actions/checkout from 4 to 6 by @dependabot[bot] in #649
• fix: Use uv to create and activate a workspace .venv to avoid permissions errors by @axellpadilla in #660
• fix: devcontainer post-start sequentially by @axellpadilla in #661
• fix(dev): devcontainer settings, fix keyring, add package init by @axellpadilla in #663
• Bump docker/login-action from 3.3.0 to 4.1.0 by @dependabot[bot] in #650
• Bump actions/setup-python from 5 to 6 by @dependabot[bot] in #652
• Bump v1.9.1 release and keeps pyodbc temporary by @axellpadilla in #664

Full Changelog: v1.9.0...v1.9.1

v1.9.1rc1

What's Changed

• ci: add Python 3.13 to workflows and packaging metadata by @axellpadilla in #625
• Remove Fabric Dependency by @Benjamin-Knight in #628

New Contributors

• @axellpadilla made their first contribution in #625

Full Changelog: v1.9.0...v1.9.1rc1

v1.9.0

Update to 1.9.

What's Changed

• Update to 1.9 by @Benjamin-Knight in #598

Full Changelog: v1.8.7...v1.9.0

v1.8.7

What's Changed

• Update the derivation of the test view name by @Benjamin-Knight in #576

Full Changelog: v1.8.6...v1.8.7

v1.8.6

What's Changed

• Resolves #588 by @Benjamin-Knight in #589

New Contributors

• @Benjamin-Knight made their first contribution in #589

Full Changelog: v1.8.5...v1.8.6

v1.8.5

What's Changed

• Update publish-docker.yml by @cody-scott in #571
• Python312 by @schlich in #486
• Fix broken imports from Fabric by @cody-scott in #582

Full Changelog: v1.8.4...v1.8.5