After sampling your endpoints, you can customize your schema from the default mapping, including modifying the column names, data type mapping, and primary key designation:

  1. In the left pane, expand your sampled request to expose a list of your relational tables.
  2. Under the table you want to edit, expand the list to expose the table columns.
    Note: By right-clicking the table name, you can also edit the table name or delete the table.
  3. Right-click on the column you want to edit; then, select Modify Column Attributes.
    Note: By right-clicking the table name, you can also add or delete columns in the table.
    Note: When designating a new primary key, you can query the INFORMATION_SCHEMA.SYSTEM_SAMPLING_STATUS system table for a list of potential primary key candidates. See "Determining the primary key" for more information.
  4. In the Modify Column Attributes window, edit the fields to your preferences.
  5. Click Save to accept your changes.