SHOW ARTIFACT REPOSITORIES¶

Lists the artifact repositories for which you have access privileges.

See also:: CREATE ARTIFACT REPOSITORY, ALTER ARTIFACT REPOSITORY, DESCRIBE ARTIFACT REPOSITORY, DROP ARTIFACT REPOSITORY, SHOW FILES IN ARTIFACT REPOSITORY, SHOW PACKAGES IN ARTIFACT REPOSITORY, SHOW VERSIONS IN ARTIFACT REPOSITORY

Syntax¶

SHOW ARTIFACT REPOSITORIES
  [ LIKE '<pattern>' ]
  [ IN { ACCOUNT | DATABASE [ <database_name> ] | SCHEMA [ <schema_name> ] } ]
  [ LIMIT <rows> ]

LIKE 'pattern': Filters the output by name. The match uses SQL LIKE pattern matching (case-insensitive).
IN { ACCOUNT | DATABASE [ database_name ] | SCHEMA [ schema_name ] }: Scopes the listing to an account, database, or schema. When DATABASE or SCHEMA is used without a name, the command uses the current database or schema.
LIMIT rows: Limits the maximum number of rows returned.

You can see a repository in the output if you have at least one privilege on it, or ownership of it.

The command returns one row per repository with the following columns:

Column	Description
`created_on`	Date and time the repository was created.
`name`	Name of the repository.
`database_name`	Database that contains the repository.
`schema_name`	Schema that contains the repository.
`type`	Repository type: `APPLICATION` or `PYPI`.
`api_integration`	API integration used by `PYPI` repositories. Empty for `APPLICATION`.
`owner`	Role that owns the repository.
`owner_role_type`	Type of role that owns the repository.
`comment`	Repository comment, if any.

List all artifact repositories in the current schema:

SHOW ARTIFACT REPOSITORIES;

List all repositories whose name starts with app_ in a specific database:

SHOW ARTIFACT REPOSITORIES LIKE 'app_%' IN DATABASE my_db;