Skip to main content

dras

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

Overview

Namedras
TypeResource
Idazure.data_replication.dras

Fields

NameDatatypeDescription
idtextGets or sets the Id of the resource.
nametextGets or sets the name of the resource.
authentication_identitytextfield from the properties object
correlation_idtextfield from the properties object
custom_propertiestextfield from the properties object
fabricAgentNametextfield from the properties object
fabricNametextfield from the properties object
health_errorstextfield from the properties object
is_responsivetextfield from the properties object
last_heartbeattextfield from the properties object
machine_idtextfield from the properties object
machine_nametextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
resource_access_identitytextfield from the properties object
subscriptionIdtextfield from the properties object
system_datatextfield from the properties object
typetextGets or sets the type of the resource.
version_numbertextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTfabricAgentName, fabricName, resourceGroupName, subscriptionIdGets the details of the fabric agent.
listSELECTfabricName, resourceGroupName, subscriptionIdGets the list of fabric agents in the given fabric.
createINSERTfabricAgentName, fabricName, resourceGroupName, subscriptionId, data__propertiesCreates the fabric agent.
deleteDELETEfabricAgentName, fabricName, resourceGroupName, subscriptionIdDeletes the fabric agent.

SELECT examples

Gets the list of fabric agents in the given fabric.

SELECT
id,
name,
authentication_identity,
correlation_id,
custom_properties,
fabricAgentName,
fabricName,
health_errors,
is_responsive,
last_heartbeat,
machine_id,
machine_name,
provisioning_state,
resourceGroupName,
resource_access_identity,
subscriptionId,
system_data,
type,
version_number
FROM azure.data_replication.vw_dras
WHERE fabricName = '{{ fabricName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.data_replication.dras (
fabricAgentName,
fabricName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT
'{{ fabricAgentName }}',
'{{ fabricName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

DELETE example

Deletes the specified dras resource.

/*+ delete */
DELETE FROM azure.data_replication.dras
WHERE fabricAgentName = '{{ fabricAgentName }}'
AND fabricName = '{{ fabricName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';