Assign table modes to source database tables

Requires the Advanced API. The Advanced API requires an Enterprise license.

By default, each table is assigned the Masked (De-Identify) table mode.

To change the assigned table mode for a set of tables, use:

POST /api/Workspace/{workspaceId}/bulk_table_mode

The request provides a list of tables to update, and the table mode (tableModeEnum) to assign to those tables.

For example:

{
  "tables": [
    {
      "schema": "public",
      "table": "customers_legacy"
    },
    {
      "schema": "public",
      "table": "legacy_wo"
    }
  ],
  "tableModeEnum": "Truncated"
}

The available values for tableModeEnum are:

  • Masked - Indicates to use De-Identify table mode.

  • Synthesized - Indicates to use Scale table mode. Note that for Scale mode, you can specify a number of rows to generate. The default is 100. You cannot use the API to set the number of rows. You must use the Tonic Structural application.

  • Truncated - Indicates to use Truncate table mode.

  • PreserveDestination - Indicates to use Preserve Destination table mode.

  • Incremental - Indicates to use Incremental table mode. Note that for Incremental mode to work, you must specify a date updated column to use. You cannot use the API to select the column. You must use the Structural application.

For more information about each table mode, go to Table modes.

Last updated