Skip to main content

fabrics

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

Overview

Namefabrics
TypeResource
Idazure.data_replication.fabrics

Fields

NameDatatypeDescription
idtextGets or sets the Id of the resource.
nametextGets or sets the name of the resource.
custom_propertiestextfield from the properties object
fabricNametextfield from the properties object
healthtextfield from the properties object
health_errorstextfield from the properties object
locationtextGets or sets the location of the fabric.
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
service_endpointtextfield from the properties object
service_resource_idtextfield from the properties object
subscriptionIdtextfield from the properties object
system_datatextfield from the properties object
tagstextGets or sets the resource tags.
typetextGets or sets the type of the resource.

Methods

NameAccessible byRequired ParamsDescription
getSELECTfabricName, resourceGroupName, subscriptionIdGets the details of the fabric.
listSELECTresourceGroupName, subscriptionIdGets the list of fabrics in the given subscription and resource group.
list_by_subscriptionSELECTsubscriptionIdGets the list of fabrics in the given subscription.
createINSERTfabricName, resourceGroupName, subscriptionId, data__location, data__propertiesCreates the fabric.
deleteDELETEfabricName, resourceGroupName, subscriptionIdRemoves the fabric.
updateUPDATEfabricName, resourceGroupName, subscriptionIdPerforms update on the fabric.

SELECT examples

Gets the list of fabrics in the given subscription.

SELECT
id,
name,
custom_properties,
fabricName,
health,
health_errors,
location,
provisioning_state,
resourceGroupName,
service_endpoint,
service_resource_id,
subscriptionId,
system_data,
tags,
type
FROM azure.data_replication.vw_fabrics
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.data_replication.fabrics (
fabricName,
resourceGroupName,
subscriptionId,
data__location,
data__properties,
location,
tags,
properties
)
SELECT
'{{ fabricName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__location }}',
'{{ data__properties }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}'
;

UPDATE example

Updates a fabrics resource.

/*+ update */
UPDATE azure.data_replication.fabrics
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
fabricName = '{{ fabricName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified fabrics resource.

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