# CreateTable
Creates a new table definition in the Data Catalog.
## Request Syntax
```
{
"CatalogId": "string",
"DatabaseName": "string",
"Name": "string",
"OpenTableFormatInput": {
"IcebergInput": {
"CreateIcebergTableInput": {
"Location": "string",
"PartitionSpec": {
"Fields": [
{
"FieldId": number,
"Name": "string",
"SourceId": number,
"Transform": "string"
}
],
"SpecId": number
},
"Properties": {
"string" : "string"
},
"Schema": {
"Fields": [
{
"Doc": "string",
"Id": number,
"InitialDefault": JSON value,
"Name": "string",
"Required": boolean,
"Type": JSON value,
"WriteDefault": JSON value
}
],
"IdentifierFieldIds": [ number ],
"SchemaId": number,
"Type": "string"
},
"WriteOrder": {
"Fields": [
{
"Direction": "string",
"NullOrder": "string",
"SourceId": number,
"Transform": "string"
}
],
"OrderId": number
}
},
"MetadataOperation": "string",
"Version": "string"
}
},
"PartitionIndexes": [
{
"IndexName": "string",
"Keys": [ "string" ]
}
],
"TableInput": {
"Description": "string",
"LastAccessTime": number,
"LastAnalyzedTime": number,
"Name": "string",
"Owner": "string",
"Parameters": {
"string" : "string"
},
"PartitionKeys": [
{
"Comment": "string",
"Name": "string",
"Parameters": {
"string" : "string"
},
"Type": "string"
}
],
"Retention": 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"
},
"ViewDefinition": {
"Definer": "string",
"IsProtected": boolean,
"LastRefreshType": "string",
"RefreshSeconds": number,
"Representations": [
{
"Dialect": "string",
"DialectVersion": "string",
"ValidationConnection": "string",
"ViewExpandedText": "string",
"ViewOriginalText": "string"
}
],
"SubObjects": [ "string" ],
"SubObjectVersionIds": [ number ],
"ViewVersionId": number,
"ViewVersionToken": "string"
},
"ViewExpandedText": "string",
"ViewOriginalText": "string"
},
"TransactionId": "string"
}
```
## Request Parameters
For information about the parameters that are common to all actions, see [Common Parameters](CommonParameters.md).
The request accepts the following data in JSON format.
** [CatalogId](#API_CreateTable_RequestSyntax) **
The ID of the Data Catalog in which to create the `Table`. If none is supplied, 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](#API_CreateTable_RequestSyntax) **
The catalog database in which to create the new table. 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
** [Name](#API_CreateTable_RequestSyntax) **
The unique identifier for the table within the specified database that will be created in the AWS Glue Data Catalog.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 255.
Pattern: `[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*`
Required: No
** [OpenTableFormatInput](#API_CreateTable_RequestSyntax) **
Specifies an `OpenTableFormatInput` structure when creating an open format table.
Type: [OpenTableFormatInput](API_OpenTableFormatInput.md) object
Required: No
** [PartitionIndexes](#API_CreateTable_RequestSyntax) **
A list of partition indexes, `PartitionIndex` structures, to create in the table.
Type: Array of [PartitionIndex](API_PartitionIndex.md) objects
Array Members: Maximum number of 3 items.
Required: No
** [TableInput](#API_CreateTable_RequestSyntax) **
The `TableInput` object that defines the metadata table to create in the catalog.
Type: [TableInput](API_TableInput.md) object
Required: No
** [TransactionId](#API_CreateTable_RequestSyntax) **
The ID of the transaction.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 255.
Pattern: `[\p{L}\p{N}\p{P}]*`
Required: No
## Response Elements
If the action is successful, the service sends back an HTTP 200 response with an empty HTTP body.
## Errors
For information about the errors that are common to all actions, see [Common Error Types](CommonErrors.md).
** AlreadyExistsException **
A resource to be created or added already exists.
** Message **
A message describing the problem.
HTTP Status Code: 400
** ConcurrentModificationException **
Two processes are trying to modify a resource simultaneously.
** Message **
A message describing the problem.
HTTP Status Code: 400
** EntityNotFoundException **
A specified entity does not exist
** FromFederationSource **
Indicates whether or not the exception relates to a federated source.
** Message **
A message describing the problem.
HTTP Status Code: 400
** FederationSourceException **
A federation source failed.
** FederationSourceErrorCode **
The error code of the problem.
** Message **
The message describing the problem.
HTTP Status Code: 400
** FederationSourceRetryableException **
A federation source failed, but the operation may be retried.
** Message **
A message describing the problem.
HTTP Status Code: 400
** GlueEncryptionException **
An encryption operation failed.
** Message **
The message describing the problem.
HTTP Status Code: 400
** InternalServiceException **
An internal service error occurred.
** Message **
A message describing the problem.
HTTP Status Code: 500
** InvalidInputException **
The input provided was not valid.
** FromFederationSource **
Indicates whether or not the exception relates to a federated source.
** Message **
A message describing the problem.
HTTP Status Code: 400
** OperationTimeoutException **
The operation timed out.
** Message **
A message describing the problem.
HTTP Status Code: 400
** ResourceNotReadyException **
A resource was not ready for a transaction.
** Message **
A message describing the problem.
HTTP Status Code: 400
** ResourceNumberLimitExceededException **
A resource numerical limit was exceeded.
** Message **
A message describing the problem.
HTTP Status Code: 400
## See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following:
+ [AWS Command Line Interface V2](https://docs.aws.amazon.com/goto/cli2/glue-2017-03-31/CreateTable)
+ [AWS SDK for .NET V4](https://docs.aws.amazon.com/goto/DotNetSDKV4/glue-2017-03-31/CreateTable)
+ [AWS SDK for C\$1\$1](https://docs.aws.amazon.com/goto/SdkForCpp/glue-2017-03-31/CreateTable)
+ [AWS SDK for Go v2](https://docs.aws.amazon.com/goto/SdkForGoV2/glue-2017-03-31/CreateTable)
+ [AWS SDK for Java V2](https://docs.aws.amazon.com/goto/SdkForJavaV2/glue-2017-03-31/CreateTable)
+ [AWS SDK for JavaScript V3](https://docs.aws.amazon.com/goto/SdkForJavaScriptV3/glue-2017-03-31/CreateTable)
+ [AWS SDK for Kotlin](https://docs.aws.amazon.com/goto/SdkForKotlin/glue-2017-03-31/CreateTable)
+ [AWS SDK for PHP V3](https://docs.aws.amazon.com/goto/SdkForPHPV3/glue-2017-03-31/CreateTable)
+ [AWS SDK for Python](https://docs.aws.amazon.com/goto/boto3/glue-2017-03-31/CreateTable)
+ [AWS SDK for Ruby V3](https://docs.aws.amazon.com/goto/SdkForRubyV3/glue-2017-03-31/CreateTable)