TableInput
A structure used to define a table.
Contents
- Name
-
The table name. For Hive compatibility, this is folded to lowercase when it is stored.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 255.
Pattern:
[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*
Required: Yes
- Description
-
A 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
-
The last time that the table was accessed.
Type: Timestamp
Required: No
- LastAnalyzedTime
-
The last time that column statistics were computed for this table.
Type: Timestamp
Required: No
- Owner
-
The table owner. Included for Apache Hive compatibility. Not used in the normal course of AWS Glue operations.
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 you create a table used by Amazon Athena, and you do not specify any
partitionKeys
, you must at least set the value ofpartitionKeys
to an empty list. For example:"PartitionKeys": []
Type: Array of Column objects
Required: No
- Retention
-
The 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. AWS Glue will create tables with the
EXTERNAL_TABLE
type. Other services, such as Athena, may create tables with additional table types.AWS Glue related table types:
- EXTERNAL_TABLE
-
Hive compatible attribute - indicates a non-Hive managed table.
- GOVERNED
-
Used by AWS Lake Formation. The AWS Glue Data Catalog understands
GOVERNED
.
Type: String
Length Constraints: Maximum length of 255.
Required: No
- TargetTable
-
A
TableIdentifier
structure that describes a target table for resource linking.Type: TableIdentifier object
Required: No
- ViewDefinition
-
A structure that contains all the information that defines the view, including the dialect or dialects for the view, and the query.
Type: ViewDefinitionInput object
Required: No
- ViewExpandedText
-
Included for Apache Hive compatibility. Not used in the normal course of AWS Glue operations.
Type: String
Length Constraints: Maximum length of 409600.
Required: No
- ViewOriginalText
-
Included for Apache Hive compatibility. Not used in the normal course of AWS Glue operations. If the table is a
VIRTUAL_VIEW
, certain Athena configuration encoded in base64.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: