Skip to main content

shared_private_link_resources

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

Overview

Nameshared_private_link_resources
TypeResource
Idazure.db_watcher.shared_private_link_resources

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
propertiesobjectThe resource-specific properties for this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, watcherName, sharedPrivateLinkResourceNameGet a SharedPrivateLinkResource
list_by_watcherselectsubscriptionId, resourceGroupName, watcherNameList SharedPrivateLinkResource resources by Watcher
createinsertsubscriptionId, resourceGroupName, watcherName, sharedPrivateLinkResourceNameCreate a SharedPrivateLinkResource
deletedeletesubscriptionId, resourceGroupName, watcherName, sharedPrivateLinkResourceNameDelete a SharedPrivateLinkResource

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
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
sharedPrivateLinkResourceNamestringThe Shared Private Link resource name.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
watcherNamestringThe database watcher name.

SELECT examples

Get a SharedPrivateLinkResource

SELECT
properties
FROM azure.db_watcher.shared_private_link_resources
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND watcherName = '{{ watcherName }}' -- required
AND sharedPrivateLinkResourceName = '{{ sharedPrivateLinkResourceName }}' -- required
;

INSERT examples

Create a SharedPrivateLinkResource

INSERT INTO azure.db_watcher.shared_private_link_resources (
data__properties,
subscriptionId,
resourceGroupName,
watcherName,
sharedPrivateLinkResourceName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ watcherName }}',
'{{ sharedPrivateLinkResourceName }}'
RETURNING
properties
;

DELETE examples

Delete a SharedPrivateLinkResource

DELETE FROM azure.db_watcher.shared_private_link_resources
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND watcherName = '{{ watcherName }}' --required
AND sharedPrivateLinkResourceName = '{{ sharedPrivateLinkResourceName }}' --required
;