dbt-msft / dbt-sqlserver

dbt adapter for SQL Server and Azure SQL
MIT License
212 stars 100 forks source link

Update tests.sql replace square brackets and "." between schema and view #567

Open danakee opened 3 weeks ago

danakee commented 3 weeks ago

Replace square brackets with double quotes and insert "." between schema and view in setting of testview.

Result was [dbo.testview_123] will now be "dbo"."testview_123"

cody-scott commented 3 weeks ago

Happy to merge this but you'll need to create a unit test to capture the breaking behaviour first before it can be merged.