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:

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

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