targets

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

Overview

Name	targets
Type	Resource
Id	azure.db_watcher.targets

Fields

The following fields are returned by SELECT queries:

get

Azure operation completed successfully.

Name	Datatype	Description
properties	object	The resource-specific properties for this resource.

list_by_watcher

Azure operation completed successfully.

Name	Datatype	Description
properties	object	The resource-specific properties for this resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, watcherName, targetName		Get a Target
list_by_watcher	select	subscriptionId, resourceGroupName, watcherName		List Target resources by Watcher
create_or_update	insert	subscriptionId, resourceGroupName, watcherName, targetName		Create a Target
delete	delete	subscriptionId, resourceGroupName, watcherName, targetName		Delete a Target

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.

Name	Datatype	Description
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.
targetName	string	The target resource name.
watcherName	string	The database watcher name.

SELECT examples

get

Get a Target

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

list_by_watcher

List Target resources by Watcher

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

INSERT examples

create_or_update

Create a Target

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

Manifest

# Description fields are for documentation purposes
- name: targets
  props:
    - name: subscriptionId
      value: string (uuid)
      description: Required parameter for the targets resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the targets resource.
    - name: watcherName
      value: string
      description: Required parameter for the targets resource.
    - name: targetName
      value: string
      description: Required parameter for the targets resource.
    - name: properties
      value: object
      description: |
        The resource-specific properties for this resource.

DELETE examples

delete

Delete a Target

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