- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
NOTEBOOKS_
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.
You can use the NOTEBOOKS_CONTAINER_RUNTIME_HISTORY view in the ORGANIZATION_USAGE schema to return the hourly credit usage for notebooks running on Snowpark Container Services across accounts in your organization.
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 usage took place. |
| END_TIME | TIMESTAMP_LTZ | The date and end of the hour (in the local time zone) in which the usage took place. |
| NOTEBOOK_NAME | VARCHAR | The name of the notebook (running on Snowpark Container Services) that incurred the credit usage. |
| NOTEBOOK_ID | NUMBER | The ID of the notebook that incurred the credit usage. |
| USER_NAME | VARCHAR | The name of the user associated with the notebook. NULL if the notebook was not run interactively. |
| USER_ID | NUMBER | The ID of the user associated with the notebook. NULL if the notebook was not run interactively. |
| COMPUTE_POOL_NAME | VARCHAR | The name of the compute pool associated with the notebook. |
| COMPUTE_POOL_ID | NUMBER | The ID of the compute pool associated with the notebook. |
| SERVICE_NAME | VARCHAR | The name of the service associated with the notebook. |
| SERVICE_ID | NUMBER | The ID of the service associated with the notebook. |
| NOTEBOOK_EXECUTION_TIME_SECS | NUMBER | The run time of the notebook in the given hour. |
| CREDITS | NUMBER(38, 9) | The number of credits that the notebook used in the hour. |
Usage notes¶
- Latency for the view may be up to 5 hours.
- The view provides hourly container notebook credit usage across accounts in your organization within the last 365 days (1 year).
- The credit rate usage is determined based on the machine type (instance family) of the compute pool, as outlined in the consumption table.