I recently upgraded to 2024.1 from 2023.1 and when I view my SQL code in Visual Query Builder, it adds "double quotes" (Teradata & Oracle) and [brackets] (SQL Server) to my code. For example,
Select DB.FIRST_NAME, DB.LAST_NAME FROM DATALAKE.TABLE DB
gets converted to
Select "DB"."FIRST_NAME", "DB"."LAST_NAME" FROM "DATALAKE"."TABLE" "DB"
1.) Is this something that was intentionally added in 2024.1 or should I consider this a new issue?
2.) If it's not intentional, does anyone know how to resolve it?
Is it affecting your running of the workflow?
I think this is an intentional behavior for cases where field names have spaces.
I think that makes sense @ntakeda
@kwhitaker if your workflow is still running as normal, I wouldn't be too concerned with this