There are only 4 modules available that allow for very, very basic data operations in Redshift. They do not allow for more advanced queries, limiting customization options to only select and where clause 
I currently use many connectors for different types of databases in make.com, and it’s the first time I’ve encountered such a minimally functional connector from your side.
Ex. Zapier offers as many as 7 different methods for Amazon Redshift, including full customization at the SQL query level. It would be beneficial to improve this, as the connector in its current form is completely non-functional.
Unless someone knows an alternative way to bypass this controversial connector supported by Make 
https://www.make.com/en/integrations/aws-redshift
