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 a container repository

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

No output to an Ephemeral snapshot

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

Last updated