Skip to main content

secrets

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

Overview

Namesecrets
TypeResource
Idazure.key_vault.secrets

Fields

The following fields are returned by SELECT queries:

Retrieved secret

NameDatatypeDescription
idstringFully qualified identifier of the key vault resource.
namestringName of the key vault resource.
locationstringAzure location of the key vault resource.
propertiesobjectProperties of the secret
tagsobjectTags assigned to the key vault resource.
typestringResource type of the key vault resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, vaultName, secretName, subscriptionIdGets the specified secret. NOTE: This API is intended for internal use in ARM deployments. Users should use the data-plane REST service for interaction with vault secrets.
listselectresourceGroupName, vaultName, subscriptionId$topThe List operation gets information about the secrets in a vault. NOTE: This API is intended for internal use in ARM deployments. Users should use the data-plane REST service for interaction with vault secrets.
create_or_updateinsertresourceGroupName, vaultName, secretName, subscriptionId, data__propertiesCreate or update a secret in a key vault in the specified subscription. NOTE: This API is intended for internal use in ARM deployments. Users should use the data-plane REST service for interaction with vault secrets.
updateupdateresourceGroupName, vaultName, secretName, subscriptionIdUpdate a secret in the specified subscription. NOTE: This API is intended for internal use in ARM deployments. Users should use the data-plane REST service for interaction with vault secrets.

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
resourceGroupNamestringThe name of the Resource Group to which the vault belongs.
secretNamestringName of the secret
subscriptionIdstringSubscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.
vaultNamestringName of the vault
$topinteger (int32)Maximum number of results to return.

SELECT examples

Gets the specified secret. NOTE: This API is intended for internal use in ARM deployments. Users should use the data-plane REST service for interaction with vault secrets.

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure.key_vault.secrets
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND vaultName = '{{ vaultName }}' -- required
AND secretName = '{{ secretName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Create or update a secret in a key vault in the specified subscription. NOTE: This API is intended for internal use in ARM deployments. Users should use the data-plane REST service for interaction with vault secrets.

INSERT INTO azure.key_vault.secrets (
data__tags,
data__properties,
resourceGroupName,
vaultName,
secretName,
subscriptionId
)
SELECT
'{{ tags }}',
'{{ properties }}' /* required */,
'{{ resourceGroupName }}',
'{{ vaultName }}',
'{{ secretName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
location,
properties,
tags,
type
;

UPDATE examples

Update a secret in the specified subscription. NOTE: This API is intended for internal use in ARM deployments. Users should use the data-plane REST service for interaction with vault secrets.

UPDATE azure.key_vault.secrets
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND vaultName = '{{ vaultName }}' --required
AND secretName = '{{ secretName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
id,
name,
location,
properties,
tags,
type;