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.

Note that operating on any object in a schema also requires the USAGE privilege on the parent database and 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            |         |
+-------------------------------+---------------------+---------------+-------------+-----------------------------------------------------------------------------------------------------------------+-----------+-----------------+---------+