DescribeReplicationTableStatistics
Returns table and schema statistics for one or more provisioned replications that use a given Amazon DMS Serverless replication configuration.
Request Syntax
{
"Filters": [
{
"Name": "string
",
"Values": [ "string
" ]
}
],
"Marker": "string
",
"MaxRecords": number
,
"ReplicationConfigArn": "string
"
}
Request Parameters
For information about the parameters that are common to all actions, see Common Parameters.
The request accepts the following data in JSON format.
- Filters
-
Filters applied to the replication table statistics.
Type: Array of Filter objects
Required: No
- 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
.Type: String
Required: No
- 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.Type: Integer
Required: No
- ReplicationConfigArn
-
The replication config to describe.
Type: String
Required: Yes
Response Syntax
{
"Marker": "string",
"ReplicationConfigArn": "string",
"ReplicationTableStatistics": [
{
"AppliedDdls": number,
"AppliedDeletes": number,
"AppliedInserts": number,
"AppliedUpdates": number,
"Ddls": number,
"Deletes": number,
"FullLoadCondtnlChkFailedRows": number,
"FullLoadEndTime": number,
"FullLoadErrorRows": number,
"FullLoadReloaded": boolean,
"FullLoadRows": number,
"FullLoadStartTime": number,
"Inserts": number,
"LastUpdateTime": number,
"SchemaName": "string",
"TableName": "string",
"TableState": "string",
"Updates": number,
"ValidationFailedRecords": number,
"ValidationPendingRecords": number,
"ValidationState": "string",
"ValidationStateDetails": "string",
"ValidationSuspendedRecords": number
}
]
}
Response Elements
If the action is successful, the service sends back an HTTP 200 response.
The following data is returned in JSON format by the service.
- 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
.Type: String
- ReplicationConfigArn
-
The Amazon Resource Name of the replication config.
Type: String
- ReplicationTableStatistics
-
Returns table statistics on the replication, including table name, rows inserted, rows updated, and rows deleted.
Type: Array of TableStatistics objects
Errors
For information about the errors that are common to all actions, see Common Errors.
- InvalidResourceStateFault
-
The resource is in a state that prevents it from being used for database migration.
HTTP Status Code: 400
- ResourceNotFoundFault
-
The resource could not be found.
HTTP Status Code: 400
Examples
Example
This example illustrates one usage of DescribeReplicationTableStatistics.
Sample Request
POST / HTTP/1.1
Host: dms.<region>.<domain>
x-amz-Date: <Date>
Authorization: AWS4-HMAC-SHA256 Credential=<Credential>,
SignedHeaders=contenttype;date;host;user-agent;x-amz-date;x-amz-target;x-amzn-requestid,Signature=<Signature>
User-Agent: <UserAgentString>
Content-Type: application/x-amz-json-1.1
Content-Length: <PayloadSizeBytes>
Connection: Keep-Alive
X-Amz-Target: AmazonDMSv20160101.DescribeReplicationTableStatistics
{
"ReplicationConfigArn": "arn:aws:dms:us-east-
1:123456789012:replication-config:WZVIPF3D4AJSNJASB42D4Z7GBE",
"SchemaName": "",
"TableNames": [
""
],
"MaxRecords": 0,
"Marker": ""
}
Sample Response
HTTP/1.1 200 OK
x-amzn-RequestId: <RequestId>
Content-Type: application/x-amz-json-1.1
Content-Length: <PayloadSizeBytes>
Date: <Date>
{
"ReplicationConfigArn": "arn:aws:dms:us-east-
1:123456789012:replication-config:WZVIPF3D4AJSNJASB42D4Z7GBE",
"TableStatistics": [
{
"SchemaName": "travel",
"TableName": "vehicle",
"Inserts": 3872,
"Deletes": 0,
"Updates": 0,
"Ddls": 1,
"AppliedInserts": 3872,
"AppliedDeletes": 0,
"AppliedUpdates": 0,
"AppliedDdls": 1,
"FullLoadRows": 0,
"FullLoadCondtnlChkFailedRows": 0,
"FullLoadErrorRows": 0,
"FullLoadStartTime": 1658436291.83,
"FullLoadEndTime": 1658437392.059,
"FullLoadReloaded": false,
"LastUpdateTime": 1658437401.063,
"TableState": "Table completed",
"ScheduledForReload": false,
"ValidationPendingRecords": 0,
"ValidationFailedRecords": 0,
"ValidationSuspendedRecords": 0,
"ValidationState": "Not enabled"
},
{
"SchemaName": "travel",
"TableName": "drivers",
"Inserts": 20,
"Deletes": 0,
"Updates": 0,
"Ddls": 1,
"AppliedInserts": 20,
"AppliedDeletes": 0,
"AppliedUpdates": 0,
"AppliedDdls": 1,
"FullLoadRows": 0,
"FullLoadCondtnlChkFailedRows": 0,
"FullLoadErrorRows": 0,
"FullLoadStartTime": 1658436291.534,
"FullLoadEndTime": 1658436483.802,
"FullLoadReloaded": false,
"LastUpdateTime": 1658437212.063,
"TableState": "Table completed",
"ScheduledForReload": false,
"ValidationPendingRecords": 0,
"ValidationFailedRecords": 0,
"ValidationSuspendedRecords": 0,
"ValidationState": "Not enabled"
},
{
"SchemaName": "travel",
"TableName": "passengers",
"Inserts": 60,
"Deletes": 0,
"Updates": 0,
"Ddls": 1,
"AppliedInserts": 60,
"AppliedDeletes": 0,
"AppliedUpdates": 0,
"AppliedDdls": 1,
"FullLoadRows": 0,
"FullLoadCondtnlChkFailedRows": 0,
"FullLoadErrorRows": 0,
"FullLoadStartTime": 1658446502.641,
"FullLoadEndTime": 1658454293.712,
"FullLoadReloaded": false,
"LastUpdateTime": 1658454301.153,
"TableState": "Table completed",
"ScheduledForReload": false,
"ValidationPendingRecords": 0,
"ValidationFailedRecords": 0,
"ValidationSuspendedRecords": 0,
"ValidationState": "Not enabled"
}
]
}
See Also
For more information about using this API in one of the language-specific Amazon SDKs, see the following: