AWS Redshift is based on PostgreSQL 8.0, where AWS added powerful scaling and made it available in the cloud. Transformations run on your own dedicated cluster in Keboola Connection.
To create a simple Redshift transformation, follow these steps:
You can organize the script into blocks.
Redshift in Keboola Connection does not support functions or stored procedures.
There are basic constraints set to keep your Redshift cluster healthy. By upgrading your Redshift cluster to a larger size, these limits can be increased.
Quoting: Use double quotes (
") to encapsulate table and column names.
Case sensitivity: Redshift is case insensitive and stores all column and table names in lower case. However, Storage is case sensitive (be careful when migrating transformations to Redshift, letter case could cause problems in the output mapping).