Trying to run “custom sql” on the redshift tables while connected to the quicksight dataset. Unfortunately, I wasn’t able to run it, I don’t know why.
The error is the same when I run custom SQL from different tables.
“Your database generated a SQL exception. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.”
The detailed one is: also the same"relation “X” does not exist.
Can anyone tell me what it’s about?