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

Subsetting enabled for Data Pipeline V2 only

For Amazon Redshift workspaces, subsetting is only supported for the Data Pipeline V2 data generation process.

If you choose the previous data generation process, then Structural ignores the subsetting configuration.

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.