Skip to main content

relationship

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

Overview

Namerelationship
TypeResource
Idazure.purview_catalog.relationship

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
createinsertendpointCreate a new relationship between entities.
updateupdateendpointUpdate an existing relationship between entities.
deletedeleteguid, endpointDelete a relationship between entities by its GUID.
get_rawexecguid, endpointextendedInfoGet relationship information between entities by its GUID.

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
endpointstringThe service endpoint host (no scheme). (default: )
guidstringThe globally unique identifier of the relationship.
extendedInfobooleanLimits whether includes extended information. Default value is None.

INSERT examples

Create a new relationship between entities.

INSERT INTO azure.purview_catalog.relationship (
endpoint
)
SELECT
'{{ endpoint }}'
;

UPDATE examples

Update an existing relationship between entities.

UPDATE azure.purview_catalog.relationship
SET
-- No updatable properties
WHERE
endpoint = '{{ endpoint }}' --required;

DELETE examples

Delete a relationship between entities by its GUID.

DELETE FROM azure.purview_catalog.relationship
WHERE guid = '{{ guid }}' --required
AND endpoint = '{{ endpoint }}' --required
;

Lifecycle Methods

Get relationship information between entities by its GUID.

EXEC azure.purview_catalog.relationship.get_raw 
@guid='{{ guid }}' --required,
@endpoint='{{ endpoint }}' --required,
@extendedInfo={{ extendedInfo }}
;