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


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


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)