DescribeTableStatistics¶

class DatabaseMigrationService.Paginator.DescribeTableStatistics¶

paginator = client.get_paginator('describe_table_statistics')

paginate(**kwargs)¶

Creates an iterator that will paginate through responses from DatabaseMigrationService.Client.describe_table_statistics().

See also: AWS API Documentation

Request Syntax

response_iterator = paginator.paginate(
    ReplicationTaskArn='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    PaginationConfig={
        'MaxItems': 123,
        'PageSize': 123,
        'StartingToken': 'string'
    }
)

Parameters

ReplicationTaskArn (string) --
[REQUIRED]

The Amazon Resource Name (ARN) of the replication task.
Filters (list) --
Filters applied to table statistics.

Valid filter names: schema-name | table-name | table-state

A combination of filters creates an AND condition where each record matches all specified filters.
- (dict) --
  Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.
  - Name (string) -- [REQUIRED]
    The name of the filter as specified for a Describe* or similar operation.
  - Values (list) -- [REQUIRED]
    The filter value, which can specify one or more values used to narrow the returned results.
    - (string) --
PaginationConfig (dict) --
A dictionary that provides parameters to control pagination.
- MaxItems (integer) --
  The total number of items to return. If the total number of items available is more than the value specified in max-items then a NextToken will be provided in the output that you can use to resume pagination.
- PageSize (integer) --
  The size of each page.
- StartingToken (string) --
  A token to specify where to start paginating. This is the NextToken from a previous response.

Return type

dict

Returns

Response Syntax

{
    'ReplicationTaskArn': 'string',
    'TableStatistics': [
        {
            'SchemaName': 'string',
            'TableName': 'string',
            'Inserts': 123,
            'Deletes': 123,
            'Updates': 123,
            'Ddls': 123,
            'AppliedInserts': 123,
            'AppliedDeletes': 123,
            'AppliedUpdates': 123,
            'AppliedDdls': 123,
            'FullLoadRows': 123,
            'FullLoadCondtnlChkFailedRows': 123,
            'FullLoadErrorRows': 123,
            'FullLoadStartTime': datetime(2015, 1, 1),
            'FullLoadEndTime': datetime(2015, 1, 1),
            'FullLoadReloaded': True|False,
            'LastUpdateTime': datetime(2015, 1, 1),
            'TableState': 'string',
            'ValidationPendingRecords': 123,
            'ValidationFailedRecords': 123,
            'ValidationSuspendedRecords': 123,
            'ValidationState': 'string',
            'ValidationStateDetails': 'string'
        },
    ],
    'NextToken': 'string'
}

Response Structure

(dict) --
- ReplicationTaskArn (string) --
  
  The Amazon Resource Name (ARN) of the replication task.
- TableStatistics (list) --
  
  The table statistics.
  - (dict) --
    
    Provides a collection of table statistics in response to a request by the DescribeTableStatistics operation.
    - SchemaName (string) --
      
      The schema name.
    - TableName (string) --
      
      The name of the table.
    - Inserts (integer) --
      
      The number of insert actions performed on a table.
    - Deletes (integer) --
      
      The number of delete actions performed on a table.
    - Updates (integer) --
      
      The number of update actions performed on a table.
    - Ddls (integer) --
      
      The data definition language (DDL) used to build and modify the structure of your tables.
    - AppliedInserts (integer) --
      
      The number of insert actions applied on a target table.
    - AppliedDeletes (integer) --
      
      The number of delete actions applied on a target table.
    - AppliedUpdates (integer) --
      
      The number of update actions applied on a target table.
    - AppliedDdls (integer) --
      
      The number of data definition language (DDL) statements used to build and modify the structure of your tables applied on the target.
    - FullLoadRows (integer) --
      
      The number of rows added during the full load operation.
    - FullLoadCondtnlChkFailedRows (integer) --
      
      The number of rows that failed conditional checks during the full load operation (valid only for migrations where DynamoDB is the target).
    - FullLoadErrorRows (integer) --
      
      The number of rows that failed to load during the full load operation (valid only for migrations where DynamoDB is the target).
    - FullLoadStartTime (datetime) --
      
      The time when the full load operation started.
    - FullLoadEndTime (datetime) --
      
      The time when the full load operation completed.
    - FullLoadReloaded (boolean) --
      
      A value that indicates if the table was reloaded ( true ) or loaded as part of a new full load operation ( false ).
    - LastUpdateTime (datetime) --
      
      The last time a table was updated.
    - TableState (string) --
      
      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
    - ValidationPendingRecords (integer) --
      
      The number of records that have yet to be validated.
    - ValidationFailedRecords (integer) --
      
      The number of records that failed validation.
    - ValidationSuspendedRecords (integer) --
      
      The number of records that couldn't be validated.
    - ValidationState (string) --
      
      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.
    - ValidationStateDetails (string) --
      
      Additional details about the state of validation.
- NextToken (string) --
  
  A token to resume pagination.

Select your cookie preferences

Customize cookie preferences

Essential

Performance

Functional

Advertising

Table Of Contents

DescribeTableStatistics¶