Installation of dbt-synapse in same env as dbt-sqlserver conflicts namespace and starts running SQL server models using synapse Adapter #18
Description
Due to the presence of two identical 'types' in the adapters.
On my side dbt defaults to using the synapse connection, I'm not sure why.
I suspect that this would be fixed with an updated type: SqlServerSynapse but I'd have to read and understand the code better to be sure.
Actual error:
('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'DISTRIBUTION'. (102) (SQLExecDirectW)")