Skip to main content

tags_values

Creates, updates, deletes, gets or lists a tags_values resource.

Overview

Nametags_values
TypeResource
Idazure.resources.tags_values

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
create_or_updateinserttagName, tagValue, subscriptionIdThis operation allows adding a value to the list of predefined values for an existing predefined tag name. A tag value can have a maximum of 256 characters.
deletedeletetagName, tagValue, subscriptionIdThis operation allows deleting a value from the list of predefined values for an existing predefined tag name. The value being deleted must not be in use as a tag value for the given tag name for any resource.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
tagNamestringThe name of the tag.
tagValuestringThe value of the tag to delete.

INSERT examples

This operation allows adding a value to the list of predefined values for an existing predefined tag name. A tag value can have a maximum of 256 characters.

INSERT INTO azure.resources.tags_values (
tagName,
tagValue,
subscriptionId
)
SELECT
'{{ tagName }}',
'{{ tagValue }}',
'{{ subscriptionId }}'
RETURNING
id,
count,
tagValue
;

DELETE examples

This operation allows deleting a value from the list of predefined values for an existing predefined tag name. The value being deleted must not be in use as a tag value for the given tag name for any resource.

DELETE FROM azure.resources.tags_values
WHERE tagName = '{{ tagName }}' --required
AND tagValue = '{{ tagValue }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;