Sequential Integer (UniqueIntegerGenerator)
The Sequential Integer generator returns integer values that increment by 1 for each row in the destination database.
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.{
"presetId": "string",
"generatorId": "UniqueIntegerGenerator",
"schema": "string",
"table": "string",
"column": "string",
"dataType": "string" //MongoDB only
"metadata": {
"startingPoint": integer
},
"encryptionProcessor": "x-on", //To use configured Tonic data encryption
"customValueProcessor": "string" //If custom value processor applied
}
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": [
{
"presetId": "UniqueIntegerGenerator",
"generatorId": "UniqueIntegerGenerator",
"schema": "public",
"table": "users",
"column": "user-number",
"metadata": {
"startingPoint": 4
}
}
]
}