secrets

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

Overview

Name	secrets
Type	Resource
Id	azure.dev_test_labs.secrets

Fields

vw_secrets

Name	Datatype	Description
id	text	The identifier of the resource.
name	text	The name of the resource.
labName	text	field from the properties object
location	text	The location of the resource.
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	The tags of the resource.
type	text	The type of the resource.
unique_identifier	text	field from the properties object
userName	text	field from the properties object
value	text	field from the properties object

secrets

Name	Datatype	Description
id	string	The identifier of the resource.
name	string	The name of the resource.
location	string	The location of the resource.
properties	object	Properties of a secret.
tags	object	The tags of the resource.
type	string	The type of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	labName, name, resourceGroupName, subscriptionId, userName	Get secret.
list	SELECT	labName, resourceGroupName, subscriptionId, userName	List secrets in a given user profile.
create_or_update	INSERT	labName, name, resourceGroupName, subscriptionId, userName, data__properties	Create or replace an existing secret. This operation can take a while to complete.
delete	DELETE	labName, name, resourceGroupName, subscriptionId, userName	Delete secret.
update	UPDATE	labName, name, resourceGroupName, subscriptionId, userName	Allows modifying tags of secrets. All other properties will be ignored.

SELECT examples

List secrets in a given user profile.

vw_secrets

SELECT
id,
name,
labName,
location,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
type,
unique_identifier,
userName,
value
FROM azure.dev_test_labs.vw_secrets
WHERE labName = '{{ labName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND userName = '{{ userName }}';

secrets

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure.dev_test_labs.secrets
WHERE labName = '{{ labName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND userName = '{{ userName }}';

INSERT example

Use the following StackQL query and manifest file to create a new secrets resource.

All Properties

/*+ create */
INSERT INTO azure.dev_test_labs.secrets (
labName,
name,
resourceGroupName,
subscriptionId,
userName,
data__properties,
location,
tags,
properties
)
SELECT 
'{{ labName }}',
'{{ name }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ userName }}',
'{{ data__properties }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object
    - name: properties
      value:
        - name: value
          value: string
        - name: provisioningState
          value: string
        - name: uniqueIdentifier
          value: string

UPDATE example

Updates a secrets resource.

/*+ update */
UPDATE azure.dev_test_labs.secrets
SET 
tags = '{{ tags }}'
WHERE 
labName = '{{ labName }}'
AND name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND userName = '{{ userName }}';

DELETE example

Deletes the specified secrets resource.

/*+ delete */
DELETE FROM azure.dev_test_labs.secrets
WHERE labName = '{{ labName }}'
AND name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND userName = '{{ userName }}';