Snowflake Release Notes

Dynamic Apache Iceberg™ tables now support the following table properties:

• PARTITION BY: Partition the table using Iceberg partition expressions such as identity, bucket, truncate, year, month, day, and hour transforms.
• TARGET_FILE_SIZE: Control the target Parquet file size for table writes. Defaults to AUTO, which lets Snowflake choose the optimal file size.
• PATH_LAYOUT: Choose between a flat or hierarchical (Hive-style) directory layout for data files. Use HIERARCHICAL together with PARTITION BY to write data to partition-aware paths.

Clean Rooms API Version: 14.3

The following new features and enhancements are now available in Snowflake Data Clean Rooms:

• Collaboration API - Generally Available: The new Collaboration API is now generally available. The new architecture supports fully symmetric, multi-party collaboration with flexible roles and fine-grained data access controls for any number of participants. Read the overview and try out building a new collaboration yourself.
• Collaboration Configuration APIs: Two new stored procedures are now available for managing collaboration configuration flags:
  • GET_CONFIGURATION returns a table of configuration key-value pairs for the collaboration. Currently exposes the TEMPLATE_AUTO_APPROVAL setting per collaborator.
  • SET_CONFIGURATION sets a configuration value for the collaboration.
• Case-Insensitive Code Spec IDs: Code spec IDs are now case-insensitive, extending the case-insensitive identifier support introduced in the previous release. You no longer need to match the exact casing used during registration when referencing a code spec by ID.

With this release, error logging for Snowpipe Streaming with high-performance architecture is now generally available. When error logging is turned on for a target table, rows that fail server-side processing are automatically captured in a dedicated error table instead of being silently dropped. This feature includes the following capabilities:

• Row-level error capture with full original payloads and detailed error metadata.
• Filtering by Snowpipe Streaming errors using the error_metadata:service field.
• Querying, analyzing, and reprocessing failed rows using standard SQL.

New features and updates

• Added the browserRedirectPort connection option to customize the port of the local server that receives the EXTERNALBROWSER authentication callback.
• Bumped @aws-sdk/* dependencies to address a fast-xml-parser vulnerability.
• ...

Bug fixes

• Fixed connection pools re-prompting browser authentication for every pooled connection when using EXTERNALBROWSER or OAUTH_AUTHORIZATION_CODE authenticators. The first connection now completes auth and caches tokens before subsequent pool connections start.
• Fixed session token renewal failing due to a malformed request, which caused long-running connections to disconnect instead of refreshing their expired session token.
• ...

With this release, native semantic classifiers for medical and health-related data in sensitive data classification are generally available. Snowflake adds the MEDICAL_DATA and MEDICAL_SPECIALTY semantic categories and related subcategories so that personal health information aligned with the Health Insurance Portability and Accountability Act (HIPAA) can be detected and tagged consistently.

The new classifiers cover, for example:

• ICD (International Classification of Diseases) codes
• Laboratory and blood-test terminology
• Medical conditions and impairments