Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

DE28719: In-DB tools "Quoted" and "None" options for Table/FieldName SQL Style do not work

Loredana
Alteryx Alumni (Retired)
Created

Environment Details


  • Alteryx Designer
    • 2020.4-2021.1
  • In-DB Tools
​​​​​​​
When using In-DB tools for connecting to a data source and for creating columns or tables the quoted or not quoted options do not work. The new columns and tables are created with case sensitivity enabled no matter what is chosen in "Table/FieldName SQL Style".





Cause


This behavior is related to a product defect, DE28719. This defect was fixed in 2021.2.



Resolution


No workaround is available. We recommend using the standard tools to create columns and tables without the names being case sensitive.

No ratings