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.

Last updated