Amazon DMS · JSON Structure

Amazon Dms Table Statistics Structure

Provides a collection of table statistics in response to a request by the DescribeTableStatistics operation.

Type: object Properties: 23
Data ReplicationDatabaseDatabase MigrationMigration

Amazon Dms Table Statistics Structure is a JSON Structure definition published by Amazon DMS, describing 23 properties. It conforms to the https://json-structure.org/meta/core/v0/# meta-schema.

Properties

SchemaName TableName Inserts Deletes Updates Ddls AppliedInserts AppliedDeletes AppliedUpdates AppliedDdls FullLoadRows FullLoadCondtnlChkFailedRows FullLoadErrorRows FullLoadStartTime FullLoadEndTime FullLoadReloaded LastUpdateTime TableState ValidationPendingRecords ValidationFailedRecords ValidationSuspendedRecords ValidationState ValidationStateDetails

Meta-schema: https://json-structure.org/meta/core/v0/#

JSON Structure

Raw ↑
{
  "$schema": "https://json-structure.org/meta/core/v0/#",
  "$id": "https://raw.githubusercontent.com/api-evangelist/amazon-dms/refs/heads/main/json-structure/amazon-dms-table-statistics-structure.json",
  "title": "TableStatistics",
  "description": "Provides a collection of table statistics in response to a request by the <code>DescribeTableStatistics</code> operation.",
  "type": "object",
  "properties": {
    "SchemaName": {
      "allOf": [
        {
          "$ref": "#/components/schemas/String"
        },
        {
          "description": "The schema name."
        }
      ]
    },
    "TableName": {
      "allOf": [
        {
          "$ref": "#/components/schemas/String"
        },
        {
          "description": "The name of the table."
        }
      ]
    },
    "Inserts": {
      "allOf": [
        {
          "$ref": "#/components/schemas/Long"
        },
        {
          "description": "The number of insert actions performed on a table."
        }
      ]
    },
    "Deletes": {
      "allOf": [
        {
          "$ref": "#/components/schemas/Long"
        },
        {
          "description": "The number of delete actions performed on a table."
        }
      ]
    },
    "Updates": {
      "allOf": [
        {
          "$ref": "#/components/schemas/Long"
        },
        {
          "description": "The number of update actions performed on a table."
        }
      ]
    },
    "Ddls": {
      "allOf": [
        {
          "$ref": "#/components/schemas/Long"
        },
        {
          "description": "The data definition language (DDL) used to build and modify the structure of your tables."
        }
      ]
    },
    "AppliedInserts": {
      "allOf": [
        {
          "$ref": "#/components/schemas/LongOptional"
        },
        {
          "description": "The number of insert actions applied on a target table."
        }
      ]
    },
    "AppliedDeletes": {
      "allOf": [
        {
          "$ref": "#/components/schemas/LongOptional"
        },
        {
          "description": "The number of delete actions applied on a target table."
        }
      ]
    },
    "AppliedUpdates": {
      "allOf": [
        {
          "$ref": "#/components/schemas/LongOptional"
        },
        {
          "description": "The number of update actions applied on a target table."
        }
      ]
    },
    "AppliedDdls": {
      "allOf": [
        {
          "$ref": "#/components/schemas/LongOptional"
        },
        {
          "description": "The number of data definition language (DDL) statements used to build and modify the structure of your tables applied on the target."
        }
      ]
    },
    "FullLoadRows": {
      "allOf": [
        {
          "$ref": "#/components/schemas/Long"
        },
        {
          "description": "The number of rows added during the full load operation."
        }
      ]
    },
    "FullLoadCondtnlChkFailedRows": {
      "allOf": [
        {
          "$ref": "#/components/schemas/Long"
        },
        {
          "description": "The number of rows that failed conditional checks during the full load operation (valid only for migrations where DynamoDB is the target)."
        }
      ]
    },
    "FullLoadErrorRows": {
      "allOf": [
        {
          "$ref": "#/components/schemas/Long"
        },
        {
          "description": "The number of rows that failed to load during the full load operation (valid only for migrations where DynamoDB is the target)."
        }
      ]
    },
    "FullLoadStartTime": {
      "allOf": [
        {
          "$ref": "#/components/schemas/TStamp"
        },
        {
          "description": "The time when the full load operation started."
        }
      ]
    },
    "FullLoadEndTime": {
      "allOf": [
        {
          "$ref": "#/components/schemas/TStamp"
        },
        {
          "description": "The time when the full load operation completed."
        }
      ]
    },
    "FullLoadReloaded": {
      "allOf": [
        {
          "$ref": "#/components/schemas/BooleanOptional"
        },
        {
          "description": "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>)."
        }
      ]
    },
    "LastUpdateTime": {
      "allOf": [
        {
          "$ref": "#/components/schemas/TStamp"
        },
        {
          "description": "The last time a table was updated."
        }
      ]
    },
    "TableState": {
      "allOf": [
        {
          "$ref": "#/components/schemas/String"
        },
        {
          "description": "<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>"
        }
      ]
    },
    "ValidationPendingRecords": {
      "allOf": [
        {
          "$ref": "#/components/schemas/Long"
        },
        {
          "description": "The number of records that have yet to be validated."
        }
      ]
    },
    "ValidationFailedRecords": {
      "allOf": [
        {
          "$ref": "#/components/schemas/Long"
        },
        {
          "description": "The number of records that failed validation."
        }
      ]
    },
    "ValidationSuspendedRecords": {
      "allOf": [
        {
          "$ref": "#/components/schemas/Long"
        },
        {
          "description": "The number of records that couldn't be validated."
        }
      ]
    },
    "ValidationState": {
      "allOf": [
        {
          "$ref": "#/components/schemas/String"
        },
        {
          "description": "<p>The validation state of the table.</p> <p>This parameter can have the following values:</p> <ul> <li> <p>Not enabled \u2013 Validation isn't enabled for the table in the migration task.</p> </li> <li> <p>Pending records \u2013 Some records in the table are waiting for validation.</p> </li> <li> <p>Mismatched records \u2013 Some records in the table don't match between the source and target.</p> </li> <li> <p>Suspended records \u2013 Some records in the table couldn't be validated.</p> </li> <li> <p>No primary key \u2013The table couldn't be validated because it has no primary key.</p> </li> <li> <p>Table error \u2013 The table wasn't validated because it's in an error state and some data wasn't migrated.</p> </li> <li> <p>Validated \u2013 All rows in the table are validated. If the table is updated, the status can change from Validated.</p> </li> <li> <p>Error \u2013 The table couldn't be validated because of an unexpected error.</p> </li> <li> <p>Pending validation \u2013 The table is waiting validation.</p> </li> <li> <p>Preparing table \u2013 Preparing the table enabled in the migration task for validation.</p> </li> <li> <p>Pending revalidation \u2013 All rows in the table are pending validation after the table was updated.</p> </li> </ul>"
        }
      ]
    },
    "ValidationStateDetails": {
      "allOf": [
        {
          "$ref": "#/components/schemas/String"
        },
        {
          "description": "Additional details about the state of validation."
        }
      ]
    }
  }
}

Work with this as data

Every JSON Structure here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for json structure

4 MCP tools reach this
  • find_json_structuresBrowse and filter every JSON Structure in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Structure
curl "https://apis.io/api/v1/json-structures/amazon-dms-table-statistics-structure"
All json structure
curl "https://apis.io/api/v1/json-structures?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.