Links

Integer Key (IntegerPkGenerator)

The Integer Key generator generates integer values that are between 0 and 2^32 - 1. The input values must be in the range 0 to 2^31 - 1.
The Integer Key generator does not support linking. It can be self-consistent, but not consistent with another column. You cannot configure differential privacy.
The metadata object is populated from the IntegerPkMetadata object, which includes:
  • The minimum value
  • The maximum value
  • The underlying data type for the source values (for MySQL and MongoDB)
{
"schema": "string",
"table": "string",
"column": "string",
"dataType": "string" //MongoDB only
"metadata": {
"presetId": "string",
"generatorId": "IntegerPkGenerator",
"min": integer,
"max": integer,
"rangeOption": "enum",
"isConsistent": boolean,
"encryptionProcessor": "x-on", //To use configured Tonic data encryption
"customValueProcessor": "string" //If custom value processor is applied
}
}

Example replacement

In the following example replacement for the Integer Key generator, the generator produces a value between 10 and 20. The original values are Int64. Consistency is enabled.
{
"name": "id",
"schema": "test"
"table": "users",
"links": [
{
"schema": "test",
"table": "users",
"column": "id",
"metadata": {
"presetId": "IntegerPkGenerator",
"generatorId": "IntegerPkGenerator",
"min": 10,
"max": 20,
"rangeOption": "Int64",
"isConsistent": true
}
}
]
}
Last modified 1mo ago