Unable to View Tables in Redshift Database - "Relation Does Not Exist" Error

[spyrosRb]

Hi,
Iam using the SQLTools via the VSCode to connect to a Redshift database. Although the connection is successful and I can see the database and all of its underlying schemas, I cannot expand the schema to view the tables.
Instead, I receive the following error message:

Request connection/GetChildrenForTreeItemRequest failed with message: relation does not exist

Despite this, I can execute queries on the database without any issues. I tried the suggestion to run the following query:

SELECT * FROM INFORMATION_SCHEMA.TABLES;

However, this returns an empty table. When I execute the same command in DBeaver, it works properly and returns the expected results.
I have seen that this is a known issue could you please advise on how to resolve this? Let me know if you need additional information to help troubleshoot.