Get rows using a complex query to Redshift database

I’d like to get data from a Redshift database. It appears the Redshift connection asks for a specific table and gives opportunity for a where clause. I’d like to issue a sql statement that joins 4 or 5 tables to get some data. I can provide the SQL statement. Is this possible using the redshift connection?

Found the Postgres option to make this work.

2 Likes