- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
CATALOG_
Important
This view is only available in the organization account. For more information, see Premium views in the organization account.
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.
Use this Organization Usage view to view the credit usage for catalog-linked databases across accounts in your organization within the last 12 months.
Columns¶
Organization-level columns
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_LOCATOR | VARCHAR | System-generated identifier for the account. |
| ACCOUNT_NAME | VARCHAR | User-defined identifier for the account. |
Additional 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. |
Usage notes¶
- Latency for the view may be up to 5 hours.