選取您的 Cookie 偏好設定

我們使用提供自身網站和服務所需的基本 Cookie 和類似工具。我們使用效能 Cookie 收集匿名統計資料,以便了解客戶如何使用我們的網站並進行改進。基本 Cookie 無法停用,但可以按一下「自訂」或「拒絕」以拒絕效能 Cookie。

如果您同意,AWS 與經核准的第三方也會使用 Cookie 提供實用的網站功能、記住您的偏好設定,並顯示相關內容,包括相關廣告。若要接受或拒絕所有非必要 Cookie,請按一下「接受」或「拒絕」。若要進行更詳細的選擇,請按一下「自訂」。

DescribeReplicationTableStatistics - AWS Database Migration Service
此頁面尚未翻譯為您的語言。 請求翻譯

DescribeReplicationTableStatistics

Returns table and schema statistics for one or more provisioned replications that use a given AWS 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 AWS SDKs, see the following:

隱私權網站條款Cookie 偏好設定
© 2025, Amazon Web Services, Inc.或其附屬公司。保留所有權利。