Schema:

ORGANIZATION_USAGE

# PREVIEW_STORAGE_DAILY_HISTORY View¶

The PREVIEW_STORAGE_DAILY_HISTORY view in the ORGANIZATION_USAGE schema can be used to query the average daily storage usage, in bytes, for all accounts in the organization for the last 365 days (1 year).

Note

The name of this view may change during the preview period or when the organizations feature is generally available.

While the feature is in preview, we may make some behavior changes, particularly to the behavior for seed. However, we will notify you about any changes before implementing them.

## Columns¶

Column Name

Data Type

Description

SERVICE_TYPE

VARCHAR

The type of service, which can be one of WAREHOUSE_METERING, WAREHOUSE_METERING_READER, AUTOMATIC_CLUSTERING, MATERIALIZED_VIEW, PIPE, or REPLICATION.

ORGANIZATION_NAME

VARCHAR

Name of the organization where the usage took place.

ACCOUNT_NAME

VARCHAR

Name of the account where the usage took place.

ACCOUNT_LOCATOR

VARCHAR

Locator for the account where the usage took place.

USAGE_DATE

DATE

The date (in the UTC time zone) in which the usage took place.

AVERAGE_BYTES

NUMBER

Number of bytes of database storage used, including data in Time Travel and Fail-safe.

REGION

VARCHAR

ID of the Snowflake Region where the account is located.

## Usage Notes¶

• Latency for the view may be up to 120 minutes (2 hours).

• The data is retained for 365 days (1 year).