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 a container repository

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

No output to an Ephemeral snapshot

For Amazon Redshift workspaces, you cannot write the destination data to an Ephemeral snapshot.