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