- Schemas:
DATABASE_
This Account Usage view can be used to query the database replication history. The returned results include the database name, credits consumed, and bytes transferred for replication. Usage data is retained for 365 days (1 year).
Columns¶
| Column Name | Data Type | Description |
|---|---|---|
| START_TIME | TIMESTAMP_LTZ | The date and beginning of the hour (in the local time zone) in which the replication usage took place. |
| END_TIME | TIMESTAMP_LTZ | The date and end of the hour (in the local time zone) in which the replication usage took place. |
| DATABASE_NAME | VARCHAR | Name of the database. |
| DATABASE_ID | NUMBER | Internal/system-generated identifier for the database. |
| CREDITS_USED | NUMBER | Total number of credits used for database replication during the START_TIME and END_TIME window. |
| BYTES_TRANSFERRED | NUMBER | Number of bytes transferred for database replication during the START_TIME and END_TIME window. |
Usage notes¶
- Latency for the view may be up to 180 minutes (3 hours).
- Results are only returned for secondary databases in the target account.