Integer Key

Generates unique integer values. By default, the generated values are within the range of the column’s data type.

You can also specify a range for the generated values. The source values must be within that range.

This generator cannot be used to transform negative numbers.

Characteristics

Consistency

Yes, can be made self-consistent.

Linking

No, cannot be linked.

Differential privacy

Yes, if consistency is not enabled.

Data-free

Yes, if consistency is not enabled.

Allowed for primary keys

Yes

Allowed for unique columns

Yes

Uses format-preserving encryption (FPE)

Yes

Privacy ranking

  • 1 if not consistent

  • 4 if consistent

Generator ID (for the API)

How to configure

To configure the generator:

  1. In the Minimum field, enter the minimum value to use for an output value. The minimum value cannot be larger than any of the values in the source data.

  2. In the Maximum field, enter the maximum value to use for an output value. The maximum value cannot be smaller than any of the values in the source data.

  3. Toggle the Consistency setting to indicate whether to make the column self-consistent. By default, consistency is disabled.

  4. If Structural data encryption is enabled, then to use it for this column, toggle Use data encryption process to the on position.

Last updated