SERVICES View¶

This view shows existing Snowpark Container Services services in the database.

Columns¶

Column Name	Data Type	Description
SERVICE_CATALOG	TEXT	Database that the service belongs to.
SERVICE_SCHEMA	TEXT	Schema that the service belongs to.
SERVICE_NAME	TEXT	Name of the service.
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_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.
COMMENT	TEXT	Comment for this service.

SELECT *
FROM my_database.information_schema.services
WHERE service_name LIKE '%myservice_%';

Copy