Feb 02, 2026: Support for listing and share observability (General availability)

Enhanced observability for listings and shares through new Information Schema views, table functions, and Account Usage views is now generally available.

New views and functions in the INFORMATION_SCHEMA schema

The following Information Schema views and table functions are now available:

INFORMATION_SCHEMA.LISTINGS view (for providers)

The LISTINGS view displays all listings for which the current role has been granted access privileges. This view provides real-time information with no data latency. It doesn’t capture deleted objects.

Usage example:

SELECT * FROM <database_name>.INFORMATION_SCHEMA.LISTINGS;
Copy

For the complete list of columns, see LISTINGS view.

INFORMATION_SCHEMA.SHARES view (for providers and consumers)

The SHARES view lists all shares available in the system, consistent with the output of the SHOW SHARES command. This includes:

  • Outbound shares (to consumers) that have been created in your account as a provider

  • Inbound shares (from providers) that are available for your account to consume

Usage example:

SELECT * FROM <database_name>.INFORMATION_SCHEMA.SHARES;
Copy

For more information, see SHARES view.

INFORMATION_SCHEMA.AVAILABLE_LISTINGS table function (for consumers)

The AVAILABLE_LISTINGS table function in the Information Schema returns all listings that are available for the consumer to discover or access. The function supports optional filters for imported listings, organization listings, and directly shared listings.

Usage example:

SELECT * FROM TABLE(<database_name>.INFORMATION_SCHEMA.AVAILABLE_LISTINGS());

-- Filter for imported listings only
SELECT * FROM TABLE(<database_name>.INFORMATION_SCHEMA.AVAILABLE_LISTINGS(IS_IMPORTED => TRUE));
Copy

For more information, see AVAILABLE_LISTINGS.

New and updated views in the ACCOUNT_USAGE schema

The following Account Usage views are now available for historical analysis with up to three hours of data latency:

ACCOUNT_USAGE.LISTINGS view (for providers)

This view displays a row for each listing in the provider account, including listings that have been dropped within the last year.

For more information, see LISTINGS view.

ACCOUNT_USAGE.SHARES view (for providers)

This view displays a row for each share in the provider account, including shares that have been dropped within the last year.

For more information, see SHARES view.

ACCOUNT_USAGE.GRANTS_TO_SHARES view (for providers)

This view can be used to query access control privileges that have been granted to a share, including historical grant and revoke operations.

For more information, see GRANTS_TO_SHARES view.

Updates to ACCOUNT_USAGE.ACCESS_HISTORY view

The ACCESS_HISTORY view now captures the following DDL operations on listings and shares:

  • CREATE, ALTER, and DROP operations on listings.

  • CREATE, ALTER, and DROP operations on shares.

  • Detailed property changes in the OBJECT_MODIFIED_BY_DDL JSON column.

These additions enable comprehensive auditing of listing lifecycle and share lifecycle events.

For more information, see ACCESS_HISTORY view in the ACCOUNT_USAGE schema and ACCESS_HISTORY view in the ORGANIZATION_USAGE schema.

Language: English