Structural differences and limitations with Amazon Redshift

Required license: Professional or Enterprise license.

Not available on Structural Cloud.

No data science mode

Amazon Redshift is only available for data generation workspaces. You cannot use Amazon Redshift in a data science mode workspace.

Table mode limitations

Amazon Redshift workspaces cannot use the following table modes:

• Scale

• Incremental

Generator limitations

Amazon Redshift workspaces cannot use the following generators:

• AI Synthesizer

• 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.