Relation does not exist

Question & Answer
, ,
1

Hi everyone,

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.

The error:

“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?

thx

Noy

2

Hi @Noys,

If relation x is a column, have you tried checking to see if it works in the query editor on redshift?

Best,

Bhasi

2 Likes
3

Hi @Noys - I agreed with Bhasi, please check the sql whether it is working any client tool ( by connecting to Redshift) or quick editor in redshift page of aws management console.

Regards - Sanjeeb

1 Like