Schema:

ORGANIZATION_USAGE

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

ORGANIZATION_USAGE_STORAGE_HISTORY view

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.

The ORGANIZATION_USAGE_STORAGE_HISTORY view in the ORGANIZATION_USAGE schema provides Organization Usage storage cost visibility across accounts in your organization. You can use it to query the daily storage usage, in bytes, for each account within the last 12 months. Each row represents the storage attributed to a single account on a given date.

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

Columns

Column NameData TypeDescription
ORGANIZATION_NAMEVARCHARName of the organization in which the usage took place.
ACCOUNT_NAMEVARCHARName of the account where the usage took place.
ACCOUNT_LOCATORVARCHARName of the account locator.
REGIONVARCHARName of the region where the account is located.
USAGE_DATEDATEDate (in the UTC time zone) when the storage usage occurred.
BYTESNUMBERNumber of bytes used on the given date.

Usage notes

  • Latency for the view may be up to 24 hours (1 day).
  • The data is retained for 365 days (1 year).
  • This view reports Organization Usage storage attributed to each account. For billed database and stage storage at the organization level, see STORAGE_DAILY_HISTORY view.