Masking Algorithm

You may customize your own data masking algorithm with the help of a predefined masking type.

  1. Go to Settings > Security & Policy > Data Masking.
  2. Click Masking Algorithm.
  3. Click Add, and fill in the name and description. Choose Masking Type, and fill in Substitute or Salt if necessary. Click Confirm to save.

Configure Masking Algorithms

Full mask

Mask the entire value and show Substitute value.

bb-masking-algorithm-full

Range mask

Mask several characters of a string and replace them with Substitute value.

bb-masking-algorithm-partial

MD5 mask

Use MD5 algorithm together with Salt value to hash.

bb-masking-algorithm-md5

Inner / Outer mask

  • Inner mask: Mask 123456 to format like 12**56, 1***56.
  • Outer mask: Mask 123456 to format like **34**, *23***.

bb-masking-algorithm-inner-outer

Assign Masking Algorithm

If you want to batch apply masking algorithm to many columns, use Semantic Types.

If you want to overwrite the default masking algorithm, you can go to the column setting and explicitly set the masking algorithm for the full and partial masking levels respectively.

bb-masking-column-masking-algorithm

Edit this page on GitHub

Subscribe to Newsletter

By subscribing, you agree with Bytebase's Terms of Service and Privacy Policy.