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 structure
here is what I see in Alteryx
Alteryx View
Since the connection is successful, I am not sure what I need to change to have the tables come through
here is the structure of the Redshift database when viewing it in DBeaver
Redshift Table/db structure
here is what I see in Alteryx
Alteryx View
Since the connection is successful, I am not sure what I need to change to have the tables come through