Categories:

System Functions (System Information)

SYSTEM$REGISTRY_LIST_IMAGES

Lists images in an image repository.

See also:

Working with an Image Registry and Repository

Syntax

SYSTEM$REGISTRY_LIST_IMAGES( '/<dbName>/<schemaName>/<repositoryName>' )
Copy

Arguments

Required:

dbName

Name of the database in which the repository is created.

schemaName

Name of the database in which the repository is created.

repositoryName

Name of the image repository.

Returns

Returns a JSON object listing all the images.

Usage notes

  • You need the read permission on the repository to get a list of images.

Examples

This function retrieves a list of images from the /tutorial_db/data_schema/tutorial_repository repository.

SELECT SYSTEM$REGISTRY_LIST_IMAGES('/tutorial_db/data_schema/tutorial_repository');
Copy

Sample output showing a list of two images in the repository:

+-----------------------------------------------------------------------------+
| SYSTEM$REGISTRY_LIST_IMAGES('/TUTORIAL_DB/DATA_SCHEMA/TUTORIAL_REPOSITORY') |
|-----------------------------------------------------------------------------|
| {"images":["my_echo_service_image","my_job_image"]}                         |
+-----------------------------------------------------------------------------+