Assign table modes and filters to source database tables
Last updated
Was this helpful?
Last updated
Was this helpful?
Each table is assigned a , which determines at a high level how to populate the table in the destination database.
Some data connectors also support , which use a WHERE
clause to restrict the table records to include.
You can use the API to set table modes and table filters.
To get the current assigned table modes and table filters for a workspace, use:
GET
The response contains the list of tables. For each table, the list includes the assigned table mode and, if applicable, the table filter.
To set the assigned table modes and table filters for a workspace, use:
POST
The request provides the list of tables. For each table, the list includes the table mode to assign and, if applicable, the table filter.
For example:
The available values for tableMode
are:
Masked
- Indicates to use De-Identify table mode. This is the default 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.
To assign the same table mode to a set of tables, you can use:
The request provides a list of tables to update, and the table mode (tableModeEnum
) to assign to those tables.
For example:
The available values for tableModeEnum
are:
Masked
- Indicates to use De-Identify table mode. This is the default 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 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.