ca_certificates

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

Overview

Name	ca_certificates
Type	Resource
Id	azure.event_grid.ca_certificates

Fields

vw_ca_certificates

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	text	The name of the resource
description	text	field from the properties object
caCertificateName	text	field from the properties object
encoded_certificate	text	field from the properties object
expiry_time_in_utc	text	field from the properties object
issue_time_in_utc	text	field from the properties object
namespaceName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

ca_certificates

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
properties	object	The properties of CA certificate.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	caCertificateName, namespaceName, resourceGroupName, subscriptionId	Get properties of a CA certificate.
list_by_namespace	SELECT	namespaceName, resourceGroupName, subscriptionId	Get all the CA certificates under a namespace.
create_or_update	INSERT	caCertificateName, namespaceName, resourceGroupName, subscriptionId	Create or update a CA certificate with the specified parameters.
delete	DELETE	caCertificateName, namespaceName, resourceGroupName, subscriptionId	Delete an existing CA certificate.

SELECT examples

Get all the CA certificates under a namespace.

vw_ca_certificates

SELECT
id,
name,
description,
caCertificateName,
encoded_certificate,
expiry_time_in_utc,
issue_time_in_utc,
namespaceName,
provisioning_state,
resourceGroupName,
subscriptionId,
system_data,
type
FROM azure.event_grid.vw_ca_certificates
WHERE namespaceName = '{{ namespaceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

ca_certificates

SELECT
id,
name,
properties,
systemData,
type
FROM azure.event_grid.ca_certificates
WHERE namespaceName = '{{ namespaceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.event_grid.ca_certificates (
caCertificateName,
namespaceName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ caCertificateName }}',
'{{ namespaceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      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
    - name: properties
      value:
        - name: description
          value: string
        - name: encodedCertificate
          value: string
        - name: issueTimeInUtc
          value: string
        - name: expiryTimeInUtc
          value: string
        - name: provisioningState
          value: string

DELETE example

Deletes the specified ca_certificates resource.

/*+ delete */
DELETE FROM azure.event_grid.ca_certificates
WHERE caCertificateName = '{{ caCertificateName }}'
AND namespaceName = '{{ namespaceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';