GetTable - AWS Glue

GetTable

Retrieves the Table definition in a Data Catalog for a specified table.

Request Syntax

{ "CatalogId": "string", "DatabaseName": "string", "IncludeStatusDetails": boolean, "Name": "string", "QueryAsOfTime": number, "TransactionId": "string" }

Request Parameters

For information about the parameters that are common to all actions, see Common Parameters.

The request accepts the following data in JSON format.

CatalogId

The ID of the Data Catalog where the table resides. If none is provided, the AWS account ID is used by default.

Type: String

Length Constraints: Minimum length of 1. Maximum length of 255.

Pattern: [\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*

Required: No

DatabaseName

The name of the database in the catalog in which the table resides. For Hive compatibility, this name is entirely lowercase.

Type: String

Length Constraints: Minimum length of 1. Maximum length of 255.

Pattern: [\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*

Required: Yes

IncludeStatusDetails

Specifies whether to include status details related to a request to create or update an AWS Glue Data Catalog view.

Type: Boolean

Required: No

Name

The name of the table for which to retrieve the definition. For Hive compatibility, this name is entirely lowercase.

Type: String

Length Constraints: Minimum length of 1. Maximum length of 255.

Pattern: [\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*

Required: Yes

QueryAsOfTime

The time as of when to read the table contents. If not set, the most recent transaction commit time will be used. Cannot be specified along with TransactionId.

Type: Timestamp

Required: No

TransactionId

The transaction ID at which to read the table contents.

Type: String

Length Constraints: Minimum length of 1. Maximum length of 255.

Pattern: [\p{L}\p{N}\p{P}]*

Required: No

Response Syntax

{ "Table": { "CatalogId": "string", "CreatedBy": "string", "CreateTime": number, "DatabaseName": "string", "Description": "string", "FederatedTable": { "ConnectionName": "string", "DatabaseIdentifier": "string", "Identifier": "string" }, "IsMultiDialectView": boolean, "IsRegisteredWithLakeFormation": boolean, "LastAccessTime": number, "LastAnalyzedTime": number, "Name": "string", "Owner": "string", "Parameters": { "string" : "string" }, "PartitionKeys": [ { "Comment": "string", "Name": "string", "Parameters": { "string" : "string" }, "Type": "string" } ], "Retention": number, "Status": { "Action": "string", "Details": { "RequestedChange": "Table", "ViewValidations": [ { "Dialect": "string", "DialectVersion": "string", "Error": { "ErrorCode": "string", "ErrorMessage": "string" }, "State": "string", "UpdateTime": number, "ViewValidationText": "string" } ] }, "Error": { "ErrorCode": "string", "ErrorMessage": "string" }, "RequestedBy": "string", "RequestTime": number, "State": "string", "UpdatedBy": "string", "UpdateTime": number }, "StorageDescriptor": { "AdditionalLocations": [ "string" ], "BucketColumns": [ "string" ], "Columns": [ { "Comment": "string", "Name": "string", "Parameters": { "string" : "string" }, "Type": "string" } ], "Compressed": boolean, "InputFormat": "string", "Location": "string", "NumberOfBuckets": number, "OutputFormat": "string", "Parameters": { "string" : "string" }, "SchemaReference": { "SchemaId": { "RegistryName": "string", "SchemaArn": "string", "SchemaName": "string" }, "SchemaVersionId": "string", "SchemaVersionNumber": number }, "SerdeInfo": { "Name": "string", "Parameters": { "string" : "string" }, "SerializationLibrary": "string" }, "SkewedInfo": { "SkewedColumnNames": [ "string" ], "SkewedColumnValueLocationMaps": { "string" : "string" }, "SkewedColumnValues": [ "string" ] }, "SortColumns": [ { "Column": "string", "SortOrder": number } ], "StoredAsSubDirectories": boolean }, "TableType": "string", "TargetTable": { "CatalogId": "string", "DatabaseName": "string", "Name": "string", "Region": "string" }, "UpdateTime": number, "VersionId": "string", "ViewDefinition": { "Definer": "string", "IsProtected": boolean, "Representations": [ { "Dialect": "string", "DialectVersion": "string", "IsStale": boolean, "ValidationConnection": "string", "ViewExpandedText": "string", "ViewOriginalText": "string" } ], "SubObjects": [ "string" ] }, "ViewExpandedText": "string", "ViewOriginalText": "string" } }

Response Elements

If the action is successful, the service sends back an HTTP 200 response.

The following data is returned in JSON format by the service.

Table

The Table object that defines the specified table.

Type: Table object

Errors

For information about the errors that are common to all actions, see Common Errors.

EntityNotFoundException

A specified entity does not exist

HTTP Status Code: 400

FederationSourceException

A federation source failed.

HTTP Status Code: 400

FederationSourceRetryableException

A federation source failed, but the operation may be retried.

HTTP Status Code: 400

GlueEncryptionException

An encryption operation failed.

HTTP Status Code: 400

InternalServiceException

An internal service error occurred.

HTTP Status Code: 500

InvalidInputException

The input provided was not valid.

HTTP Status Code: 400

OperationTimeoutException

The operation timed out.

HTTP Status Code: 400

ResourceNotReadyException

A resource was not ready for a transaction.

HTTP Status Code: 400

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following: