I encounter this on occasion when using custom SQL, at which point I’m unable to debug and have to redesign my entire script:
What is the underlying issue in plain English that I can actually debug? I don’t have access to the underlying RDS instance since it’s embedded Quicksight.
The first time this occurred, I had several CTEs with aliases on the final final query such as:
SELECT
colname AS "Column Name"
...
By removing the alias it worked. In other instances, once the error occurred I got around it by simply copying and pasting the entire script as is into a new dataset custom SQL and it worked, but no matter what once the original dataset showed the error it would never work again.
Thank you for letting us know. I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case (Creating support cases and case management - AWS Support). If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!