Categories:

User & Security DDL

ALTER TAG

Modifies the properties for an existing tag, including renaming the tag.

Any changes made to the tag go into effect when the next SQL query that uses the tag runs.

Syntax

ALTER TAG [ IF EXISTS ] <name> RENAME TO <new_name>

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

Parameters

name

Identifier for the tag. The identifier is the key in the key = 'value' pair of the tag. Assign the 'value' using an ALTER <object> statement.

The identifier value must start with an alphabetic character and cannot contain spaces or special characters unless the entire identifier string is enclosed in double quotes (e.g. “My object”). Identifiers enclosed in double quotes are also case-sensitive.

For more details, see Identifier Requirements

RENAME TO new_name

Specifies the new identifier for the tag; must be unique for your schema. The new identifier cannot be used if the identifier is already in place for a different policy (e.g. masking policy).

For more details, see Identifier Requirements.

COMMENT = 'string_literal'

Specifies a comment for the tag.

Default: No value

Usage Notes

Examples

Rename the cost_center tag to cost_center_na, where na specifies North America.

alter tag cost_center rename to cost_center_na;