TableStatistics - AWS Database Migration Service

TableStatistics

Provides a collection of table statistics in response to a request by the DescribeTableStatistics operation.

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 migrations where DynamoDB is the target).

Type: Long

Required: No

FullLoadEndTime

The time when the full load operation completed.

Type: Timestamp

Required: No

FullLoadErrorRows

The number of rows that failed to load during the full load operation (valid only for migrations where DynamoDB is the target).

Type: Long

Required: No

FullLoadReloaded

A value that indicates if the table was reloaded (true) or loaded as part of a new full load operation (false).

Type: Boolean

Required: No

FullLoadRows

The number of rows added during the full load operation.

Type: Long

Required: No

FullLoadStartTime

The time when the full load operation started.

Type: Timestamp

Required: No

Inserts

The number of insert actions performed on a table.

Type: Long

Required: No

LastUpdateTime

The last time a 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.

This parameter can have the following values:

  • Not enabled – Validation isn't 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 don't match between the source and target.

  • Suspended records – Some records in the table couldn't be validated.

  • No primary key –The table couldn't be validated because it has no primary key.

  • Table error – The table wasn't validated because it's in an error state and some data wasn't migrated.

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

  • Error – The table couldn't be validated because of an unexpected error.

  • Pending validation – The table is waiting validation.

  • Preparing table – Preparing the table enabled in the migration task for validation.

  • Pending revalidation – All rows in the table are pending validation after the table was updated.

Type: String

Required: No

ValidationStateDetails

Additional details about the state of validation.

Type: String

Required: No

ValidationSuspendedRecords

The number of records that couldn't 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: