Structural differences and limitations with Amazon Redshift

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.