Support dbt-sqlserver adapter?
BenjaminWang1031 opened this issue · 2 comments
Hi there, does this support dbt-sqlserver adapter?
Asking because no matter I use my own models or the examples from the repo, I always run into this error:
"[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near the keyword 'with'. (156) (SQLExecDirectW); [42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. (319); [42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near ','. (102); [42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near ','. (102);
Hi @BenjaminWang1031, currently we don't support dbt-sqlserver adapter. This doesn't mean that it won't work, but we don't have any tests for it.
If you run your test with --vars "verbose: true and paste here the output, we can take a look.
Closing due to inactivity. Happy to re-open if the issue is still happening.