Skip to main content

entity

Creates, updates, deletes, gets or lists an entity resource.

Overview

Nameentity
TypeResource
Idazure.purview_catalog.entity

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
create_or_updateinsertendpointCreate or update an entity in Atlas. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.
create_or_updatereplaceendpointCreate or update an entity in Atlas. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.
delete_by_guiddeleteguid, endpointDelete an entity identified by its GUID.
delete_by_unique_attributedeletetype_name, endpointattr:qualifiedNameDelete an entity identified by its type and unique attributes. In addition to the typeName path parameter, attribute key-value pair(s) can be provided in the following format: attr:=. NOTE: The attrName and attrValue should be unique across entities, eg. qualifiedName. The REST request would look something like this: DELETE /v2/entity/uniqueAttribute/type/aType?attr:aTypeAttribute=someValue.
delete_by_guidsdeleteendpointDelete a list of entities in bulk identified by their GUIDs or unique attributes.
list_by_guidsexecendpointminExtInfo, ignoreRelationshipsList entities in bulk identified by its GUIDs.
create_or_update_entitiesexecendpointCreate or update entities in Atlas in bulk. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.
get_by_guidexecguid, endpointminExtInfo, ignoreRelationshipsGet complete definition of an entity given its GUID.
partial_update_entity_attribute_by_guidexecguid, name, endpointUpdate entity partially - create or update entity attribute identified by its GUID. Supports only primitive attribute type and entity references. It does not support updating complex types like arrays, and maps. Null updates are not possible.
get_by_unique_attributesexectype_name, endpointminExtInfo, ignoreRelationships, attr:qualifiedNameGet complete definition of an entity given its type and unique attribute. In addition to the typeName path parameter, attribute key-value pair(s) can be provided in the following format: attr:=. NOTE: The attrName and attrValue should be unique across entities, eg. qualifiedName. The REST request would look something like this: GET /v2/entity/uniqueAttribute/type/aType?attr:aTypeAttribute=someValue.
partial_update_entity_by_unique_attributesexectype_name, endpointattr:qualifiedNameUpdate entity partially - Allow a subset of attributes to be updated on an entity which is identified by its type and unique attribute eg: Referenceable.qualifiedName. Null updates are not possible. In addition to the typeName path parameter, attribute key-value pair(s) can be provided in the following format: attr:=. NOTE: The attrName and attrValue should be unique across entities, eg. qualifiedName. The REST request would look something like this: PUT /v2/entity/uniqueAttribute/type/aType?attr:aTypeAttribute=someValue.
get_classificationexecguid, classification_name, endpointList classifications for a given entity represented by a GUID.
delete_classificationexecguid, classification_name, endpointDelete a given classification from an existing entity represented by a GUID.
get_classificationsexecguid, endpointList classifications for a given entity represented by a GUID.
add_classificationsexecguid, endpointAdd classifications to an existing entity represented by a GUID.
update_classificationsexecguid, endpointUpdate classifications to an existing entity represented by a guid.
get_entities_by_unique_attributesexectype_name, endpointminExtInfo, ignoreRelationships, attr_N:qualifiedNameBulk API to retrieve list of entities identified by its unique attributes. In addition to the typeName path parameter, attribute key-value pair(s) can be provided in the following format typeName=&attr_1:=&attr_2:=&attr_3:=\ NOTE: The attrName should be an unique attribute for the given entity-type The REST request would look something like this GET /v2/entity/bulk/uniqueAttribute/type/hive_db?attr_0:qualifiedName=db1@cl1&attr_2:qualifiedName=db2@cl1.
get_headerexecguid, endpointGet entity header given its GUID.
get_sample_business_metadata_templateexecendpointGet the sample Template for uploading/creating bulk BusinessMetaData.
add_classificationexecendpointAssociate a classification to multiple entities in bulk.
delete_classification_by_unique_attributeexectype_name, classification_name, endpointattr:qualifiedNameDelete a given classification from an entity identified by its type and unique attributes.
add_classifications_by_unique_attributeexectype_name, endpointattr:qualifiedNameAdd classification to the entity identified by its type and unique attributes.
update_classifications_by_unique_attributeexectype_name, endpointattr:qualifiedNameUpdate classification on an entity identified by its type and unique attributes.
set_classificationsexecendpointSet classifications on entities in bulk.
delete_business_metadataexecguid, endpointRemove business metadata from an entity.
add_or_update_business_metadataexecguid, endpointisOverwriteAdd business metadata to an entity.
delete_business_metadata_attributesexecbm_name, guid, endpointDelete business metadata attributes from an entity.
add_or_update_business_metadata_attributesexecbm_name, guid, endpointAdd or update business metadata attributes.
delete_labelsexecguid, endpointdelete given labels to a given entity.
set_labelsexecguid, endpointSet labels to a given entity.
add_labelexecguid, endpointadd given labels to a given entity.
delete_labels_by_unique_attributeexectype_name, endpointattr:qualifiedNameDelete given labels to a given entity identified by its type and unique attributes, if labels is null/empty, no labels will be removed. If any labels in labels set are non-existing labels, they will be ignored, only existing labels will be removed. In addition to the typeName path parameter, attribute key-value pair(s) can be provided in the following format: attr:=. NOTE: The attrName and attrValue should be unique across entities, eg. qualifiedName. The REST request would look something like this: DELETE /v2/entity/uniqueAttribute/type/aType?attr:aTypeAttribute=someValue.
set_labels_by_unique_attributeexectype_name, endpointattr:qualifiedNameSet labels to a given entity identified by its type and unique attributes, if labels is null/empty, existing labels will all be removed. In addition to the typeName path parameter, attribute key-value pair(s) can be provided in the following format: attr:=. NOTE: The attrName and attrValue should be unique across entities, eg. qualifiedName. The REST request would look something like this: POST /v2/entity/uniqueAttribute/type/aType?attr:aTypeAttribute=someValue.
add_labels_by_unique_attributeexectype_name, endpointattr:qualifiedNameAdd given labels to a given entity identified by its type and unique attributes, if labels is null/empty, no labels will be added. In addition to the typeName path parameter, attribute key-value pair(s) can be provided in the following format: attr:=. NOTE: The attrName and attrValue should be unique across entities, eg. qualifiedName. The REST request would look something like this: PUT /v2/entity/uniqueAttribute/type/aType?attr:aTypeAttribute=someValue.

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
bm_namestringBusinessMetadata name.
classification_namestringThe name of the classification.
endpointstringThe service endpoint host (no scheme). (default: )
guidstringThe globally unique identifier of the entity.
namestringThe name of the attribute.
type_namestringThe name of the type.
attr:qualifiedNamestringThe qualified name of the entity. Default value is None.
attr_N:qualifiedNamestringQualified name of an entity. E.g. to find 2 entities you can set attrs_0:qualifiedName=db1@cl1&attrs_2:qualifiedName=db2@cl1. Default value is None.
ignoreRelationshipsbooleanWhether to ignore relationship attributes. Default value is False.
isOverwritebooleanWhether to overwrite the existing business metadata on the entity or not, default is false.
minExtInfobooleanWhether to return minimal information for referred entities. Default value is False.

INSERT examples

Create or update an entity in Atlas. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.

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

REPLACE examples

Create or update an entity in Atlas. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.

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

DELETE examples

Delete an entity identified by its GUID.

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

Lifecycle Methods

List entities in bulk identified by its GUIDs.

EXEC azure.purview_catalog.entity.list_by_guids 
@endpoint='{{ endpoint }}' --required,
@minExtInfo={{ minExtInfo }},
@ignoreRelationships={{ ignoreRelationships }}
;