AWS Database Migration Service

{'TableStatistics': {'FullLoadCondtnlChkFailedRows': 'long',
                     'FullLoadErrorRows': 'long'}}

Returns table statistics on the database migration task, including table name, rows inserted, rows updated, and rows deleted.

See also: AWS API Documentation

Request Syntax

client.describe_table_statistics(
    ReplicationTaskArn='string',
    MaxRecords=123,
    Marker='string'
)

type ReplicationTaskArn:

string

param ReplicationTaskArn:

[REQUIRED]

The Amazon Resource Name (ARN) of the replication task.

type MaxRecords:

integer

param MaxRecords:

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, a pagination token called a marker is included in the response so that the remaining results can be retrieved.

Default: 100

Constraints: Minimum 20, maximum 100.

type Marker:

string

param Marker:

An optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.

rtype:

dict

returns:

Response Syntax

{
    'ReplicationTaskArn': 'string',
    'TableStatistics': [
        {
            'SchemaName': 'string',
            'TableName': 'string',
            'Inserts': 123,
            'Deletes': 123,
            'Updates': 123,
            'Ddls': 123,
            'FullLoadRows': 123,
            'FullLoadCondtnlChkFailedRows': 123,
            'FullLoadErrorRows': 123,
            'LastUpdateTime': datetime(2015, 1, 1),
            'TableState': 'string'
        },
    ],
    'Marker': 'string'
}

Response Structure

• (dict) --

  • ReplicationTaskArn (string) --

    The Amazon Resource Name (ARN) of the replication task.

  • TableStatistics (list) --

    The table statistics.

    • (dict) --

      • 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.

      • 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 DynamoDB as a target migrations).

      • FullLoadErrorRows (integer) --

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

      • LastUpdateTime (datetime) --

        The last time the table was updated.

      • TableState (string) --

        The state of the table.

  • Marker (string) --

    An optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.

{'Tags': [{'Key': 'string', 'Value': 'string'}]}

Uploads the specified certificate.

See also: AWS API Documentation

Request Syntax

client.import_certificate(
    CertificateIdentifier='string',
    CertificatePem='string',
    CertificateWallet=b'bytes',
    Tags=[
        {
            'Key': 'string',
            'Value': 'string'
        },
    ]
)

type CertificateIdentifier:

string

param CertificateIdentifier:

[REQUIRED]

The customer-assigned name of the certificate. Valid characters are A-z and 0-9.

type CertificatePem:

string

param CertificatePem:

The contents of the .pem X.509 certificate file for the certificate.

type CertificateWallet:

bytes

param CertificateWallet:

The location of the imported Oracle Wallet certificate for use with SSL.

type Tags:

list

param Tags:

The tags associated with the certificate.

• (dict) --

  • Key (string) --

    A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and cannot be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").

  • Value (string) --

    A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and cannot be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").

rtype:

dict

returns:

Response Syntax

{
    'Certificate': {
        'CertificateIdentifier': 'string',
        'CertificateCreationDate': datetime(2015, 1, 1),
        'CertificatePem': 'string',
        'CertificateWallet': b'bytes',
        'CertificateArn': 'string',
        'CertificateOwner': 'string',
        'ValidFromDate': datetime(2015, 1, 1),
        'ValidToDate': datetime(2015, 1, 1),
        'SigningAlgorithm': 'string',
        'KeyLength': 123
    }
}

Response Structure

• (dict) --

  • Certificate (dict) --

    The certificate to be uploaded.

    • CertificateIdentifier (string) --

      The customer-assigned name of the certificate. Valid characters are A-z and 0-9.

    • CertificateCreationDate (datetime) --

      The date that the certificate was created.

    • CertificatePem (string) --

      The contents of the .pem X.509 certificate file for the certificate.

    • CertificateWallet (bytes) --

      The location of the imported Oracle Wallet certificate for use with SSL.

    • CertificateArn (string) --

      The Amazon Resource Name (ARN) for the certificate.

    • CertificateOwner (string) --

      The owner of the certificate.

    • ValidFromDate (datetime) --

      The beginning date that the certificate is valid.

    • ValidToDate (datetime) --

      The final date that the certificate is valid.

    • SigningAlgorithm (string) --

      The signing algorithm for the certificate.

    • KeyLength (integer) --

      The key length of the cryptographic algorithm being used.