Alteryx Designer Desktop Discussions

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

constants are not recognized Version: 2022.1.1.25127

RashmiJ123
5 - Atom

I am trying to execute an SQL amazon redshift and trying to use constants. But i am getting the below error. 

It was working fine in previous version but after the latest upgrade the constants does not seem to work, Need help 

 

Info: Connect In-DB (1): ODBC Driver version: 03.80
Error: Connect In-DB (1): Error SQLPrepare: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 42601] ERROR: syntax error at or near "%"
LINE 3: where <column name> in %user.terrcd%
^

 

0 REPLIES 0
Labels