Dbt-sqlserver

See changes included in v1.1.0rc1 below as well

Fixes

- [251](https://github.com/dbt-msft/dbt-sqlserver/pull/251) fix incremental models with arrays for unique keys ([sdebruyn](https://github.com/sdebruyn) & [johnnytang24](https://github.com/johnnytang24))
- [214](https://github.com/dbt-msft/dbt-sqlserver/pull/214) fix for sources with spaces in the names ([Freia3](https://github.com/Freia3))
- [238](https://github.com/dbt-msft/dbt-sqlserver/pull/238) fix snapshots breaking when new columns are added ([jakemcaferty](https://github.com/jakemcaferty))

Chores

- [249](https://github.com/dbt-msft/dbt-sqlserver/pull/249) & [#250](https://github.com/dbt-msft/dbt-sqlserver/pull/251) add Python 3.10 to automated testing ([sdebruyn](https://github.com/sdebruyn))
- [248](https://github.com/dbt-msft/dbt-sqlserver/pull/248) update all documentation, README and include on dbt docs ([sdebruyn](https://github.com/sdebruyn))
- [252](https://github.com/dbt-msft/dbt-sqlserver/pull/252) add automated test for [#214](https://github.com/dbt-msft/dbt-sqlserver/pull/214) ([sdebruyn](https://github.com/sdebruyn))

Features

- update to dbt 1.1

Fixes

- [194](https://github.com/dbt-msft/dbt-sqlserver/pull/194) uppercased information_schema ([TrololoLi](https://github.com/TrololoLi))
- [215](https://github.com/dbt-msft/dbt-sqlserver/pull/215) Escape schema names so they can contain strange characters ([johnf](https://github.com/johnf))

Chores

- Documentation on how to contribute to the adapter
- Automatic release process by adding a new tag
- Consistent code style with pre-commit
- [201](https://github.com/dbt-msft/dbt-sqlserver/pull/201) use new dbt 1.0 logger ([semcha](https://github.com/semcha))
- [216](https://github.com/dbt-msft/dbt-sqlserver/pull/216) use new dbt testing framework ([dataders](https://github.com/dataders) & [sdebruyn](https://github.com/sdebruyn))

Please see [dbt-core v1.0.0 release notes](https://github.com/dbt-labs/dbt-core/releases/tag/v1.0.0) for upstream changes

Fixes

- fix index naming when columns contain spaces [175](https://github.com/dbt-msft/dbt-sqlserver/pull/175)

Under the Hood

- re-organize macros to match new structure [184](https://github.com/dbt-msft/dbt-sqlserver/pull/184)

features

- Added support for more authentication methods: automatic, environment variables, managed identity. All of them are documented in the readme. [178](https://github.com/dbt-msft/dbt-sqlserver/pull/178) contributed by [sdebruyn](https://github.com/sdebruyn)

fixes

- fix for [186](https://github.com/dbt-msft/dbt-sqlserver/issues/186) and [#177](https://github.com/dbt-msft/dbt-sqlserver/issues/177) where new columns weren't being added when snapshotting or incrementing [#188](https://github.com/dbt-msft/dbt-sqlserver/pull/188)

Please see [dbt-core v0.21.0 release notes](https://github.com/dbt-labs/dbt-core/releases/tag/v0.21.0) for upstream changes

fixes

- in dbt-sqlserver v0.20.0, users couldn't use some out of the box tests, such as accepted_values. users can now also use CTEs in their ~bespoke~ custom data tests
- fixes issue with changing column types in incremental table column type [152](https://github.com/dbt-msft/dbt-sqlserver/issue/152) [#169](https://github.com/dbt-msft/dbt-sqlserver/pull/169)
- workaround for Azure CLI token expires after one hour. Now we get new tokens for every transaction. [156](https://github.com/dbt-msft/dbt-sqlserver/issue/156) [#158](https://github.com/dbt-msft/dbt-sqlserver/pull/158)

fixes:

- workaround for Azure CLI token expires after one hour. Now we get new tokens for every transaction. [156](https://github.com/dbt-msft/dbt-sqlserver/issue/156) [#158](https://github.com/dbt-msft/dbt-sqlserver/pull/158)