December 16-18, 2024 — 8.47 Release Notes¶

Attention

The release has completed. For differences between the in-advance and final versions of these release notes, see Release notes change log.

SQL updates¶

New SQL functions¶

The following function(s) are now available with this release:

Function category	New function	Description
Table	ICEBERG_TABLE_FILES	Information schema table function that returns information about the data files registered to an externally managed Apache Iceberg™ table. You can also view information about files associated with historical snapshots.
Table	ICEBERG_TABLE_SNAPSHOT_REFRESH_HISTORY	Information schema table function that returns metadata and snapshot information about the most recent refresh history for a specified externally managed Apache Iceberg™ table.

Extensibility updates¶

Support for a wildcard character in network rule network identifiers —– Preview¶

With this release, you can use an asterisk as a wildcard character when specifying a network identifier for a network rule in its VALUE_LIST parameter.

For more information, see CREATE NETWORK RULE.

Data pipeline updates¶

Dynamic tables: Maximum number of dynamic tables in an account increased to 10,000¶

With this release, your account can now hold a maximum of 10,000 dynamic tables. Previously, the limit was 4,000 dynamic tables in a single account.

For more information, see General limitations.

Data governance updates¶

OBJECT_DEPENDENCIES view: Support for dynamic tables¶

With this release, we are pleased to announce that the OBJECT_DEPENDENCIES view in the ACCOUNT_USAGE schema now includes dependencies involving dynamic tables. The dynamic table can be the referencing object or the referenced object.

For more information, see OBJECT_DEPENDENCIES view.

Release notes change log¶

Announcement	Update	Date
Release notes	Initial publication (preview)	13-Dec-24
OBJECT_DEPENDENCIES view: Support for dynamic tables	Added to Data governance section	17-Dec-24