Sequential Integer (UniqueIntegerGenerator)

The Sequential Integer generator returns integer values that increment by 1 for each row in the destination database.

Link object structure

The Sequential Integer generator can be linked. You provide a link object for each linked column. The generator does not support consistency. You cannot configure differential privacy.

The metadata object is populated from the UniqueIntegerMetadata object. startingPoint provides the first integer to apply.

{
  "schema": "string",
  "table": "string",
  "column": "string",
  "path": "string",  //JSON fields only
  "dataType": "string",  //MongoDB, Amazon DynamoDB, and JSON fields only
  "metadata": {
    "presetId": "string",
    "generatorId": "UniqueIntegerGenerator",
    "startingPoint": integer,
    "encryptionProcessor": "x-on", //To use configured Structural data encryption
    "customValueProcessor": "string"  //If custom value processor applied
  }
}

Example replacement

The following example replacement for the Sequential Integer generator configures a single unlinked column. The values start with 4.

{
  "name": "user-number",
  "schema": "public",
  "table": "users",
  "links": [
    {
      "schema": "public",
      "table": "users",
      "column": "user-number",
      "metadata": {
        "presetId": "UniqueIntegerGenerator",
        "generatorId": "UniqueIntegerGenerator",
        "startingPoint": 4
      }
    }
  ]
}