Main hub

The Main Hub offers a centralized view and configuration board of your database’s PII protection status. It available under the Main Hub tab and is designed to help you effortlessly monitor and manage sensitive data across all tables in your workspace.

Table selection menu

On the left panel, the Table selection menu lists all tables and views in your database. You can select all table or views for which the columns will be displayed and configurable from the screen center.

Click Edit to choose which tables to include or exclude.

  • Include: data of included tables will be transferred to the destination database.

  • Exclude: data of excluded tables will not be transferred.

Hint: To include or exclude several tables at once, use the Bulk option.

Viewing the protection status for each column

Overview of protection statuses of columns

Unprotected PII columns

These columns have been identified as containing sensitive PII data but have not yet been protected. They require further action to protect the column, which typically includes assigning a generator.

Unprotected PII columns

Confidence scores

Here you also can review PII scan confidence scores to help evaluate the likelihood that a column contains sensitive information. These scores are displayed next to the mockers thus showing the confidence of a mocker for that column.

Confidence threshold slider

The confidence threshold slider enables you to fine-tune the sensitivity of PII detection to align with your privacy policies. When you set a specific threshold value, the dashboard will display only the columns whose PII confidence scores meet or exceed this threshold. This makes it easier to quickly apply a suitable generator to protect high-confidence PII columns directly from the interface.

This is especially useful when working with large databases. By setting a threshold value, only columns with a score equal to or greater than that value will be displayed, thus helping you prioritize which columns require protection.

If you click on Show columns below PII scan acceptance threshold, you will also see columns that fall below your defined confidence level, allowing for manual review of lower-confidence results as needed.

PII scan acceptance threshold

Protected PII columns

These columns are already protected using Syntho’s generators. Examples include columns with mock data for birthplace, driving license and maiden names, or an ID column that has Hash applied.

Protected PII columns

Non-PII columns

These are columns the system has classified as not containing PII. While no action is required for these, it’s good practice to periodically review them, especially when the data or schema evolves.

Non-PII columns

Marking and umarking columns as PII

On the Main hub tab, you can add new columns to the list of PII columns, either manually or using Syntho's PII scanner. You can manually mark or unmarks columns containing PII via either of below options:

  • Select the PII toggle next to the column

Selecting column
  • Via the Column Parameters modal, select the Mark as PII toggle in the top right. Then, click Confirm to mark the column as PII and confirm the applied generator selection.

Select generation method

After adding a PII column, it will be listed under the Main Hub tab under the respective tab.

On the Table view tab, all columns marked as PII will also have a PII icon in the column header.

Reminder: The PII scanner can help identify many PII columns, but users should manually review and identify any other sensitive columns that might not be detected automatically.

View and configure columns

There are several options to apply and configure generators from the Main hub tab:

  1. Open the dropdown in the Generator column to choose a generator. This will apply the generator with its default settings.

  2. Click the gear icon next to the Generator column to open the column settings modal, where you can adjust all generator parameters.

  3. Use the Apply or Reject buttons in the Actions menu to apply generator suggestions as based on your selected workspace mode.

Bulk apply generators

Bulk options allow you to quickly manage multiple schemas, tables, or columns at once. This helps streamline configuration without having to edit each item individually.

Schemas and Tables

  • Select All / Unselect All: Choose or clear all tables for which to display the generators in the center screen of the Main hub.

  • Include All / Exclude All: Select Edit next to the left Tables menu panel to bulk include or excluded schemas or tables.

Columns

  • Select All / Unselect All: Choose or clear all columns within one or more selected tables.

Actions on Selected Columns

  • Apply generator: Assign a generator to all selected columns.

  • Unmark/Mark PII: Mark selected columns as containing personally identifiable information (PII), or remove the label if not applicable.

Generator and Parameter Availability

  • Bulk apply generator only exposes generators and parameters that are applicable to all selected columns.

    • The more diverse the column types, the fewer generators and parameters will remain available.

    • Example: selecting a mix of text and numeric columns will only display options valid for both.

Performance Considerations

  • When working with a large number of schemas, tables, or columns, bulk edits may affect performance. At most 50 non-key columns can be selected at once, and 10 non-key columns for bulk applying generators. There is no bulk apply column limit for bulk rejecting or applying suggested generators.

Last updated

Was this helpful?