- Schema:
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 Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_LOCATOR | VARCHAR | System-generated identifier for the account. |
| ACCOUNT_NAME | VARCHAR | User-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 Name | Data Type | Description |
|---|---|---|
| REGION_GROUP | VARCHAR | Region group where the data refresh occurred. |
| SNOWFLAKE_REGION | VARCHAR | Snowflake region where the data refresh occurred. |
| USAGE_DATE | DATE | Date in UTC when the refresh was performed. |
| FULFILLMENT_GROUP_NAME | VARCHAR | Identifier for the auto-fulfillment group used to refresh the data. |
| BYTES_TRANSFERRED | NUMBER | Number of bytes transferred for refreshes in this day. |
| CREDITS_USED | NUMBER | Number of credits used for refreshes in this day. |
| DATABASES | ARRAY | List of databases refreshed in the auto-fulfillment group. Returns an empty array until a listing is successfully fulfilled to a region. |
| LISTINGS | ARRAY | List 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:
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: