I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection when testing it out. Yet, when I use this connection manager as my input source, while it connects, it does not show me the tables.

here is the structure of the Redshift database when viewing it in DBeaver

Redshift Table/db...