TableStatistics ¶

class TableStatistics(TypedDict, closed=True):
    schema_name: NotRequired["capo_database_migration_service.types.string.String"]
    """<p>The schema name.</p>"""
    table_name: NotRequired["capo_database_migration_service.types.string.String"]
    """<p>The name of the table.</p>"""
    inserts: "capo_database_migration_service.types.long.Long"
    """<p>The number of insert actions performed on a table.</p>"""
    deletes: "capo_database_migration_service.types.long.Long"
    """<p>The number of delete actions performed on a table.</p>"""
    updates: "capo_database_migration_service.types.long.Long"
    """<p>The number of update actions performed on a table.</p>"""
    ddls: "capo_database_migration_service.types.long.Long"
    """<p>The data definition language (DDL) used to build and modify the structure of your tables.</p>"""
    applied_inserts: NotRequired[
        "capo_database_migration_service.types.long_optional.LongOptional"
    ]
    """<p>The number of insert actions applied on a target table.</p>"""
    applied_deletes: NotRequired[
        "capo_database_migration_service.types.long_optional.LongOptional"
    ]
    """<p>The number of delete actions applied on a target table.</p>"""
    applied_updates: NotRequired[
        "capo_database_migration_service.types.long_optional.LongOptional"
    ]
    """<p>The number of update actions applied on a target table.</p>"""
    applied_ddls: NotRequired[
        "capo_database_migration_service.types.long_optional.LongOptional"
    ]
    """<p>The number of data definition language (DDL) statements used to build and modify the structure of your tables applied on the target.</p>"""
    full_load_rows: "capo_database_migration_service.types.long.Long"
    """<p>The number of rows added during the full load operation.</p>"""
    full_load_condtnl_chk_failed_rows: "capo_database_migration_service.types.long.Long"
    """<p>The number of rows that failed conditional checks during the full load operation (valid only for migrations where DynamoDB is the target).</p>"""
    full_load_error_rows: "capo_database_migration_service.types.long.Long"
    """<p>The number of rows that failed to load during the full load operation (valid only for migrations where DynamoDB is the target).</p>"""
    full_load_start_time: NotRequired[
        "capo_database_migration_service.types.t_stamp.TStamp"
    ]
    """<p>The time when the full load operation started.</p>"""
    full_load_end_time: NotRequired[
        "capo_database_migration_service.types.t_stamp.TStamp"
    ]
    """<p>The time when the full load operation completed.</p>"""
    full_load_reloaded: NotRequired[
        "capo_database_migration_service.types.boolean_optional.BooleanOptional"
    ]
    """<p>A value that indicates if the table was reloaded (<code>true</code>) or loaded as part of a new full load operation (<code>false</code>).</p>"""
    last_update_time: NotRequired[
        "capo_database_migration_service.types.t_stamp.TStamp"
    ]
    """<p>The last time a table was updated.</p>"""
    table_state: NotRequired["capo_database_migration_service.types.string.String"]
    """<p>The state of the tables described.</p> <p>Valid states: Table does not exist | Before load | Full load | Table completed | Table cancelled | Table error | Table is being reloaded</p>"""
    validation_pending_records: "capo_database_migration_service.types.long.Long"
    """<p>The number of records that have yet to be validated.</p>"""
    validation_failed_records: "capo_database_migration_service.types.long.Long"
    """<p>The number of records that failed validation.</p>"""
    validation_suspended_records: "capo_database_migration_service.types.long.Long"
    """<p>The number of records that couldn't be validated.</p>"""
    validation_state: NotRequired["capo_database_migration_service.types.string.String"]
    """<p>The validation state of the table.</p> <p>This parameter can have the following values:</p> <ul> <li> <p>Not enabled – Validation isn't enabled for the table in the migration task.</p> </li> <li> <p>Pending records – Some records in the table are waiting for validation.</p> </li> <li> <p>Mismatched records – Some records in the table don't match between the source and target.</p> </li> <li> <p>Suspended records – Some records in the table couldn't be validated.</p> </li> <li> <p>No primary key –The table couldn't be validated because it has no primary key.</p> </li> <li> <p>Table error – The table wasn't validated because it's in an error state and some data wasn't migrated.</p> </li> <li> <p>Validated – All rows in the table are validated. If the table is updated, the status can change from Validated.</p> </li> <li> <p>Error – The table couldn't be validated because of an unexpected error.</p> </li> <li> <p>Pending validation – The table is waiting validation.</p> </li> <li> <p>Preparing table – Preparing the table enabled in the migration task for validation.</p> </li> <li> <p>Pending revalidation – All rows in the table are pending validation after the table was updated.</p> </li> </ul>"""
    validation_state_details: NotRequired[
        "capo_database_migration_service.types.string.String"
    ]
    """<p>Additional details about the state of validation.</p>"""
    resync_state: NotRequired["capo_database_migration_service.types.string.String"]
    """<p>Records the current state of table resynchronization in the migration task.</p> <p>This parameter can have the following values:</p> <ul> <li> <p>Not enabled – Resync is not enabled for the table in the migration task.</p> </li> <li> <p>Pending – The tables are waiting for resync.</p> </li> <li> <p>In progress – Resync in progress for some records in the table.</p> </li> <li> <p>No primary key – The table could not be resynced because it has no primary key.</p> </li> <li> <p>Last resync at: <code>date/time</code> – Resync session is finished at time. Time provided in UTC format.</p> </li> </ul>"""
    resync_rows_attempted: NotRequired[
        "capo_database_migration_service.types.long_optional.LongOptional"
    ]
    """<p>Records the total number of mismatched data rows where the system attempted to apply fixes in the target database.</p>"""
    resync_rows_succeeded: NotRequired[
        "capo_database_migration_service.types.long_optional.LongOptional"
    ]
    """<p>Records the total number of mismatched data rows where fixes were successfully applied in the target database.</p>"""
    resync_rows_failed: NotRequired[
        "capo_database_migration_service.types.long_optional.LongOptional"
    ]
    """<p>Records the total number of mismatched data rows where fix attempts failed in the target database.</p>"""
    resync_progress: NotRequired[
        "capo_database_migration_service.types.double_optional.DoubleOptional"
    ]
    """<p>Calculates the percentage of failed validations that were successfully resynced to the system.</p>"""