Amazon Redshift: Advanced SQL
Chris Pellett
Be able to run any SQL we would like in Redshift. Stored procedure, copy statement, etc. Without it, we can't leverage a proper data loading infrastructure.
Log In
Canny AI
Merged in a post:
Amazon Redshift: Allowing custom queries without an imposed & limited clauses structure
Lukasz Kidon
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.