Organization Usage | Snowflake Documentation

ACCESS_HISTORY

Historical

24 hours

Premium view (only available in organization account).

ACCOUNTS

Object

24 hours

ALERT_HISTORY

Historical

24 hours

Premium view (only available in organization account).

ANOMALIES_IN_CURRENCY_DAILY

Historical

24 hours

AUTOMATIC_CLUSTERING_HISTORY

Historical

24 hours

Data retained for 1 year.

BACKUP_OPERATION_HISTORY

Historical

6 hours

Data retained for 1 year.

BACKUP_POLICIES

Object

6 hours

BACKUP_SETS

Object

6 hours

BACKUPS

Object

6 hours

CLASSES

Object

24 hours

Premium view (only available in organization account).

CLASS_INSTANCES

Object

24 hours

Premium view (only available in organization account).

COLUMNS

Object

24 hours

Premium view (only available in organization account).

COMPLETE_TASK_GRAPHS

Historical

24 hours

Premium view (only available in organization account).

CONTRACT_ITEMS ^[2]

Historical

24 hours

COPY_HISTORY

Historical

24 hours

Premium view (only available in organization account).

DATA_TRANSFER_DAILY_HISTORY

Historical

2 hours

Data retained for 1 year.

DATA_TRANSFER_HISTORY

Historical

24 hours

Data retained for 1 year.

DATABASE_STORAGE_USAGE_HISTORY

Historical

24 hours

Data retained for 1 year.

DATABASES

Object

24 hours

Premium view (only available in organization account).

FEATURE_POLICIES

Object

24 hours

Premium view (only available in organization account).

FILE_FORMATS

Object

24 hours

Premium view (only available in organization account).

FUNCTIONS

Object

24 hours

Premium view (only available in organization account).

GRANTS_TO_ROLES

Object

24 hours

Premium view (only available in organization account).

GRANTS_TO_USERS

Object

24 hours

Premium view (only available in organization account).

LISTING_AUTO_FULFILLMENT_USAGE_HISTORY

Historical

72 hours

Data retained for 1 year.

LOAD_HISTORY

Historical

24 hours

Premium view (only available in organization account).

LOCK_WAIT_HISTORY

Historical

24 hours

Premium view (only available in organization account).

LOGIN_HISTORY

Historical

24 hours

Premium view (only available in organization account).

MARKETPLACE_DISBURSEMENT_REPORT

Historical

24 hours

Data retained for 1 year.

MARKETPLACE_PAID_USAGE_DAILY

Historical

24 hours

Data retained for 1 year.

MASKING_POLICIES

Object

24 hours

Premium view (only available in organization account).

MATERIALIZED_VIEW_REFRESH_HISTORY

Historical

24 hours

Data retained for 1 year.

METERING_DAILY_HISTORY

Historical

2 hours

Data retained for 1 year.

METERING_HISTORY

Historical

24 hours

Premium view (only available in organization account).

MONETIZED_USAGE_DAILY

Historical

24 hours

Data retained for 1 year.

OBJECT_DEPENDENCIES

Historical

24 hours

Premium view (only available in organization account).

PASSWORD_POLICIES

Object

24 hours

Premium view (only available in organization account).

PIPE_USAGE_HISTORY

Historical

24 hours

Data retained for 1 year.

PIPES

Object

24 hours

Premium view (only available in organization account).

POLICY_REFERENCES

Object

24 hours

Premium view (only available in organization account).

PROCEDURES

Object

24 hours

Premium view (only available in organization account).

QUERY_ACCELERATION_ELIGIBLE

Historical

24 hours

Premium view (only available in organization account).

QUERY_ACCELERATION_HISTORY

Historical

24 hours

Data retained for 1 year.

QUERY_ATTRIBUTION_HISTORY

Historical

24 hours

Premium view (only available in organization account).

QUERY_HISTORY

Historical

24 hours

Premium view (only available in organization account).

RATE_SHEET_DAILY ^[2]

Historical

24 hours

REFERENTIAL_CONSTRAINTS

Object

24 hours

Premium view (only available in organization account).

REMAINING_BALANCE_DAILY ^[2]

Historical

72 hours

REPLICATION_GROUP_REFRESH_HISTORY

Historical

24 hours

Premium view (only available in organization account).

REPLICATION_GROUP_USAGE_HISTORY

Historical

24 hours

Data retained for 1 year.

REPLICATION_USAGE_HISTORY

Historical

24 hours

Data retained for 1 year.

RESOURCE_MONITORS

24 hours

Premium view (only available in organization account).

ROLES

Object

24 hours

Premium view (only available in organization account).

ROW_ACCESS_POLICIES

Object

24 hours

Premium view (only available in organization account).

SCHEMATA

Object

24 hours

Premium view (only available in organization account).

SEARCH_OPTIMIZATION_HISTORY

Historical

24 hours

Data retained for 1 year.

SEQUENCES

Object

24 hours

Premium view (only available in organization account).

SESSION_POLICIES

Object

24 hours

Premium view (only available in organization account).

SESSIONS

Historical

24 hours

Premium view (only available in organization account).

SNAPSHOT_OPERATION_HISTORY

Historical

6 hours

Data retained for 1 year. This view is deprecated. Use the BACKUP_OPERATION_HISTORY view instead.

SNAPSHOT_POLICIES

Object

6 hours

This view is deprecated. Use the BACKUP_POLICIES view instead.

SNAPSHOT_SETS

Object

6 hours

This view is deprecated. Use the BACKUP_SETS view instead.

SNAPSHOTS

Object

6 hours

This view is deprecated. Use the BACKUPS view instead.

STAGES

Object

24 hours

Premium view (only available in organization account).

STAGE_STORAGE_USAGE_HISTORY

Historical

24 hours

Data retained for 1 year.

STORAGE_DAILY_HISTORY

Historical

2 hours

Data retained for 1 year.

STORAGE_LIFECYCLE_POLICIES

Object

24 hours

Premium view (only available in organization account).

STORAGE_LIFECYCLE_POLICY_HISTORY

Historical

24 hours

Premium view (only available in organization account). Data retained for 1 year.

TABLE_CONSTRAINTS

Object

24 hours

Premium view (only available in organization account).

TABLE_STORAGE_METRICS

Object

24 hours

Premium view (only available in organization account).

TABLES

Object

24 hours

Premium view (only available in organization account).

TAG_REFERENCES

Object

24 hours

Premium view (only available in organization account).