secrets

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

Overview

Name	secrets
Type	Resource
Id	azure_isv.openshift_clusters.secrets

Fields

vw_secrets

Name	Datatype	Description
childResourceName	text	field from the properties object
resourceGroupName	text	field from the properties object
resourceName	text	field from the properties object
secret_resources	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object

secrets

Name	Datatype	Description
properties	object	SecretProperties represents the properties of a Secret
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	childResourceName, resourceGroupName, resourceName, subscriptionId	The operation returns properties of a Secret.
list	SELECT	resourceGroupName, resourceName, subscriptionId	The operation returns properties of each Secret.
create_or_update	INSERT	childResourceName, resourceGroupName, resourceName, subscriptionId	The operation returns properties of a Secret.
delete	DELETE	childResourceName, resourceGroupName, resourceName, subscriptionId	The operation returns nothing.
update	UPDATE	childResourceName, resourceGroupName, resourceName, subscriptionId	The operation returns properties of a Secret.

SELECT examples

The operation returns properties of each Secret.

vw_secrets

SELECT
childResourceName,
resourceGroupName,
resourceName,
secret_resources,
subscriptionId,
system_data
FROM azure_isv.openshift_clusters.vw_secrets
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

secrets

SELECT
properties,
systemData
FROM azure_isv.openshift_clusters.secrets
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.openshift_clusters.secrets (
childResourceName,
resourceGroupName,
resourceName,
subscriptionId,
properties
)
SELECT 
'{{ childResourceName }}',
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: secretResources
          value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

UPDATE example

Updates a secrets resource.

/*+ update */
UPDATE azure_isv.openshift_clusters.secrets
SET 
properties = '{{ properties }}'
WHERE 
childResourceName = '{{ childResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified secrets resource.

/*+ delete */
DELETE FROM azure_isv.openshift_clusters.secrets
WHERE childResourceName = '{{ childResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';