- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
SERVICES view¶
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.
This Organization Usage view displays a row for each Snowpark Container Services service and job service across all the accounts in your organization, including services that have been dropped.
- See also:
SERVICES view (Account Usage)
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 |
|---|---|---|
| SERVICE_ID | NUMBER | Internal/system-generated identifier for the service. |
| SERVICE_NAME | VARCHAR | Name of the service. |
| SERVICE_CATALOG_ID | NUMBER | Internal, Snowflake-generated identifier of the database for the service. |
| SERVICE_CATALOG | VARCHAR | Database that the service belongs to. |
| SERVICE_SCHEMA_ID | NUMBER | Internal, Snowflake-generated identifier of the schema for the service. |
| SERVICE_SCHEMA | VARCHAR | Schema that the service belongs to. |
| SERVICE_OWNER | VARCHAR | Name of the role that owns the service. App instance name if in an app. |
| SERVICE_OWNER_ROLE_TYPE | VARCHAR | Type of the owner role. |
| COMPUTE_POOL_ID | NUMBER | Identifier of the compute pool that runs the service. |
| COMPUTE_POOL_NAME | VARCHAR | Compute pool where the job was executed. |
| DNS_NAME | VARCHAR | DNS name associated with the service. |
| MIN_READY_INSTANCES | NUMBER | Minimum service instances that must be ready for Snowflake to consider the service is ready to process requests. |
| MIN_INSTANCES | NUMBER | Minimum instances for the service. |
| MAX_INSTANCES | NUMBER | Maximum instances for the service. |
| AUTO_RESUME | BOOLEAN | Flag that determines if the service can be auto resumed. |
| QUERY_WAREHOUSE | VARCHAR | Name of the default query warehouse of the service. |
| CREATED | TIMESTAMP_LTZ | Creation time of the service. |
| LAST_ALTERED | TIMESTAMP_LTZ | Last altered time of the service. |
| LAST_RESUMED | TIMESTAMP_LTZ | Last resumed time of the service. |
| LAST_SUSPENDED | TIMESTAMP_LTZ | Last suspended time of the service. |
| AUTO_SUSPEND_SECS | NUMBER | Number of seconds of inactivity after which the service is automatically suspended. |
| DELETED | TIMESTAMP_LTZ | Deletion time of the service. |
| COMMENT | VARCHAR | Comment for this service. |
| IS_JOB | BOOLEAN | true if the service is a job service; false otherwise. |
| IS_ASYNC_JOB | BOOLEAN | true if the service is an asynchronous job service; false otherwise. |
Usage notes¶
- Latency for the view may be up to 24 hours.