Skip to main content

glossaries

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

Overview

Nameglossaries
TypeResource
Idaws.glue.glossaries

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
descriptionstringThe description of the glossary.
idstringThe unique identifier of the glossary.
namestringThe name of the glossary.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_glossaryselectregionRetrieves a business glossary in Glue Data Catalog by its identifier.
list_glossariesselectregionLists business glossaries in Glue Data Catalog.
create_glossaryinsertregionCreates a business glossary in Glue Data Catalog. A glossary is a container for glossary terms that define business concepts.
update_glossaryupdateregion, IdentifierUpdates a business glossary in Glue Data Catalog.
delete_glossarydeleteregionDeletes a business glossary from Glue Data Catalog. A glossary cannot be deleted if it still contains glossary terms.

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 business glossary in Glue Data Catalog by its identifier.

SELECT
description,
id,
name
FROM aws.glue.glossaries
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a business glossary in Glue Data Catalog. A glossary is a container for glossary terms that define business concepts.

INSERT INTO aws.glue.glossaries (
Name,
Description,
ClientToken,
region
)
SELECT
'{{ Name }}',
'{{ Description }}',
'{{ ClientToken }}',
'{{ region }}'
RETURNING
description,
id,
name
;

UPDATE examples

Updates a business glossary in Glue Data Catalog.

UPDATE aws.glue.glossaries
SET
Identifier = '{{ Identifier }}',
Name = '{{ Name }}',
Description = '{{ Description }}',
ClientToken = '{{ ClientToken }}'
WHERE
region = '{{ region }}' --required
AND Identifier = '{{ Identifier }}' --required
RETURNING
description,
id,
name;

DELETE examples

Deletes a business glossary from Glue Data Catalog. A glossary cannot be deleted if it still contains glossary terms.

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