ALTER ARTIFACT REPOSITORY¶

Modifies the properties of an existing artifact repository.

See also:: CREATE ARTIFACT REPOSITORY , DESCRIBE ARTIFACT REPOSITORY , DROP ARTIFACT REPOSITORY , SHOW ARTIFACT REPOSITORIES

Syntax¶

ALTER ARTIFACT REPOSITORY [ IF EXISTS ] <name> SET
  [ COMMENT = '<string_literal>' ]

ALTER ARTIFACT REPOSITORY [ IF EXISTS ] <name> UNSET
  { COMMENT }

ALTER ARTIFACT REPOSITORY [ IF EXISTS ] <name> SET
  TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]

ALTER ARTIFACT REPOSITORY [ IF EXISTS ] <name> UNSET
  TAG <tag_name> [ , <tag_name> ... ]

Parameters¶

name

Specifies the identifier of the artifact repository to alter.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

SET ...

Sets one or more properties on the repository.

COMMENT = 'string_literal': Updates the repository comment.

UNSET ...

Removes a property, resetting it to the default.

SET TAG / UNSET TAG

Adds or removes tags on the repository. For more details, see Introduction to object tagging.

Access control requirements¶

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

Privilege	Object	Notes
OWNERSHIP	Artifact repository	Required to alter any property or tag on the repository.

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent 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.

Usage notes¶

You can’t change the TYPE of an existing artifact repository. To change the type, drop the repository and create a new one.
You can’t change the API_INTEGRATION of a PYPI repository after creation.

Examples¶

Update the comment on a repository:

ALTER ARTIFACT REPOSITORY my_app_repo SET
  COMMENT = 'Production app builds';

Clear the comment:

ALTER ARTIFACT REPOSITORY my_app_repo UNSET COMMENT;

Set a tag:

ALTER ARTIFACT REPOSITORY my_app_repo SET
  TAG cost_center = 'platform';