2023_01 Bundle (Generally Enabled)

Bundle History

  1. Introduced in the 7.2 release (Jan 19-20) with status Disabled by Default.
  2. Status changed in the 7.7 release (Mar 6-7) to Enabled by Default.
  3. Status changed in the 7.13 release (Apr 20-24) 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 ChangesAdditional Notes
SHOW INTEGRATIONS Command: USAGE Privilege Required to View Output
System Functions: MONITOR SECURITY Privilege Required to Execute Certain System Functions
Query History: Redacted SQL Upon Syntax Error
SQL Changes — GeneralAdditional Notes
Materialized Views: Using Time Travel to Query Historical Data Produces Expected Error Message
SQL Changes — Commands & FunctionsAdditional Notes
SHOW Commands: New Column Added to Output for Certain Commands
SHOW ORGANIZATION ACCOUNTS Command: New Column in Output
ARRAY_CAT Function: Changes to NULL Handling
ARRAY_POSITION Function: Changes to Finding the Position of a NULL Value
GET_DDL Function: Tags Set on Streams, Tasks, and Pipes Included in Output
SQL Changes — Usage Views & Information Schema Views / Table FunctionsAdditional Notes
Account Usage: New and Changed Columns in Certain Views
QUERY_HISTORY View (Account Usage): New Columns Added
REPLICATION_DATABASES View (Information Schema): Changes to Column Values
TABLES View (Account Usage): Changes to the RETENTION_TIME Column
TABLES, VIEWS, and EXTERNAL_TABLES Views (Account Usage, Information Schema): New Columns Added
TASK_HISTORY View (Account Usage): Change to Status for Failed and Auto-suspended Tasks
Snowflake CLI, Connectors, Drivers, and SQL API ChangesAdditional Notes
Some Unused Data No Longer Sent to Drivers, Connectors, and Clients
Data Pipeline ChangesAdditional Notes
Streams: CREATE STREAM with INSERT_ONLY = TRUE Not Allowed on Non-external Tables
Temporary Tables: Changes to Table Creation in Schemas (Pending)
Streams: Joins on Views for Append-only Streams No Longer Produce Unexpected Results
Task Parameters Preserved When Cloning Tasks
Task Parameters Preserved When Cloning Databases, Schemas, and Tables
Data Governance ChangesAdditional Notes
Tag Must Exist When Calling System Functions
Query History: Redacted SQL Upon Syntax Error
Replication ChangesAdditional Notes
Failover Groups: Change to GRANTED_ON Column in SHOW GRANTS Output
Integrations: Read-only Secondary Integrations Enforced