Database View

The Database View is the easiest way to get an overview of your entire source dataset and quickly perform multiple table and column level operations. This view split into two sections: Tables and Columns. We're going to briefly discuss the interaction between the two sections and then talk about the features in each section independently.

When no tables (or all tables) are selected, all columns are shown in the columns section on the right. If one table, or a few tables are selected, the columns for these tables are show first, and then "Other Columns" are listed below.

Note: To select multiple tables hold down the Alt (Command on Mac) key and click on each table.

Tables

  1. Filter listed tables to a search term

  2. Filter listed tables based on Table Modes. See the Table Modes section for more details on these options.

  3. Perform a bulk edit to change all selected tables to a table mode.

  4. Change the table mode for a specific table.

  5. Open this table in Table View‚Äč

Columns

  1. Filter columns by these categories:

    Sensitive / Not Sensitive: as marked by the privacy scan

    Protected / Not Protected: Columns that have a generator applied and columns that belong to a table that has been truncated

  2. Filter columns that pass the above filters by a search term

  3. Change the generator applied to this column

  4. When a generator has been applied to a column you can remove this generator (return to passthrough) by clicking the X

  5. Metadata associated with this generator

  6. Preview the data transformation applied to this column