Search
K
Links

Assign table modes to source database tables

Requires the advanced Tonic 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:
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 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 Tonic application.
For more information about each table mode, see Table modes.