secrets

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

Overview

Name	secrets
Type	Resource
Id	azure.service_fabric_mesh.secrets

Fields

vw_secrets

Name	Datatype	Description
description	text	field from the properties object
content_type	text	field from the properties object
kind	text	field from the properties object
location	text	The geo-location where the resource lives
resourceGroupName	text	field from the properties object
secretResourceName	text	field from the properties object
status	text	field from the properties object
status_details	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

secrets

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Describes the properties of a secret resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, secretResourceName, subscriptionId	Gets the information about the secret resource with the given name. The information include the description and other properties of the secret.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets the information about all secret resources in a given resource group. The information include the description and other properties of the Secret.
list_by_subscription	SELECT	subscriptionId	Gets the information about all secret resources in a given resource group. The information include the description and other properties of the secret.
create	INSERT	resourceGroupName, secretResourceName, subscriptionId, data__properties	Creates a secret resource with the specified name, description and properties. If a secret resource with the same name exists, then it is updated with the specified description and properties.
delete	DELETE	resourceGroupName, secretResourceName, subscriptionId	Deletes the secret resource identified by the name.

SELECT examples

Gets the information about all secret resources in a given resource group. The information include the description and other properties of the secret.

vw_secrets

SELECT
description,
content_type,
kind,
location,
resourceGroupName,
secretResourceName,
status,
status_details,
subscriptionId,
tags
FROM azure.service_fabric_mesh.vw_secrets
WHERE subscriptionId = '{{ subscriptionId }}';

secrets

SELECT
location,
properties,
tags
FROM azure.service_fabric_mesh.secrets
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.service_fabric_mesh.secrets (
resourceGroupName,
secretResourceName,
subscriptionId,
data__properties,
tags,
location,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ secretResourceName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: kind
          value: []
        - name: description
          value: string
        - name: status
          value: []
        - name: statusDetails
          value: string
        - name: contentType
          value: string

DELETE example

Deletes the specified secrets resource.

/*+ delete */
DELETE FROM azure.service_fabric_mesh.secrets
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND secretResourceName = '{{ secretResourceName }}'
AND subscriptionId = '{{ subscriptionId }}';