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