SHOW IMAGES IN IMAGE REPOSITORY

Lists the images in an image repository.

See also:

CREATE IMAGE REPOSITORY, DROP IMAGE REPOSITORY, SHOW IMAGE REPOSITORIES

Syntax

SHOW IMAGES IN IMAGE REPOSITORY <name>
Copy

Parameters

name

Name of the image repository.

Access control requirements

A role used to execute this operation must have the following privileges at a minimum:

Privilege

Object

Notes

USAGE

Image repository

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Output

The command output provides the following columns:

Column

Description

created_on

Date and time when the image was uploaded to the image repository.

image_name

Image name

tags

Image tags

digest

SHA256 digest of the image

image_path

Image path (database_name/schema_name/repository_name/image_name:image_tag)

Usage notes

  • The command doesn’t require a running warehouse to execute.

  • The command only returns objects for which the current user’s current role has been granted at least one access privilege.

  • The MANAGE GRANTS access privilege implicitly allows its holder to see every object in the account. By default, only the account administrator (users with the ACCOUNTADMIN role) and security administrator (users with the SECURITYADMIN role) have the MANAGE GRANTS privilege.

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

Examples

List the images in the tutorial_repository image repository.

SHOW IMAGES IN IMAGE REPOSITORY tutorial_db.data_schema.tutorial_repository;
Copy
+-------------------------------+-----------------------+--------+-------------------------------------------------------------------------+--------------------------------------------------------------------------+
| created_on                    | image_name            | tags   | digest                                                                  | image_path                                                               |
|-------------------------------+-----------------------+--------+-------------------------------------------------------------------------+--------------------------------------------------------------------------|
| 2024-04-18 13:51:35.000 -0700 | my_echo_service_image | latest | sha256:70421668b2635b2996c6d5bc80627cf6d98c0716948b5f60d198d6411d4b4681 | tutorial_db/data_schema/tutorial_repository/my_echo_service_image:latest |
+-------------------------------+-----------------------+--------+-------------------------------------------------------------------------+--------------------------------------------------------------------------+
Language: English