Structural differences and limitations with Snowflake on AWS

Table mode limitations

Snowflake on AWS workspaces cannot use the following table modes:

• Scale

• Incremental

Generator limitations

Snowflake on AWS 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

Support for table filtering

Snowflake on AWS workspaces support both subsetting and table filtering.

Table filtering means that 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

Snowflake on AWS workspaces do not support upsert.

No output to container artifacts

For Snowflake on AWS workspaces, you cannot write the destination data to container artifacts.

No output to an Ephemeral snapshot

For Snowflake on AWS workspaces, you cannot write the destination data to an Ephemeral snapshot.