Menu
AWS Database Migration Service
API Reference (API Version 2016-01-01)

TableStatistics

Contents

Ddls

The Data Definition Language (DDL) used to build and modify the structure of your tables.

Type: Long

Required: No

Deletes

The number of delete actions performed on a table.

Type: Long

Required: No

FullLoadCondtnlChkFailedRows

The number of rows that failed conditional checks during the Full Load operation (valid only for DynamoDB as a target migrations).

Type: Long

Required: No

FullLoadErrorRows

The number of rows that failed to load during the Full Load operation (valid only for DynamoDB as a target migrations).

Type: Long

Required: No

FullLoadRows

The number of rows added during the Full Load operation.

Type: Long

Required: No

Inserts

The number of insert actions performed on a table.

Type: Long

Required: No

LastUpdateTime

The last time the table was updated.

Type: Timestamp

Required: No

SchemaName

The schema name.

Type: String

Required: No

TableName

The name of the table.

Type: String

Required: No

TableState

The state of the tables described.

Valid states: Table does not exist | Before load | Full load | Table completed | Table cancelled | Table error | Table all | Table updates | Table is being reloaded

Type: String

Required: No

Updates

The number of update actions performed on a table.

Type: Long

Required: No

ValidationFailedRecords

The number of records that failed validation.

Type: Long

Required: No

ValidationPendingRecords

The number of records that have yet to be validated.

Type: Long

Required: No

ValidationState

The validation state of the table.

The parameter can have the following values

  • Not enabled—Validation is not enabled for the table in the migration task.

  • Pending records—Some records in the table are waiting for validation.

  • Mismatched records—Some records in the table do not match between the source and target.

  • Suspended records—Some records in the table could not be validated.

  • No primary key—The table could not be validated because it had no primary key.

  • Table error—The table was not validated because it was in an error state and some data was not migrated.

  • Validated—All rows in the table were validated. If the table is updated, the status can change from Validated.

  • Error—The table could not be validated because of an unexpected error.

Type: String

Required: No

ValidationStateDetails

Additional details about the state of validation.

Type: String

Required: No

ValidationSuspendedRecords

The number of records that could not be validated.

Type: Long

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: