Structural differences and limitations with Snowflake on AWS
Required license: Professional or Enterprise
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:
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.
Last updated