2023_03 Bundle (Generally Enabled)

Bundle History

  1. Introduced in the 7.13 release (Apr 20-24) with status Disabled by Default; account admins can enable for testing.
  2. Status changed in the 7.19 release (June 7-8) to Enabled by Default; however, account admins can disable for opt-out.
  3. Status changed in the 7.23 release (July 10-11) 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.

SQL Changes — GeneralAdditional Notes
Cloned Tables: Default Value for Columns Not Allowed
Search Optimization: Removing Search Optimization from a Table Requires the ADD SEARCH OPTIMIZATION Privilege
Temporary Tables: Changes to Table Creation in Schemas
SQL Changes — Commands & FunctionsAdditional Notes
RESULT_SCAN Table Function: Changes to Duplicate Column Names
SHOW DATABASES Command: New Column in Output
SHOW ORGANIZATION ACCOUNTS Command: New Columns in Output
SHOW TERSE DATABASES Command: Values Populated in the KIND Column
SQL Changes — Usage Views & Information Schema Views / Table FunctionsAdditional Notes
COPY_HISTORY View (Account Usage): “Load in progress” No Longer Shown in STATUS Column
Account Usage: Changes to Columns in DATABASES View
Account Usage: New Column in DATABASES View
Information Schema: New Column in DATABASES View
GRANT_TO_ROLES View (Account Usage): Privileges Added to View
PIPES View (Account Usage): New Column in View (Pending)This change has been removed.
SESSIONS and LOGIN_HISTORY Views (Account Usage): Events from Internal Users Removed from Views
SESSIONS View (Account Usage): New Column in View
TASK_HISTORY Table Function (Information Schema): Consistent Values for Failed and Auto-suspended Tasks in ERROR_ONLY Output
Data Loading / Unloading ChangesAdditional Notes
Parquet Files: Statistics Included for Decimal Columns Unloaded as FixedLengthByteArrays
Replication ChangesAdditional Notes
Roles and Privileges: Changes to Secondary Roles and the REPLICATE Privilege
Stream and Task Replication: Changes for GA
Developer / Extensibility ChangesAdditional Notes
Stored Procedures and UDTFs: Argument Names Respected in Calls
Stored Procedures: Calls to BUILD_SCOPED_FILE_URL Function Allowed Within Owner’s Rights Procedures
UDFs: Functions with Handler Code That Reads Files from a Stage Execute in the Owner’s Context
Web Interface ChangesAdditional Notes
Query Profile: Changes to the Update, Delete, and Insert Operators
Snowsight: Roles Removed from Worksheet Folders