CATALOG_LINKED_DATABASE_USAGE_HISTORY view¶

Use this Account Usage view to view the credit usage for your catalog-linked databases within the last 12 months.

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 catalog-linked database operation took place.
END_TIME	TIMESTAMP_LTZ	The date and end of the hour (in the local time zone) in which the catalog-linked database operation took place.
DATABASE_ID	NUMBER	Internal identifier for the catalog-linked database that consumed credits.
DATABASE_NAME	VARCHAR	Name of the catalog-linked database that consumed credits.
CREDITS_USED_COMPUTE	NUMBER(38,9)	Number of credits used by the catalog-linked database for table creation operations between the START_TIME and END_TIME. The cost for this usage is described in Table 5 of the Snowflake service consumption table on the Snowflake website. See the Snowflake-managed compute column for the Automated Refresh and Data Registration row.
CREDITS_USED_CLOUD_SERVICES	NUMBER(38,9)	Number of credits used by the catalog-linked database for automatic table discovery, schema creation or deletion, and table deletion between the START_TIME and END_TIME. Usage for cloud services is charged only if the daily consumption of cloud services exceeds 10% of the daily usage of virtual warehouses. For more information, see Understanding billing for cloud services usage.
CREDITS_USED	NUMBER(38,9)	Number of credits billed for this catalog-linked database between the START_TIME and END_TIME.