ImportTable - Amazon DynamoDB

ImportTable

Imports table data from an S3 bucket.

Request Syntax

{ "ClientToken": "string", "InputCompressionType": "string", "InputFormat": "string", "InputFormatOptions": { "Csv": { "Delimiter": "string", "HeaderList": [ "string" ] } }, "S3BucketSource": { "S3Bucket": "string", "S3BucketOwner": "string", "S3KeyPrefix": "string" }, "TableCreationParameters": { "AttributeDefinitions": [ { "AttributeName": "string", "AttributeType": "string" } ], "BillingMode": "string", "GlobalSecondaryIndexes": [ { "IndexName": "string", "KeySchema": [ { "AttributeName": "string", "KeyType": "string" } ], "Projection": { "NonKeyAttributes": [ "string" ], "ProjectionType": "string" }, "ProvisionedThroughput": { "ReadCapacityUnits": number, "WriteCapacityUnits": number } } ], "KeySchema": [ { "AttributeName": "string", "KeyType": "string" } ], "ProvisionedThroughput": { "ReadCapacityUnits": number, "WriteCapacityUnits": number }, "SSESpecification": { "Enabled": boolean, "KMSMasterKeyId": "string", "SSEType": "string" }, "TableName": "string" } }

Request Parameters

The request accepts the following data in JSON format.

Note

In the following list, the required parameters are described first.

InputFormat

The format of the source data. Valid values for ImportFormat are CSV, DYNAMODB_JSON or ION.

Type: String

Valid Values: DYNAMODB_JSON | ION | CSV

Required: Yes

S3BucketSource

The S3 bucket that provides the source for the import.

Type: S3BucketSource object

Required: Yes

TableCreationParameters

Parameters for the table to import the data into.

Type: TableCreationParameters object

Required: Yes

ClientToken

Providing a ClientToken makes the call to ImportTableInput idempotent, meaning that multiple identical calls have the same effect as one single call.

A client token is valid for 8 hours after the first request that uses it is completed. After 8 hours, any request with the same client token is treated as a new request. Do not resubmit the same request with the same client token for more than 8 hours, or the result might not be idempotent.

If you submit a request with the same client token but a change in other parameters within the 8-hour idempotency window, DynamoDB returns an IdempotentParameterMismatch exception.

Type: String

Pattern: ^[^\$]+$

Required: No

InputCompressionType

Type of compression to be used on the input coming from the imported table.

Type: String

Valid Values: GZIP | ZSTD | NONE

Required: No

InputFormatOptions

Additional properties that specify how the input is formatted,

Type: InputFormatOptions object

Required: No

Response Syntax

{ "ImportTableDescription": { "ClientToken": "string", "CloudWatchLogGroupArn": "string", "EndTime": number, "ErrorCount": number, "FailureCode": "string", "FailureMessage": "string", "ImportArn": "string", "ImportedItemCount": number, "ImportStatus": "string", "InputCompressionType": "string", "InputFormat": "string", "InputFormatOptions": { "Csv": { "Delimiter": "string", "HeaderList": [ "string" ] } }, "ProcessedItemCount": number, "ProcessedSizeBytes": number, "S3BucketSource": { "S3Bucket": "string", "S3BucketOwner": "string", "S3KeyPrefix": "string" }, "StartTime": number, "TableArn": "string", "TableCreationParameters": { "AttributeDefinitions": [ { "AttributeName": "string", "AttributeType": "string" } ], "BillingMode": "string", "GlobalSecondaryIndexes": [ { "IndexName": "string", "KeySchema": [ { "AttributeName": "string", "KeyType": "string" } ], "Projection": { "NonKeyAttributes": [ "string" ], "ProjectionType": "string" }, "ProvisionedThroughput": { "ReadCapacityUnits": number, "WriteCapacityUnits": number } } ], "KeySchema": [ { "AttributeName": "string", "KeyType": "string" } ], "ProvisionedThroughput": { "ReadCapacityUnits": number, "WriteCapacityUnits": number }, "SSESpecification": { "Enabled": boolean, "KMSMasterKeyId": "string", "SSEType": "string" }, "TableName": "string" }, "TableId": "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.

ImportTableDescription

Represents the properties of the table created for the import, and parameters of the import. The import parameters include import status, how many items were processed, and how many errors were encountered.

Type: ImportTableDescription object

Errors

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

ImportConflictException

There was a conflict when importing from the specified S3 source. This can occur when the current import conflicts with a previous import request that had the same client token.

HTTP Status Code: 400

LimitExceededException

There is no limit to the number of daily on-demand backups that can be taken.

For most purposes, up to 500 simultaneous table operations are allowed per account. These operations include CreateTable, UpdateTable, DeleteTable,UpdateTimeToLive, RestoreTableFromBackup, and RestoreTableToPointInTime.

When you are creating a table with one or more secondary indexes, you can have up to 250 such requests running at a time. However, if the table or index specifications are complex, then DynamoDB might temporarily reduce the number of concurrent operations.

When importing into DynamoDB, up to 50 simultaneous import table operations are allowed per account.

There is a soft account quota of 2,500 tables.

HTTP Status Code: 400

ResourceInUseException

The operation conflicts with the resource's availability. For example, you attempted to recreate an existing table, or tried to delete a table currently in the CREATING state.

HTTP Status Code: 400

See Also

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