Skip to main content

key_values

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

Overview

Namekey_values
TypeResource
Idazure.app_configuration.key_values

Fields

The following fields are returned by SELECT queries:

The request was successful; the request was well-formed and received properly.

NameDatatypeDescription
idstringThe resource ID.
namestringThe name of the resource.
propertiesobjectAll key-value properties.
typestringThe type of the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, configStoreName, keyValueNameGets the properties of the specified key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.
create_or_updateinsertsubscriptionId, resourceGroupName, configStoreName, keyValueNameCreates a key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.
deletedeletesubscriptionId, resourceGroupName, configStoreName, keyValueNameDeletes a key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.

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
configStoreNamestringThe name of the configuration store.
keyValueNamestringIdentifier of key and label combination. Key and label are joined by $ character. Label is optional.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Gets the properties of the specified key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.

SELECT
id,
name,
properties,
type
FROM azure.app_configuration.key_values
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND configStoreName = '{{ configStoreName }}' -- required
AND keyValueName = '{{ keyValueName }}' -- required
;

INSERT examples

Creates a key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.

INSERT INTO azure.app_configuration.key_values (
data__properties,
subscriptionId,
resourceGroupName,
configStoreName,
keyValueName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ configStoreName }}',
'{{ keyValueName }}'
RETURNING
id,
name,
properties,
type
;

DELETE examples

Deletes a key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.

DELETE FROM azure.app_configuration.key_values
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND configStoreName = '{{ configStoreName }}' --required
AND keyValueName = '{{ keyValueName }}' --required
;