Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] (-3706) Syntax error: expected something between

ntobon
Alteryx
Alteryx
Created

Issue

 

When connecting to Teradata Database via ODBC to pull data into the Input Data tool Syntax errors like the followings occur:

Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] (-3706) Syntax error: expected something between an integer and the integer '7'.
Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] syntax error: expected something between the word 'field1,storehierarchy' and '.'.

image.png

image.png
 

Environment Details

  • Alteryx Designer
    • All Versions.
  • ODBC Teradata Driver


Cause

 

There was a 'LinenBreak' /‘Line Feed’ on the query.



Diagnosis

 

The query runs fine outside Designer. 

 

Resolution

 

Copy the query into Notepad++. Remove all line breaks and extra spaces from the query and make sure there is a space after the words Select, From, Where, Case, When, Then, Else, Like, And, End, As, etc. Then paste the SQL query in the SQL Editor tab.





 

No ratings