managed_instance_private_endpoint_connections

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

Overview

Name	managed_instance_private_endpoint_connections
Type	Resource
Id	azure.sql.managed_instance_private_endpoint_connections

Fields

vw_managed_instance_private_endpoint_connections

Name	Datatype	Description
managedInstanceName	text	field from the properties object
privateEndpointConnectionName	text	field from the properties object
private_endpoint	text	field from the properties object
private_link_service_connection_state	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

managed_instance_private_endpoint_connections

Name	Datatype	Description
properties	object	Properties of a private endpoint connection.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	managedInstanceName, privateEndpointConnectionName, resourceGroupName, subscriptionId	Gets a private endpoint connection.
create_or_update	INSERT	managedInstanceName, privateEndpointConnectionName, resourceGroupName, subscriptionId	Approve or reject a private endpoint connection with a given name.
delete	DELETE	managedInstanceName, privateEndpointConnectionName, resourceGroupName, subscriptionId	Deletes a private endpoint connection with a given name.

SELECT examples

Gets a private endpoint connection.

vw_managed_instance_private_endpoint_connections

SELECT
managedInstanceName,
privateEndpointConnectionName,
private_endpoint,
private_link_service_connection_state,
provisioning_state,
resourceGroupName,
subscriptionId
FROM azure.sql.vw_managed_instance_private_endpoint_connections
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND privateEndpointConnectionName = '{{ privateEndpointConnectionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_instance_private_endpoint_connections

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: privateEndpoint
          value:
            - name: id
              value: string
        - name: privateLinkServiceConnectionState
          value:
            - name: status
              value: string
            - name: description
              value: string
            - name: actionsRequired
              value: string
        - name: provisioningState
          value: string

DELETE example

Deletes the specified managed_instance_private_endpoint_connections resource.

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