Skip to main content

dependency_of_relationships

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

Overview

Namedependency_of_relationships
TypeResource
Idazure.relationships.dependency_of_relationships

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
metadataobjectMetadata about the relationship. Required.
originInformationobjectInformation about the origin of the relationship. Required.
provisioningStatestringThe provisioning state of the relationship. Known values are: "Succeeded", "Failed", "Canceled", "Provisioning", "Updating", "Deleting", and "Accepted". (Succeeded, Failed, Canceled, Provisioning, Updating, Deleting, Accepted)
sourceIdstringThe relationship source resource id. Required.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
targetIdstringThe relationship target resource id. Required.
targetTenantstringThe relationship target tenant id.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_uri, nameGet a DependencyOfRelationship.
create_or_updateinsertresource_uri, nameCreate a DependencyOfRelationship.
create_or_updatereplaceresource_uri, nameCreate a DependencyOfRelationship.
deletedeleteresource_uri, nameDelete a DependencyOfRelationship.

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
namestringName of dependencyOf relationship. Required.
resource_uristringThe fully qualified Azure Resource manager identifier of the resource. Required.

SELECT examples

Get a DependencyOfRelationship.

SELECT
id,
name,
metadata,
originInformation,
provisioningState,
sourceId,
systemData,
targetId,
targetTenant,
type
FROM azure.relationships.dependency_of_relationships
WHERE resource_uri = '{{ resource_uri }}' -- required
AND name = '{{ name }}' -- required
;

INSERT examples

Create a DependencyOfRelationship.

INSERT INTO azure.relationships.dependency_of_relationships (
properties,
resource_uri,
name
)
SELECT
'{{ properties }}',
'{{ resource_uri }}',
'{{ name }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Create a DependencyOfRelationship.

REPLACE azure.relationships.dependency_of_relationships
SET
properties = '{{ properties }}'
WHERE
resource_uri = '{{ resource_uri }}' --required
AND name = '{{ name }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Delete a DependencyOfRelationship.

DELETE FROM azure.relationships.dependency_of_relationships
WHERE resource_uri = '{{ resource_uri }}' --required
AND name = '{{ name }}' --required
;