Skip to main content

glossary

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

Overview

Nameglossary
TypeResource
Idazure.purview_data_map.glossary

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringThe name of the glossary object.
categoriesarrayAn array of categories.
classificationsarrayAn array of classifications.
createTimeintegerThe created time of the record.
createdBystringThe user who created the record.
guidstringThe GUID of the object.
languagestringThe language of the glossary.
lastModifiedTSstringETag for concurrency control.
longDescriptionstringThe long version description.
qualifiedNamestringThe qualified name of the glossary object.
shortDescriptionstringThe short version of description.
termsarrayAn array of related term headers.
updateTimeintegerThe update time of the record.
updatedBystringThe user who updated the record.
usagestringThe usage of the glossary.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectglossary_id, endpointGet a specific Glossary by its GUID.
get_categoryselectcategory_id, endpointGet specific glossary category by its GUID.
get_termselectterm_id, endpointGet a specific glossary term by its GUID.
createinsertendpointCreate a glossary.
updateupdateglossary_id, endpointignoreTermsAndCategoriesUpdate the given glossary.
deletedeleteglossary_id, endpointDelete a glossary. Will delete underlying terms/categories together. Recommend separate delete terms and categories.
update_categoryexeccategory_id, endpointUpdate the given glossary category by its GUID.
delete_categoryexeccategory_id, endpointDelete a glossary category.
get_related_categoriesexeccategory_id, endpointlimit, offset, sortGet all related categories (parent and children). Limit, offset, and sort parameters are currently not being enabled and won't work even they are passed.
get_category_termsexeccategory_id, endpointlimit, offset, sortGet all terms associated with the specific category.
update_termexecterm_id, endpointincludeTermHierarchyUpdate the given glossary term by its GUID.
get_entities_assigned_with_termexecterm_id, endpointlimit, offset, sortList all related objects assigned with the specified term. Recommend using limit/offset to get pagination result.
assign_term_to_entitiesexecterm_id, endpointAssign the given term to the provided list of related objects. Recommend using small batches with multiple API calls. Entities Create Or Update operation _ is an alternative to assign a term to multiple entities.
delete_term_assignment_from_entitiesexecterm_id, endpointDelete the term assignment for the given list of related objects.
get_related_termsexecterm_id, endpointlimit, offset, sortGet all related terms for a specific term by its GUID. Limit, offset, and sort parameters are currently not being enabled and won't work even they are passed.
get_categoriesexecglossary_id, endpointlimit, offset, sortGet the categories belonging to a specific glossary. Recommend using limit/offset to get pagination result.
get_categories_headersexecglossary_id, endpointlimit, offset, sortGet the category headers belonging to a specific glossary. Recommend using limit/offset to get pagination result.
get_detailedexecglossary_id, endpointGet a specific glossary with detailed information. This API is not recommend. Recommend to fetch terms/categories details separately using GET /datamap/api/atlas/v2/glossary/{glossaryId}/terms and GET /datamap/api/atlas/v2/glossary/{glossaryId}/categories.
get_termsexecglossary_id, endpointlimit, offset, sortGet terms belonging to a specific glossary. Recommend using limit/offset to get pagination result.
get_term_headersexecglossary_id, endpointlimit, offset, sortGet term headers belonging to a specific glossary. Recommend using limit/offset to get pagination result.
batch_getexecendpointlimit, offset, sort, ignoreTermsAndCategoriesGet all glossaries. Recommend using limit/offset to get pagination result. Recommend using 'ignoreTermsAndCategories=true' and fetch terms/categories separately using 'GET /datamap/api/atlas/v2/glossary/{glossaryId}/terms' and 'GET '/datamap/api/atlas/v2/glossary/{glossaryId}/categories'.
create_categoriesexecendpointCreate glossary category in bulk.
create_categoryexecendpointCreate a glossary category.
partial_update_categoryexeccategory_id, endpointUpdate the glossary category partially. So far we only supports partial updating shortDescription and longDescription for category.
create_termexecendpointincludeTermHierarchyCreate a glossary term.
delete_termexecterm_id, endpointDelete a glossary term.
partial_update_termexecterm_id, endpointincludeTermHierarchyUpdate the glossary term partially. So far we only supports partial updating shortDescription, longDescription, abbreviation, usage and status for term.
create_termsexecendpointincludeTermHierarchyCreate glossary terms in bulk.
partial_updateexecglossary_id, endpointignoreTermsAndCategoriesUpdate the glossary partially. Some properties such as qualifiedName are not allowed to be updated. So far we only supports partial updating shortDescription, longDescription, language and usage for glossary. Recommend using 'ignoreTermsAndCategories=true' to reduce response body size.

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
category_idstringThe globally unique identifier of the category. Required.
endpointstringThe service endpoint host (no scheme), e.g. myaccount.table.cosmos.azure.com:443 - value of the client endpoint parameter. (default: )
glossary_idstringThe globally unique identifier for glossary. Required.
term_idstringThe globally unique identifier for glossary term. Required.
ignoreTermsAndCategoriesbooleanWhether ignore terms and categories. Default value is None.
includeTermHierarchybooleanWhether include term hierarchy. Default value is None.
limitintegerThe page size - by default there is no paging. Default value is None.
offsetintegerThe offset for pagination purpose. Default value is None.
sortstringThe sort order, ASC (default) or DESC. Default value is None.

