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
}
}
]
}