You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The dbt compilation result: SELECT * FROM "101_supplier"."core"."supplier"
What I expected: SELECT * FROM [101_supplier].[core].[supplier]
Question:
Is there a way to configure the quoting for database, schema and identifier with square brackets. Or this issue a topic for the dbt core team?
Additional context
I found a core issue with similar problems: link
The text was updated successfully, but these errors were encountered:
The double quotes work fine in MS SQL. Did you try running the query? It works fine with tables that start with numbers. I don't have servers named like that to try.
The quoting for msft sql not working. Dbt use double quotes when the config quoting is turned on but ms sql or tsql use square brackets.
I need quoting for databases and table. Our table or database prefix is sometimes a number like
101_Customers
.Example:
dbt config:
The dbt compilation result:
SELECT * FROM "101_supplier"."core"."supplier"
What I expected:
SELECT * FROM [101_supplier].[core].[supplier]
Question:
Is there a way to configure the quoting for database, schema and identifier with square brackets. Or this issue a topic for the dbt core team?
Additional context
I found a core issue with similar problems: link
The text was updated successfully, but these errors were encountered: