2 Answers
- Newest
- Most votes
- Most comments
0
Ok, this is a self-answer. Apparently, Row Filter Expression failed due to use of double-quoted string , instead of single quoted.
Replacing confidential1="US"
with confidential1='US'
solved the problem.
Unfortunately, error message is not helpful and have to be replaced with a better explanation of the problem.
answered a year ago
0
HI, as you have correctly pointed out, the error is due to in SQL syntax strings in double quotes "" are treated as column names. Use single quotes should resolve this issue. Please feel free to response or open a support ticket if you have any follow up questions. We are happy to help you out!
answered a year ago
Relevant content
- asked 2 years ago
- Accepted Answerasked 5 months ago
- asked 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 2 years ago
It's true that it's not obvious but if you see the description, it says that you are writing a SQL condition. In SQL '' is a string and "" is the way you escape a column name