Structural differences and limitations with Amazon Redshift

Required license: Professional or Enterprise license.

Not available on Structural Cloud.

Table mode limitations

Amazon Redshift workspaces cannot use the following table modes:

• Incremental

Generator limitations

Amazon Redshift workspaces cannot use the following generators:

• Algebraic

• Array JSON Mask

• Array Regex Mask

• Cross Table Sum

• Current Date

• Event Timestamps

• Geo

• Sequential Integer

No upsert

Amazon Redshift workspaces do not support upsert.

No output to a container repository

For Amazon Redshift workspaces, you cannot write the destination data to a container repository.