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