Skip to main content

Manage Tables

When you create a new extraction, you are automatically directed to the Tables page. This page lists all the source tables or SQL queries included in the extraction and allows you to configure the data to retrieve from your source system. By default, no tables are listed until you add them to the extraction.

To refresh the table list, select Refresh in the upper-right corner of the page.

tip

To check the load status of a table, select it and then choose the Table status icon in the upper-right corner.

Column overview​

ColumnDescrciption
Table sourceDisplays the source table or query name from the connected data source.
TypeShows whether the row is a standard table or an SQL query.
Table descriptionDisplays the table description from the source system, if available.
Table destinationDisplays the destination table name.
FilterIndicates any filter applied to limit data retrieved from the source table.
Post Execution ScriptDisplays or links to scripts that run after data is loaded for that table.
FieldsShows the number of fields included for the table. Select the number to view or change the field mapping.
Unique KeyDisplays the field(s) used as the primary identifier for each record.
Tracking KeyDisplays the field(s) used to track record changes for incremental loads.
IndexesShows the number of indexes defined for the table. Select the number to view or edit indexes.
TransformationIndicates whether any transformations are applied to the table data.
PartitionIndicates whether load-by-partition is enabled for the table. A checkmark appears if enabled.

Add tables​

  1. From the welcome screen or left navigation pane, select Extractions.
  2. Select an extraction from the list.
  3. Select the link under the Tables column.
  4. Click New, then choose Add Tables.
  5. Select the tables to retrieve data from.
  6. Click Save. The tables are added to the list.
  7. (Optional) For each table, enter a table description, and cahnge the table destination name, then click Save.
  8. (Optional) Apply filters to individual tables.

note

By default, adding a table includes all fields and indexes from the source.

Migration extraction tables​

Purge a table​

Purging clears table records based on a condition before loading new data.

  1. Select a migration extraction from the list.
  2. Click the link under the Tables column.
  3. Select a table, and click the pencil icon under the Purge Condition column.
  4. In the warning message, click Confirm.
  5. In the SQL Expression Builder, enter the purge condition. You can use variables as values.
    DELETE FROM [DESTINATION_TABLE]
        WHERE <PURGE_CONDITION>
  6. Click Save.

Duplicate a table​

Duplicating copies a table's configuration and fields, creating a new table entry to be customised.

  1. Select a migration extraction from the list.
  2. Click the link under the Tables column.
  3. Select the table you want to duplicate, then click the Duplicate Table icon in the upper‑right corner.

Delete a table​

  1. Select an extraction from the list.
  2. Click the link under the Tables column.
  3. Select the table to delete.
  4. Click the Delete Table icon in the upper‑right corner.
  5. In the confirmation message, click Confirm.

note

Deleting a table also removes all related indexes and fields. This action cannot be undone.