TableStatistics
Provides a collection of table statistics in response to a request by the
DescribeTableStatistics operation.
Contents
- AppliedDdls
-
The number of data definition language (DDL) statements used to build and modify the structure of your tables applied on the target.
Type: Long
Required: No
- AppliedDeletes
-
The number of delete actions applied on a target table.
Type: Long
Required: No
- AppliedInserts
-
The number of insert actions applied on a target table.
Type: Long
Required: No
- AppliedUpdates
-
The number of update actions applied on a target table.
Type: Long
Required: No
- 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
- ResyncProgress
-
Calculates the percentage of failed validations that were successfully resynced to the system.
Type: Double
Required: No
- ResyncRowsAttempted
-
Records the total number of mismatched data rows where the system attempted to apply fixes in the target database.
Type: Long
Required: No
- ResyncRowsFailed
-
Records the total number of mismatched data rows where fix attempts failed in the target database.
Type: Long
Required: No
- ResyncRowsSucceeded
-
Records the total number of mismatched data rows where fixes were successfully applied in the target database.
Type: Long
Required: No
- ResyncState
-
Records the current state of table resynchronization in the migration task.
This parameter can have the following values:
-
Not enabled – Resync is not enabled for the table in the migration task.
-
Pending – The tables are waiting for resync.
-
In progress – Resync in progress for some records in the table.
-
No primary key – The table could not be resynced because it has no primary key.
-
Last resync at:
date/time– Resync session is finished at time. Time provided in UTC format.
Type: String
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 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 Amazon SDKs, see the following: