Schema:

ORGANIZATION_USAGE

For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).

LISTING_AUTO_FULFILLMENT_REFRESH_DAILY view

Important

This view is only available in the organization account. For more information, see Premium views in the organization account.

Organization Usage performance

When you query a specific view in the SNOWFLAKE.ORGANIZATION_USAGE schema, follow the organization-wide guidance in Performance (Organization Usage): bound every scan on history views, list columns explicitly, and use the time filter column table plus worked SQL and anti-patterns there.

This Organization Usage view can be used to determine the data refreshes performed by Cross-Cloud Auto-Fulfillment for the listings owned by the accounts in your organization. When a listing is fulfilled to another region, the data product is refreshed on a frequency defined by the listing provider. This view contains details about how much data is refreshed to specific regions, and which listings and databases the data refreshes are associated with.

This view is the organization-wide counterpart of the LISTING_AUTO_FULFILLMENT_REFRESH_DAILY view in the DATA_SHARING_USAGE schema, which returns the rows for a single provider account. The columns, other than the common organization columns, and the usage notes are the same.

You can use this view to help manage the costs associated with Cross-Cloud Auto-Fulfillment. See Auto-fulfillment costs.

This view is available only in the organization account. Users with the GLOBALORGADMIN role, or users granted the SNOWFLAKE.ORGANIZATION_SECURITY_VIEWER application role, can access it. For details, see Accessing the ORGANIZATION_USAGE schema.

Columns

Organization-level columns

Column NameData TypeDescription
ORGANIZATION_NAMEVARCHARName of the organization.
ACCOUNT_LOCATORVARCHARSystem-generated identifier for the account.
ACCOUNT_NAMEVARCHARUser-defined identifier for the account.

The ORGANIZATION_NAME, ACCOUNT_LOCATOR, and ACCOUNT_NAME columns identify the provider account that owns the listings.

Additional columns

Column NameData TypeDescription
REGION_GROUPVARCHARRegion group where the data refresh occurred.
SNOWFLAKE_REGIONVARCHARSnowflake region where the data refresh occurred.
USAGE_DATEDATEDate in UTC when the refresh was performed.
FULFILLMENT_GROUP_NAMEVARCHARIdentifier for the auto-fulfillment group used to refresh the data.
BYTES_TRANSFERREDNUMBERNumber of bytes transferred for refreshes in this day.
CREDITS_USEDNUMBERNumber of credits used for refreshes in this day.
DATABASESARRAYList of databases refreshed in the auto-fulfillment group. Returns an empty array until a listing is successfully fulfilled to a region.
LISTINGSARRAYList of listings that reference the databases in this region. Returns an empty array until a listing is successfully fulfilled to a region.

Usage notes

  • Latency for the view may be up to 2 days.
  • The data is retained for 1 year.
  • The view only contains data from 2023-04-16 onward.
  • In cases where auto-fulfillment is incomplete, the array returned for the LISTINGS column might be empty.
  • The view contains data for all data products, whether your data product is a Snowflake Native App or a share.

Important

This view is intended to help you understand the resources used by Cross-Cloud Auto-Fulfillment. It is not intended to be used for billing reconciliation. Instead, use the LISTING_AUTO_FULFILLMENT_USAGE_HISTORY view.

Examples

Credits used by provider account

To show the credits used in the last 30 days to refresh data, broken down by provider account, run the following statement:

select
  account_name,
  sum(credits_used) as total_credits_used,
  sum(bytes_transferred) as total_bytes_transferred
from SNOWFLAKE.ORGANIZATION_USAGE.LISTING_AUTO_FULFILLMENT_REFRESH_DAILY
where usage_date >= dateadd('day', -30, current_date())
group by account_name
order by total_credits_used desc;

Credits used by auto-fulfillment group

To show the credits used in the last 30 days to refresh the data associated with each auto-fulfillment group, including the associated databases and listings, run the following statement:

select
  account_name,
  fulfillment_group_name,
  databases,
  listings,
  sum(credits_used) as total_credits_used
from SNOWFLAKE.ORGANIZATION_USAGE.LISTING_AUTO_FULFILLMENT_REFRESH_DAILY
where usage_date >= dateadd('day', -30, current_date())
group by 1,2,3,4
order by total_credits_used desc;