When creating datasets with Custom SQL options, if the tables contains columns with names as “status”, “message”, “expire_date” then there is issue with data and not all rows gets imported. Issue with Data Integrity? What is the solution for it?
SELECT `expiry_date`, `message` , `state`,`status` FROM `table_name`
Have you tested the same query outside of QuickSight? do you get the result? is it that only in QuickSight, are you not getting the data for those columns? can you also please share what is the data source type that you use?
Highlighting syntax in blue is mostly for reserve keywords in sql language. Not sure why columns are getting highlighted.
Hi @basil-ygag. Has this been resolved? If so, please help the community by marking the appropriate post as “Solution”. If you still need assistance, please provide additional detail. Thanks!