Skip to main content

private_endpoint_connections

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

Overview

Nameprivate_endpoint_connections
TypeResource
Idazure.postgresql_hsc.private_endpoint_connections

Fields

The following fields are returned by SELECT queries:

Successfully retrieved a specified private endpoint connection.

NameDatatypeDescription
idstring (arm-id)Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
namestringThe name of the resource
propertiesobjectResource properties.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, clusterName, privateEndpointConnectionNameGets private endpoint connection.
list_by_clusterselectsubscriptionId, resourceGroupName, clusterNameGets list of private endpoint connections on a cluster.
create_or_updateinsertsubscriptionId, resourceGroupName, clusterName, privateEndpointConnectionNameApproves or Rejects a private endpoint connection with a given name.
deletedeletesubscriptionId, resourceGroupName, clusterName, privateEndpointConnectionNameDeletes a private endpoint connection with a given name.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
clusterNamestringThe name of the cluster.
privateEndpointConnectionNamestringThe name of the private endpoint connection associated with the cluster.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Gets private endpoint connection.

SELECT
id,
name,
properties,
systemData,
type
FROM azure.postgresql_hsc.private_endpoint_connections
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND clusterName = '{{ clusterName }}' -- required
AND privateEndpointConnectionName = '{{ privateEndpointConnectionName }}' -- required
;

INSERT examples

Approves or Rejects a private endpoint connection with a given name.

INSERT INTO azure.postgresql_hsc.private_endpoint_connections (
data__properties,
subscriptionId,
resourceGroupName,
clusterName,
privateEndpointConnectionName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ clusterName }}',
'{{ privateEndpointConnectionName }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Deletes a private endpoint connection with a given name.

DELETE FROM azure.postgresql_hsc.private_endpoint_connections
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND clusterName = '{{ clusterName }}' --required
AND privateEndpointConnectionName = '{{ privateEndpointConnectionName }}' --required
;