We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Visual Query Builder is adding "double quotes" and [brackets] to my SQL code

kwhitaker
6 - Meteoroid

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?

 

SQL_before_after.jpg

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

Is it affecting your running of the workflow?

ntakeda
12 - Quasar

I think this is an intentional behavior for cases where field names have spaces.

alexnajm
18 - Pollux
18 - Pollux

I think that makes sense @ntakeda 

 

@kwhitaker if your workflow is still running as normal, I wouldn't be too concerned with this

Labels
Top Solution Authors