Added sqlserver compatibility including CI
this PR relatest to https://github.com/brooklyn-data/dbt_artifacts/issues/194
Backlog: ~~Making sure the adapter you're supporting implements the type helpers used in the source models.~~ ~~Adding overwrites for the custom type helpers if required~~ ~~If required, creating adapter-specific version of the upload_* macros.~~ ~~Adding SQLServer CI support~~
I do not have access to a snowflake, databricks or bigquery server so relying on the CI tests to confirm all is working.
I've reviewed the linting errors and I can't figure out why the code is failing for most of the exceptions. For example, there's nothing obviously wrong with the two items in the attached pic. Any help would be appreciated.

I've reviewed the linting errors and I can't figure out why the code is failing for most of the exceptions. For example, there's nothing obviously wrong with the two items in the attached pic. Any help would be appreciated.
@NiallRees hoping you can provide some assistance - I'm at a loss trying to figure out why most of the linting failed.
I've reviewed the linting errors and I can't figure out why the code is failing for most of the exceptions. For example, there's nothing obviously wrong with the two items in the attached pic. Any help would be appreciated.
@NiallRees hoping you can provide some assistance - I'm at a loss trying to figure out why most of the linting failed.
Hi @jgilfillan - don't worry about those. I'll try and review the PR this week!
@NiallRees is there anything else you're waiting on from me to accept this pr?
Hi @jgilfillan thank you for contributing with this, and I'm really sorry that our response has been delayed. We are going to work through the issue backlog now, and get to reviewing this again as soon as possible.
Hi @jgilfillan thank you for contributing with this, and I'm really sorry that our response has been delayed. We are going to work through the issue backlog now, and get to reviewing this again as soon as possible.
Any progress on approving this PR?
Hi @jgilfillan thank you for contributing with this, and I'm really sorry that our response has been delayed. We are going to work through the issue backlog now, and get to reviewing this again as soon as possible.
@glsdown It would be good to get an indication if there are any plans to merge this code. The SQL Server compatibility was added on the advice from this project that it would be accepted. So if this has changed it would be good to communicate this so alternative plans can be made (for SQL Server, Synapse, Fabric).
@glsdown can you please give us an update on this one?