AWS Redshift is based on PostgreSQL 8.0 where AWS added powerful scaling and made it available in cloud. Transformations run on your own dedicated cluster in Keboola Connection.
Redshift in KBC does not support functions or stored procedures.
If you want to migrate a transformation from MySQL to Redshift, use this hint sheet.
There are basic constrains 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).
COPY Options – The default COPY command looks like this:
If you do not specify any COPY options in the input mapping,
NULL AS 'NULL' ACCEPTANYDATE TRUNCATECOLUMNS will
be used as default. Specifying the COPY options will overwrite the defaults.