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:
Scale
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 subsetting, but support for table filtering
Amazon Redshift workspaces do not support subsetting.
However, for tables that use the De-Identify table mode, you can provide a WHERE clause to filter the table. For details, go to Using table filtering for data warehouses and Spark-based data connectors.
No upsert
Amazon Redshift workspaces do not support upsert.
No output to container artifacts
For Amazon Redshift workspaces, you cannot write the destination data to container artifacts.
No output to an Ephemeral snapshot
For Amazon Redshift workspaces, you cannot write the destination data to an Ephemeral snapshot.
Last updated