AWS Glue
Web API Reference (API Version 2017-03-31)

Table

Represents a collection of related data organized in columns and rows.

Contents

CreatedBy

Person or entity who created the table.

Type: String

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

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

Required: No

CreateTime

Time when the table definition was created in the Data Catalog.

Type: Timestamp

Required: No

DatabaseName

Name of the metadata database where the table metadata resides. For Hive compatibility, this must be all lowercase.

Type: String

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

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

Required: No

Description

Description of the table.

Type: String

Length Constraints: Minimum length of 0. Maximum length of 2048.

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

Required: No

LastAccessTime

Last time the table was accessed. This is usually taken from HDFS, and may not be reliable.

Type: Timestamp

Required: No

LastAnalyzedTime

Last time column statistics were computed for this table.

Type: Timestamp

Required: No

Name

Name of the table. For Hive compatibility, this must be 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

Owner

Owner of the table.

Type: String

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

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

Required: No

Parameters

These key-value pairs define properties associated with the table.

Type: String to string map

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

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

Value Length Constraints: Maximum length of 512000.

Required: No

PartitionKeys

A list of columns by which the table is partitioned. Only primitive types are supported as partition keys.

When programmatically creating a view of the table, and you do not intend to specify any partitionKeys, you must set the value of partitionKeys to an empty list. For example:

"PartitionKeys": []

Type: Array of Column objects

Required: No

Retention

Retention time for this table.

Type: Integer

Valid Range: Minimum value of 0.

Required: No

StorageDescriptor

A storage descriptor containing information about the physical storage of this table.

Type: StorageDescriptor object

Required: No

TableType

The type of this table (EXTERNAL_TABLE, VIRTUAL_VIEW, etc.).

Type: String

Length Constraints: Maximum length of 255.

Required: No

UpdateTime

Last time the table was updated.

Type: Timestamp

Required: No

ViewExpandedText

If the table is a view, the expanded text of the view; otherwise null.

Type: String

Length Constraints: Maximum length of 409600.

Required: No

ViewOriginalText

If the table is a view, the original text of the view; otherwise null.

Type: String

Length Constraints: Maximum length of 409600.

Required: No

See Also

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

On this page: