Schemas:

ACCOUNT_USAGE , READER_ACCOUNT_USAGE

STORAGE_USAGE View

This Account Usage view displays the average daily data storage usage, in bytes, within the last 365 days (1 year) across the entire account, including data in:

  • Database tables.

  • Files in all internal stages.

See also:

DATABASE_STORAGE_USAGE_HISTORY View , STAGE_STORAGE_USAGE_HISTORY View

Columns

Column Name

Data Type

Description

READER_ACCOUNT_NAME

TEXT

Name of the reader account where the data is stored. Column only included in view in READER_ACCOUNT_USAGE schema.

USAGE_DATE

TIMESTAMP_LTZ

Date of this storage usage record. The date is based on the local time zone. It is recommended that you change the query session to use the UTC time zone instead (e.g. ALTER SESSION SET TIMEZONE='UTC').

STORAGE_BYTES

NUMBER

Number of bytes of table storage used, including bytes for data currently in Time Travel.

STAGE_BYTES

NUMBER

Number of bytes of stage storage used by files in all internal stages (named, table, and user).

FAILSAFE_BYTES

NUMBER

Number of bytes of data in Fail-safe.

Usage Notes

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

Back to top