SERVICES view¶

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

Columns¶

Column	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.
CURRENT_INSTANCES	NUMBER	The current number of instances for the service.
TARGET_INSTANCES	NUMBER	The target number of service instances that should be running as determined by Snowflake. When the CURRENT_INSTANCES value is not equal to the TARGET_INSTANCES value, Snowflake is either in the process of shutting down or launching service instances. For example, consider the following: Suppose you create a service with MIN_INSTANCES = 1 and MAX_INSTANCES = 3. While the service is running, Snowflake might determine that one instance is not enough. In this case, the value of TARGET_INSTANCES will increase, indicating Snowflake is in the process of launching additional instances. It’s also possible that the TARGET_INSTANCES value is less than the CURRENT_INSTANCES value, which indicates that Snowflake is in the process of reducing the number of running instances. If you create services but the compute pool doesn’t have capacity for the minimum number of instances that you requested, the value of TARGET_INSTANCES will be equal to the value of MIN_INSTANCES. The value of CURRENT_INSTANCES will be less than the value of TARGET_INSTANCES.
MIN_READY_INSTANCES	INT	Minimum service instances that must be ready for Snowflake to consider the service is ready to process requests.
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.
IS_JOB	BOOLEAN	`true` if the service is a job service; `false` otherwise.
SPEC_DIGEST	VARCHAR	The unique and immutable identifier representing the service spec content. To observe the changes to the value of the SPEC_DIGEST column over time, a service user might execute the SHOW SERVICES command periodically. If the service user notices a change in value, they can infer that the service was upgraded.
IS_UPGRADING	BOOLEAN	TRUE, if Snowflake is in the process of upgrading the service.
MANAGING_OBJECT_DOMAIN	VARCHAR	The domain of the managing object (for example, the domain of the notebook that manages the service). NULL if the service is not managed by a Snowflake entity.
MANAGING_OBJECT_NAME	VARCHAR	The name of the managing object (for example, the name of the notebook that manages the service). NULL if the service is not managed by a Snowflake entity.

Example¶

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