Schemas:

ACCOUNT_USAGE

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 NameData TypeDescription
START_TIMETIMESTAMP_LTZThe date and beginning of the hour (in the local time zone) in which the catalog-linked database operation took place.
END_TIMETIMESTAMP_LTZThe date and end of the hour (in the local time zone) in which the catalog-linked database operation took place.
DATABASE_IDNUMBERInternal identifier for the catalog-linked database that consumed credits.
DATABASE_NAMEVARCHARName of the catalog-linked database that consumed credits.
CREDITS_USED_COMPUTENUMBER(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_SERVICESNUMBER(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_USEDNUMBER(38,9)Number of credits billed for this catalog-linked database between the START_TIME and END_TIME.