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 concatenationProjects 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