Skip to main content

glossary_terms

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

Overview

Nameglossary_terms
TypeResource
Idaws.glue.glossary_terms

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
glossary_idstringThe unique identifier of the glossary containing this term.
idstringThe unique identifier of the glossary term.
long_descriptionstringThe long description of the glossary term.
namestringThe name of the glossary term.
short_descriptionstringThe short description of the glossary term.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_glossary_termselectregionRetrieves a glossary term in Glue Data Catalog by its identifier.
list_glossary_termsselectregionLists glossary terms within a business glossary in Glue Data Catalog.
create_glossary_terminsertregion, GlossaryIdentifierCreates a glossary term within a business glossary in Glue Data Catalog.
associate_glossary_termsupdateregion, AssetIdentifier, GlossaryTermIdentifiersAssociates one or more glossary terms with an asset in Glue Data Catalog.
update_glossary_termupdateregion, IdentifierUpdates a glossary term in Glue Data Catalog.
delete_glossary_termdeleteregionDeletes a glossary term from Glue Data Catalog.
disassociate_glossary_termsexecregion, AssetIdentifier, GlossaryTermIdentifiersRemoves the association of one or more glossary terms from an asset in Glue Data Catalog.

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
regionstringAWS region (default: us-east-1)

SELECT examples

Retrieves a glossary term in Glue Data Catalog by its identifier.

SELECT
glossary_id,
id,
long_description,
name,
short_description
FROM aws.glue.glossary_terms
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a glossary term within a business glossary in Glue Data Catalog.

INSERT INTO aws.glue.glossary_terms (
GlossaryIdentifier,
Name,
ShortDescription,
LongDescription,
ClientToken,
region
)
SELECT
'{{ GlossaryIdentifier }}' /* required */,
'{{ Name }}',
'{{ ShortDescription }}',
'{{ LongDescription }}',
'{{ ClientToken }}',
'{{ region }}'
RETURNING
glossary_id,
id,
long_description,
name,
short_description
;

UPDATE examples

Associates one or more glossary terms with an asset in Glue Data Catalog.

UPDATE aws.glue.glossary_terms
SET
AssetIdentifier = '{{ AssetIdentifier }}',
IterableFormName = '{{ IterableFormName }}',
ItemIdentifier = '{{ ItemIdentifier }}',
GlossaryTermIdentifiers = '{{ GlossaryTermIdentifiers }}',
ClientToken = '{{ ClientToken }}'
WHERE
region = '{{ region }}' --required
AND AssetIdentifier = '{{ AssetIdentifier }}' --required
AND GlossaryTermIdentifiers = '{{ GlossaryTermIdentifiers }}' --required
RETURNING
asset_identifier,
glossary_terms,
item_identifier,
iterable_form_name;

DELETE examples

Deletes a glossary term from Glue Data Catalog.

DELETE FROM aws.glue.glossary_terms
WHERE region = '{{ region }}' --required
;

Lifecycle Methods

Removes the association of one or more glossary terms from an asset in Glue Data Catalog.

EXEC aws.glue.glossary_terms.disassociate_glossary_terms
@region='{{ region }}' --required
@@json=
'{
"AssetIdentifier": "{{ AssetIdentifier }}",
"IterableFormName": "{{ IterableFormName }}",
"ItemIdentifier": "{{ ItemIdentifier }}",
"GlossaryTermIdentifiers": "{{ GlossaryTermIdentifiers }}",
"ClientToken": "{{ ClientToken }}"
}'
;