Structural differences and limitations with Snowflake

Required license: Professional or Enterprise

Table mode limitations

Snowflake workspaces cannot use the following table modes:

• Incremental

Generator limitations

Snowflake 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 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 workspaces do not support upsert.

No output to a container repository

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