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.
Hi, where do you experience this error? during analysis/visual creation time or during data prep edit or during calculated field creation time?
I am also facing the same issue during data prep ‘Edit Dataset’ stage.
During the data prep edit.
The first time this occurred, I had several CTEs with aliases on the final final query such as:
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.