We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎07-28-2022 04:17 AM

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%
^

 

Labels:
Reply
0 Likes
0 REPLIES 0
Live Office Hours
Labels
Top Solution Authors
View All