SELECT examples

Get a specific Glossary by its GUID.

SELECT
name,
categories,
classifications,
createTime,
createdBy,
guid,
language,
lastModifiedTS,
longDescription,
qualifiedName,
shortDescription,
terms,
updateTime,
updatedBy,
usage
FROM azure.purview_data_map.glossary
WHERE glossary_id = '{{ glossary_id }}' -- required
AND endpoint = '{{ endpoint }}' -- required
;

INSERT examples

Create a glossary.

INSERT INTO azure.purview_data_map.glossary (
guid,
classifications,
longDescription,
name,
qualifiedName,
shortDescription,
lastModifiedTS,
createTime,
createdBy,
updateTime,
updatedBy,
categories,
language,
terms,
usage,
endpoint
)
SELECT
'{{ guid }}',
'{{ classifications }}',
'{{ longDescription }}',
'{{ name }}',
'{{ qualifiedName }}',
'{{ shortDescription }}',
'{{ lastModifiedTS }}',
{{ createTime }},
'{{ createdBy }}',
{{ updateTime }},
'{{ updatedBy }}',
'{{ categories }}',
'{{ language }}',
'{{ terms }}',
'{{ usage }}',
'{{ endpoint }}'
RETURNING
name,
categories,
classifications,
createTime,
createdBy,
guid,
language,
lastModifiedTS,
longDescription,
qualifiedName,
shortDescription,
terms,
updateTime,
updatedBy,
usage
;

UPDATE examples

Update the given glossary.

UPDATE azure.purview_data_map.glossary
SET
guid = '{{ guid }}',
classifications = '{{ classifications }}',
longDescription = '{{ longDescription }}',
name = '{{ name }}',
qualifiedName = '{{ qualifiedName }}',
shortDescription = '{{ shortDescription }}',
lastModifiedTS = '{{ lastModifiedTS }}',
createTime = {{ createTime }},
createdBy = '{{ createdBy }}',
updateTime = {{ updateTime }},
updatedBy = '{{ updatedBy }}',
categories = '{{ categories }}',
language = '{{ language }}',
terms = '{{ terms }}',
usage = '{{ usage }}'
WHERE
glossary_id = '{{ glossary_id }}' --required
AND endpoint = '{{ endpoint }}' --required
AND ignoreTermsAndCategories = {{ ignoreTermsAndCategories}}
RETURNING
name,
categories,
classifications,
createTime,
createdBy,
guid,
language,
lastModifiedTS,
longDescription,
qualifiedName,
shortDescription,
terms,
updateTime,
updatedBy,
usage;

DELETE examples

Delete a glossary. Will delete underlying terms/categories together. Recommend separate delete terms and categories.

DELETE FROM azure.purview_data_map.glossary
WHERE glossary_id = '{{ glossary_id }}' --required
AND endpoint = '{{ endpoint }}' --required
;

Lifecycle Methods

Update the given glossary category by its GUID.

EXEC azure.purview_data_map.glossary.update_category 
@category_id='{{ category_id }}' --required,
@endpoint='{{ endpoint }}' --required
@@json=
'{
"guid": "{{ guid }}",
"classifications": "{{ classifications }}",
"longDescription": "{{ longDescription }}",
"name": "{{ name }}",
"qualifiedName": "{{ qualifiedName }}",
"shortDescription": "{{ shortDescription }}",
"lastModifiedTS": "{{ lastModifiedTS }}",
"createTime": {{ createTime }},
"createdBy": "{{ createdBy }}",
"updateTime": {{ updateTime }},
"updatedBy": "{{ updatedBy }}",
"anchor": "{{ anchor }}",
"childrenCategories": "{{ childrenCategories }}",
"parentCategory": "{{ parentCategory }}",
"terms": "{{ terms }}"
}'
;