shared_private_link_resources

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

Overview

Name	shared_private_link_resources
Type	Resource
Id	azure.db_watcher.shared_private_link_resources

Fields

vw_shared_private_link_resources

Name	Datatype	Description
dns_zone	text	field from the properties object
group_id	text	field from the properties object
private_link_resource_id	text	field from the properties object
provisioning_state	text	field from the properties object
request_message	text	field from the properties object
resourceGroupName	text	field from the properties object
sharedPrivateLinkResourceName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
watcherName	text	field from the properties object

shared_private_link_resources

Name	Datatype	Description
properties	object	The generic properties of a Shared Private Link resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sharedPrivateLinkResourceName, subscriptionId, watcherName	Get a SharedPrivateLinkResource
list_by_watcher	SELECT	resourceGroupName, subscriptionId, watcherName	List SharedPrivateLinkResource resources by Watcher
create	INSERT	resourceGroupName, sharedPrivateLinkResourceName, subscriptionId, watcherName	Create a SharedPrivateLinkResource
delete	DELETE	resourceGroupName, sharedPrivateLinkResourceName, subscriptionId, watcherName	Delete a SharedPrivateLinkResource

SELECT examples

List SharedPrivateLinkResource resources by Watcher

vw_shared_private_link_resources

SELECT
dns_zone,
group_id,
private_link_resource_id,
provisioning_state,
request_message,
resourceGroupName,
sharedPrivateLinkResourceName,
status,
subscriptionId,
watcherName
FROM azure.db_watcher.vw_shared_private_link_resources
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND watcherName = '{{ watcherName }}';

shared_private_link_resources

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.db_watcher.shared_private_link_resources (
resourceGroupName,
sharedPrivateLinkResourceName,
subscriptionId,
watcherName,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ sharedPrivateLinkResourceName }}',
'{{ subscriptionId }}',
'{{ watcherName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: privateLinkResourceId
          value: string
        - name: groupId
          value: string
        - name: requestMessage
          value: string
        - name: dnsZone
          value: string
        - name: status
          value: []
        - name: provisioningState
          value: []

DELETE example

Deletes the specified shared_private_link_resources resource.

/*+ delete */
DELETE FROM azure.db_watcher.shared_private_link_resources
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sharedPrivateLinkResourceName = '{{ sharedPrivateLinkResourceName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND watcherName = '{{ watcherName }}';