SHOW IMAGE REPOSITORIES¶

Lists the image repositories for which you have access privileges.

You can use this command to list the repositories in the current database and schema for the session, a specified database or schema, or your entire account.

See also:: CREATE IMAGE REPOSITORY , DROP IMAGE REPOSITORY

Syntax¶

SHOW IMAGE REPOSITORIES [ LIKE '<pattern>' ]
           [ IN
                {
                  ACCOUNT                  |

                  DATABASE                 |
                  DATABASE <database_name> |

                  SCHEMA                   |
                  SCHEMA <schema_name>     |
                  <schema_name>
                }
           ]

Copy

Parameters¶

LIKE 'pattern'

Optionally filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ...

... LIKE '%TESTING%' ...

. Default: No value (no filtering is applied to the output).

[ IN ... ]

Optionally specifies the scope of the command. Specify one of the following:

ACCOUNT

Returns records for the entire account.

DATABASE, . DATABASE db_name

Returns records for the current database in use or for a specified database (db_name).

If you specify DATABASE without db_name and no database is in use, the keyword has no effect on the output.

SCHEMA, . SCHEMA schema_name, . schema_name

Returns records for the current schema in use or a specified schema (schema_name).

SCHEMA is optional if a database is in use or if you specify the fully qualified schema_name (for example, db.schema).

If no database is in use, specifying SCHEMA has no effect on the output.

Default: Depends on whether the session currently has a database in use:

Database: DATABASE is the default (that is, the command returns the objects you have privileges to view in the database).
No database: ACCOUNT is the default (that is, the command returns the objects you have privileges to view in your account).

Access control requirements¶

Any of the following repository privileges grants the permission to see repositories in the SHOW IMAGE REPOSITORIES output. If you don’t have any of these privileges, SHOW IMAGE REPOSITORIES will return an empty result.

Privilege	Object	Notes
READ	Image repository	To pull an image from a repository, the role requires this permission.
WRITE	Image repository	To push an image to a repository, the role requires this permission.
OWNERSHIP	Image repository	To create a repository, the role requires this permission.

The USAGE privilege on the parent database and schema are required to perform operations on any object in a schema.

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 repository properties and metadata in the following columns:

Column	Description
`created_on`	Date and time when the repository was created.
`database_name`	Database in which the repository was created.
`schema_name`	Schema in which the repository was created.
`repository_url`	URL of the image repository. You need this URL to push (for example, `docker push`) or pull (for example, `docker pull`) images from the repository.
`owner`	Role that owns the repository.
`owner_role_type`	The type of role that owns the object; either ROLE or DATABASE_ROLE.
`comment`	Description for the repository.

Usage notes¶

Columns that start with the prefix is_ return either Y (yes) or N (no).
The command does not require a running warehouse to execute.
The command returns a maximum of 10K records for the specified object type, as dictated by the access privileges for the role used to execute the command; any records above the 10K limit are not returned, even with a filter applied.

To view results for which more than 10K records exist, query the corresponding view (if one exists) in the Snowflake Information Schema.

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¶

The following two examples list repositories in the current database and current schema:

SHOW IMAGE REPOSITORIES;

Copy

SHOW IMAGE REPOSITORIES IN SCHEMA;

Copy

The following example lists repositories in the current database and the specified schema:

SHOW IMAGE REPOSITORIES IN SCHEMA sc1;

Copy

The following example lists repositories in the current database and all schemas:

SHOW IMAGE REPOSITORIES IN DATABASE;

Copy

The following example lists repositories in the specified database and all schemas:

SHOW IMAGE REPOSITORIES IN DATABASE db1;

Copy

The following example lists repositories in the current account (all databases and all schemas):

SHOW IMAGE REPOSITORIES IN ACCOUNT;

Copy

Sample output:

+-------------------------------+---------------------+---------------+-------------+-----------------------------------------------------------------------------------------------------------------+-----------+-----------------+---------+
| created_on                    | name                | database_name | schema_name | repository_url                                                                                                  | owner     | owner_role_type | comment |
|-------------------------------+---------------------+---------------+-------------+-----------------------------------------------------------------------------------------------------------------+-----------+-----------------+---------|
| 2023-05-09 14:27:19.459 -0700 | TUTORIAL_REPOSITORY | TUTORIAL_DB   | DATA_SCHEMA | orgname-acctname.registry.snowflakecomputing.com/tutorial_db/data_schema/tutorial_repository | TEST_ROLE | ROLE            |         |
+-------------------------------+---------------------+---------------+-------------+-----------------------------------------------------------------------------------------------------------------+-----------+-----------------+---------+