2023_05 Bundle (Generally Enabled)

Bundle History

  1. Introduced in the 7.23 release (July 11-12) with status Disabled by Default; account admins can enable for testing.

  2. Status changed in 7.29 release (August 22-23) to Enabled by Default; account admins can disable for opt-out.

  3. Status changed in 7.34 release (September 27-28) to Generally Enabled; account admins can no longer enable or disable the bundle.

List of Changes

Important

This change list has been compiled using reasonable efforts. We are not always able to determine the full customer impact of a behavior change beforehand. The change list may not include all changes in a release, for example, last minute or emergency changes. In addition, behavior changes that are determined to have minimal to no user impact may not be pre-announced.

If you have any questions about the changes in this bundle, please contact Snowflake Support.

Security Changes

Additional Notes

Reader Accounts: ORGADMIN Role Removed from Accounts

SQL Changes — General

Additional Notes

Database Roles: Sharing Database Roles with Future Grants Not Allowed

Materialized Views: Failed Refresh Invalidates a Materialized View

SQL Changes — Commands & Functions

Additional Notes

New Functions: ARRAY_SORT, ARRAY_MIN, and ARRAY_MAX May Conflict With Similarly Named UDFs

GET_QUERY_OPERATOR_STATS and EXPLAIN Functions and Commands: Parent Operators Represented by Arrays

SHOW PARAMETERS: Changes to Retention Time Values for Databases Created From a Share

Managed Account Commands: Changes to Output

EXTRACT_SEMANTIC_CATEGORIES Function: International Tag Values

GRANT and REVOKE Commands: Changes to the Output for a Failed Grant

SHOW TABLES Command: Event Tables Listed and New Columns Added to Output

SHOW Commands: Pagination Support

SHOW SHARES Command: Changes to Output and New OWNER_ACCOUNT Column in Output

Data Loading / Unloading Changes

Additional Notes

File Formats: Validation of Format Options

Data Governance Changes

Additional Notes

SHOW TAGS: Shared Tags Require the READ Privilege on the Tag