2023_06 Bundle (Disabled by Default)

Bundle History

  1. Introduced in the 7.29 release (August 22-23) with status Disabled by Default; account admins can enable for testing.

  2. Status planned to change in September to Enabled by Default; however, this schedule is subject to change.

  3. Status planned to change in October to Generally Enabled; however, this schedule is subject to change.

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

WRITE/USAGE stage privileges: Directory table refreshes allowed (Pending)

SQL Changes — General

Additional Notes

Cloning: Alerts cloned when cloning databases or schemas (Pending)

Sequences and columns: Changes to SHOW command, view, and GET_DDL function output (Pending)

Query History: Queries for alert conditions and actions included in history (Pending)

SQL Changes — Commands & Functions

Additional Notes

SHOW USERS command: Output filtered based on privileges granted to active role (Pending)

SHOW STAGES command: New columns (Pending)

SYSTEM$GET_PRIVATELINK_CONFIG function: OCSP account identifier URL added to output (Pending)

DYNAMIC_TABLE_REFRESH_HISTORY function: DATA_TIMESTAMP value in output displayed in new format (Pending)

New function: ARRAY_FLATTEN may conflict with similarly named UDFs (Pending)

CREATE ALERT and ALTER ALERT commands: Some validation checks no longer performed on individual statements in conditions and actions (Pending)

SHOW commands: New column (Pending)

SQL Changes — Usage Views & Information Schema Views / Table Functions

Additional Notes

Query and Task History views and functions: New columns (Pending)

ALERT_HISTORY view and function (Account Usage and Information Schema): Changes to output when action contains RETURN statement (Pending)

ROLES view (Account Usage): New columns and new value for ROLE_TYPE column (Pending)

GRANTS_TO_ROLES View: New Column in the Output and New Values for Existing Columns (Pending)

TABLES view (Account Usage and Information Schema): New column and column values (Pending)

Task views and functions (Account Usage and Information Schema): New column (Pending)

Task views and functions (Account Usage and Information Schema): ATTEMPT_NUMBER value changed to 1-based (Pending)

METERING_HISTORY view (Account Usage): New column (Pending)

Data Loading / Unloading Changes

Additional Notes

Snowpipe: Modification of auto-ingest notification integration queue for Azure and GCP not allowed (Pending)

PUT command on GCP: OVERWRITE parameter must be set to TRUE to overwrite files (Pending)

Data Pipelines Changes

Additional Notes

Dynamic tables: TARGET_LAG parameter set to less than 1 minute for new or modified tables results in error (Pending)

Tasks: Graph completion time differs from final task (Pending)

Data Sharing Changes

Additional Notes

GRANT OWNERSHIP command: Ownership transfer not allowed for shared databases (Pending)

Database roles: Updated error messages when granting to a share (Pending)

Reader accounts: DROP ACCOUNT command not supported (Pending)

Data Governance Changes

Additional Notes

SEMANTIC_CATEGORY system tag: Allowed values constraint removed (Pending)

Replication Changes

Additional Notes

BLOCK_NON_READLIST_OPERATIONS_ON_STAGES_IN_SECONDARY: Parameter set to TRUE by default (Pending)

Developer and Extensibility Changes

Additional Notes

TABLES views (Account Usage and Information Schema): TABLE_TYPE column value shows correct value for event tables (Pending)

Native Apps: GET_DDL error message updated on APPLICATION PACKAGE (Pending)

Procedures (caller’s rights): SQL statements that include PUT and GET commands produce a compiler error (Pending)

Native Apps: Different privileges required to rename APPLICATION and APPLICATION PACKAGE (Pending)

UDTFs: Default column names updated for Python vectorized UDTFs (Pending)