REPLICATION_USAGE_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 REPLICATION_USAGE_HISTORY view in the ORGANIZATION_USAGE schema can be used to query the replication history for databases in your organization within a specified date range. The view includes the database name, credits consumed, and bytes transferred for replication.

Note

This view only displays replication usage for database replication. To view usage for replication using replication and failover groups, see the REPLICATION_GROUP_USAGE_HISTORY view.

Columns¶

Column Name	Data Type	Description
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	Name of the account locator.
REGION	VARCHAR	Name of the region where the account is located.
USAGE_DATE	DATE	Date (in the UTC time zone) of this usage record.
DATABASE_ID	NUMBER	Internal/system-generated identifier for the database.
DATABASE_NAME	VARCHAR	Name of the database.
CREDITS_USED	NUMBER	Total number of credits used for database replication during the USAGE_DATE.
BYTES_TRANSFERRED	VARCHAR	Number of bytes transferred for database replication during the USAGE_DATE.

Usage notes¶

Latency for the view may be up to 24 hours (1 day).
The data is retained for 365 days (1 year).