Preview — 8.47 Release Notes¶

Attention

Content in this page is available in advance of the completion of the 8.47 release, which is currently either pending or in progress.

The release is scheduled to complete on December 17 (subject to change).

Features, updates, or behavior changes described in this page might not become available in your account(s) until the completion of the release.

For updates to 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.

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.

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