Hello,
I recently added new schemas and tables in my redshift. i have given all the access to those tables and schema. However, i am not able to see those schemas and tables.
The main catch is I can run the sql queries on those schemas and tables.
I tried refreshing the database and syncing the data which didnt help.
Please help to resolve this issue.