Schema:: ACCOUNT_USAGE

SERVICES view¶

This SERVICES view in the Account Usage schema is similar to SERVICES view in information schema except this view includes deleted Snowpark Container Services services. For more information about difference in these schemas, see Differences between Account Usage and Information Schema.

Columns¶

Column Name	Data Type	Description
SERVICE_ID	NUMBER	Internal/system-generated identifier for the service.
SERVICE_NAME	TEXT	Name of the service.
SERVICE_CATALOG_ID	NUMBER	Internal, Snowflake-generated identifier of the database for the service.
SERVICE_CATALOG	TEXT	Database that the service belongs to.
SERVICE_SCHEMA_ID	NUMBER	Internal, Snowflake-generated identifier of the schema for the service.
SERVICE_SCHEMA	TEXT	Schema that the service belongs to.
SERVICE_OWNER	TEXT	Name of the role that owns the service. App instance name if in an app.
SERVICE_OWNER_ROLE_TYPE	TEXT	Type of the owner role.
COMPUTE_POOL_ID	NUMBER	Identifier of the compute pool that runs the service.
COMPUTE_POOL_NAME	TEXT	Compute pool where the job was executed.
DNS_NAME	TEXT	DNS name associated with the service.
MIN_INSTANCES	INT	Minimum instances for the service.
MAX_INSTANCES	INT	Maximum instances for the service.
AUTO_RESUME	BOOLEAN	Flag that determines if the service can be auto resumed.
QUERY_WAREHOUSE	TEXT	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.
DELETED	TIMESTAMP_LTZ	Deletion time of the service.
COMMENT	TEXT	Comment for this service.
IS_JOB	BOOLEAN	`true` if the service is a job service; `false` otherwise.

Example¶

SELECT *
FROM snowflake.account_usage.services
WHERE service_name LIKE '%myservice%';

Copy