containers

Creates, updates, deletes, gets or lists a containers resource.

Overview

Name	containers
Type	Resource
Id	snowflake.service.containers

Fields

The following fields are returned by SELECT queries:

list_service_containers

successful

Name	Datatype	Description
instance_id	string	ID of the service instance (this is the index of the service instance starting from 0).
container_name	string	Name of the container.
database_name	string	A Snowflake object identifier. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive. (pattern: ^"([^"]|"")+"|[a-zA-Z_][a-zA-Z0-9_$]*$, example: TEST_NAME)
image_name	string	Image name used to create the service container.
schema_name	string	A Snowflake object identifier. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive. (pattern: ^"([^"]|"")+"|[a-zA-Z_][a-zA-Z0-9_$]*$, example: TEST_NAME)
service_name	string	A Snowflake object identifier. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive. (pattern: ^"([^"]|"")+"|[a-zA-Z_][a-zA-Z0-9_$]*$, example: TEST_NAME)
image_digest	string	The unique and immutable identifier representing the image content.
instance_status	string	The current status of the service instance.
message	string	Additional clarification about status.
restart_count	integer	Number of times Snowflake restarted the service.
service_status	string	The current status of the service.
start_time	string	Date and time when the container started.
status	string	Service container status.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_service_containers	select	database_name, schema_name, name, endpoint		List all the containers of the service

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
database_name	string	Identifier (i.e. name) for the database to which the resource belongs. You can use the /api/v2/databases GET request to get a list of available databases.
endpoint	string	Organization and Account Name (default: orgid-acctid)
name	string	Identifier (i.e. name) for the resource.
schema_name	string	Identifier (i.e. name) for the schema to which the resource belongs. You can use the /api/v2/databases/{database}/schemas GET request to get a list of available schemas for the specified database.

SELECT examples

list_service_containers

List all the containers of the service

SELECT
instance_id,
container_name,
database_name,
image_name,
schema_name,
service_name,
image_digest,
instance_status,
message,
restart_count,
service_status,
start_time,
status
FROM snowflake.service.containers
WHERE database_name = '{{ database_name }}' -- required
AND schema_name = '{{ schema_name }}' -- required
AND name = '{{ name }}' -- required
AND endpoint = '{{ endpoint }}' -- required;