9.21 Release notes: Preview¶

GENERATE_SYNTHETIC_DATA: Consistency secret now optional in most cases¶

Previously, when you called GENERATE_SYNTHETIC_DATA with a replace column property, you needed to provide a SECRET for consistency_secret. With this change, consistency_secret is now optional. However, if you run GENERATE_SYNTHETIC_DATA in an owner’s rights stored procedure, you still must provide a value to consistency_secret.

Account Usage: TABLE_QUERY_PRUNING_HISTORY and COLUMN_QUERY_PRUNING_HISTORY views (General availability)¶

You can monitor data access patterns at the table and column level by querying two new Account Usage views:

• TABLE_QUERY_PRUNING_HISTORY provides a breakdown of query execution time and pruning by table, query-hash, and warehouse.

• COLUMN_QUERY_PRUNING_HISTORY returns an equivalent pruning summary that is aggregated by column name.

The SEARCH_IP function supports searching for IPv6 addresses¶

You can use the SEARCH_IP function to search for IPv6 addresses in data. Previously, the function only supported searching for IPv4 addresses.

Snowpark Connect for Spark and Snowpark Submit (Preview)¶

With Snowpark Connect for Spark, you can run Spark DataFrame, SQL, and UDF APIs directly on the Snowflake platform using the same Spark code you use today. You can develop using client tools such as Snowflake Notebooks, Jupyter Notebooks, and others. With Snowpark Submit, you can run Spark workloads in a non-interactive, asynchronous way directly on Snowflake’s infrastructure while you use familiar Spark semantics.