server_trust_certificates

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

Overview

Name	server_trust_certificates
Type	Resource
Id	azure.sql.server_trust_certificates

Fields

vw_server_trust_certificates

Name	Datatype	Description
certificateName	text	field from the properties object
certificate_name	text	field from the properties object
managedInstanceName	text	field from the properties object
public_blob	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
thumbprint	text	field from the properties object

server_trust_certificates

Name	Datatype	Description
properties	object	The properties of a server trust certificate.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	certificateName, managedInstanceName, resourceGroupName, subscriptionId	Gets a server trust certificate that was uploaded from box to Sql Managed Instance.
create_or_update	INSERT	certificateName, managedInstanceName, resourceGroupName, subscriptionId	Uploads a server trust certificate from box to Sql Managed Instance.
delete	DELETE	certificateName, managedInstanceName, resourceGroupName, subscriptionId	Deletes a server trust certificate that was uploaded from box to Sql Managed Instance.

SELECT examples

Gets a server trust certificate that was uploaded from box to Sql Managed Instance.

vw_server_trust_certificates

SELECT
certificateName,
certificate_name,
managedInstanceName,
public_blob,
resourceGroupName,
subscriptionId,
thumbprint
FROM azure.sql.vw_server_trust_certificates
WHERE certificateName = '{{ certificateName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

server_trust_certificates

SELECT
properties
FROM azure.sql.server_trust_certificates
WHERE certificateName = '{{ certificateName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.server_trust_certificates (
certificateName,
managedInstanceName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ certificateName }}',
'{{ managedInstanceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: publicBlob
          value: string
        - name: thumbprint
          value: string
        - name: certificateName
          value: string

DELETE example

Deletes the specified server_trust_certificates resource.

/*+ delete */
DELETE FROM azure.sql.server_trust_certificates
WHERE certificateName = '{{ certificateName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';