Skip to main content

table_versions

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

Overview

Nametable_versions
TypeResource
Idaws.glue.table_versions

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
tableobjectThe table in question.
version_idstringThe ID value that identifies this table version. A VersionId is a string representation of an integer. Each version is incremented by 1. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*</code>)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_table_versionselectregionRetrieves a specified version of a table.
delete_table_versiondeleteregionDeletes a specified version of a table.
get_table_versionsexecregion, DatabaseName, TableNameRetrieves a list of strings that identify available versions of a specified table.

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 specified version of a table.

SELECT
table,
version_id
FROM aws.glue.table_versions
WHERE region = '{{ region }}' -- required
;

DELETE examples

Deletes a specified version of a table.

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

Lifecycle Methods

Retrieves a list of strings that identify available versions of a specified table.

EXEC aws.glue.table_versions.get_table_versions
@region='{{ region }}' --required
@@json=
'{
"CatalogId": "{{ CatalogId }}",
"DatabaseName": "{{ DatabaseName }}",
"TableName": "{{ TableName }}",
"NextToken": "{{ NextToken }}",
"MaxResults": {{ MaxResults }},
"AuditContext": "{{ AuditContext }}"
}'
;