certificates

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

Overview

Name	certificates
Type	Resource
Id	azure.batch.certificates

Fields

vw_certificates

Name	Datatype	Description
id	text	The ID of the resource.
name	text	The name of the resource.
accountName	text	field from the properties object
certificateName	text	field from the properties object
delete_certificate_error	text	field from the properties object
etag	text	The ETag of the resource, used for concurrency statements.
format	text	field from the properties object
previous_provisioning_state	text	field from the properties object
previous_provisioning_state_transition_time	text	field from the properties object
provisioning_state	text	field from the properties object
provisioning_state_transition_time	text	field from the properties object
public_data	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.
thumbprint	text	field from the properties object
thumbprint_algorithm	text	field from the properties object
type	text	The type of the resource.

certificates

Name	Datatype	Description
id	string	The ID of the resource.
name	string	The name of the resource.
etag	string	The ETag of the resource, used for concurrency statements.
properties	object	Certificate properties.
tags	object	The tags of the resource.
type	string	The type of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, certificateName, resourceGroupName, subscriptionId	Warning: This operation is deprecated and will be removed after February, 2024. Please use the Azure KeyVault Extension instead.
list_by_batch_account	SELECT	accountName, resourceGroupName, subscriptionId	Warning: This operation is deprecated and will be removed after February, 2024. Please use the Azure KeyVault Extension instead.
create	INSERT	accountName, certificateName, resourceGroupName, subscriptionId	Warning: This operation is deprecated and will be removed after February, 2024. Please use the Azure KeyVault Extension instead.
delete	DELETE	accountName, certificateName, resourceGroupName, subscriptionId	Warning: This operation is deprecated and will be removed after February, 2024. Please use the Azure KeyVault Extension instead.
update	UPDATE	accountName, certificateName, resourceGroupName, subscriptionId	Warning: This operation is deprecated and will be removed after February, 2024. Please use the Azure KeyVault Extension instead.
cancel_deletion	EXEC	accountName, certificateName, resourceGroupName, subscriptionId	If you try to delete a certificate that is being used by a pool or compute node, the status of the certificate changes to deleteFailed. If you decide that you want to continue using the certificate, you can use this operation to set the status of the certificate back to active. If you intend to delete the certificate, you do not need to run this operation after the deletion failed. You must make sure that the certificate is not being used by any resources, and then you can try again to delete the certificate.

Warning: This operation is deprecated and will be removed after February, 2024. Please use the Azure KeyVault Extension instead. |

SELECT examples

Warning: This operation is deprecated and will be removed after February, 2024. Please use the Azure KeyVault Extension instead.

vw_certificates

SELECT
id,
name,
accountName,
certificateName,
delete_certificate_error,
etag,
format,
previous_provisioning_state,
previous_provisioning_state_transition_time,
provisioning_state,
provisioning_state_transition_time,
public_data,
resourceGroupName,
subscriptionId,
tags,
thumbprint,
thumbprint_algorithm,
type
FROM azure.batch.vw_certificates
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

certificates

SELECT
id,
name,
etag,
properties,
tags,
type
FROM azure.batch.certificates
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.batch.certificates (
accountName,
certificateName,
resourceGroupName,
subscriptionId,
properties,
tags
)
SELECT 
'{{ accountName }}',
'{{ certificateName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: thumbprintAlgorithm
          value: string
        - name: thumbprint
          value: string
        - name: format
          value: string
        - name: data
          value: string
        - name: password
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: etag
      value: string
    - name: tags
      value: object

UPDATE example

Updates a certificates resource.

/*+ update */
UPDATE azure.batch.certificates
SET 
properties = '{{ properties }}',
tags = '{{ tags }}'
WHERE 
accountName = '{{ accountName }}'
AND certificateName = '{{ certificateName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified certificates resource.

/*+ delete */
DELETE FROM azure.batch.certificates
WHERE accountName = '{{ accountName }}'
AND certificateName = '{{ certificateName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';