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.

Defect GDC-2539 Error: "Incorrect syntax near the keyword 'column'."

londonhanson
Alteryx
Alteryx
Created

Error: “[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'column'.”

 

Environment Details

A column with spatial data and spaces in the column name throws a "Incorrect syntax" error when reading from or writing to SQL Server.

Error when using ODBC:

Input Data (1) Error opening "select "NT_COStoreFileNorth".[new column], "NT_COStoreFileNorth".[polygon column] FROM (SELECT "new column","polygon column".STAsBinary() AS polygon column FROM NT_COStoreFileNorth) "NT_COStoreFileNorth"": No Columns Returned.



Error when using OleDB (with SQL Server Native Client driver):

When using OLEDB (with driver SQL Server Native Client) you get error: 
Input Data (3) Error: Microsoft SQL Server Native Client 11.0: Incorrect syntax near the keyword 'column'.\42000 = 156¶ in Query: select NT_COStoreFileNorth.[new column],¶ NT_COStoreFileNorth.[polygon column] ¶from NT_COStoreFileNorth
 
  • Alteryx Designer
    • Versions: 2022.1, 2021.4, 2020.4
  • SQL Server
  • SQL Server Driver
    • Versions: 11, 13, or 17
  • SQL Server OleDB driver Native Client 11 Driver
  • Spatial Data


image.pngimage.png

Cause

 

This error is caused by the spatial data and the inclusion of spaces in the column name. Other data types do not have the same issue with spaces in the column name.



Resolution


Defect GDC-2539 has been created for this issue and will be addressed in a future release of Designer.
 

Workaround


Rename the SpatialObj column and remove the spaces.

Additional Resources

No ratings
Comments
LisaL
Alteryx
Alteryx

Probably more relevant is that there is a space in an un-quoted field name and part of that name is a reserved word.