Configure Table/s from Database

To select one or more tables:

• Select the Connection Name from the drop down menu.

• Select the desired schema.

• Select the checkboxes for all the tables that need to be validated.

• Click on Add Selected at the bottom.

Select Tables

Advanced Options

For large tables, it is recommended to provide a partition column so Vexdata can pull the data in parallel. Vexdata can autodetect the partition column; however, it is recommended that users provide this partition.

Rules for selecting the partition column :

• The column should have an index.

• The column should be numeric or a date-column.

• If the column is of string-type, ensure the bucket size is not too low for a distinct value.

  • Example : If you have to choose between city and person_name, select city as partition column, as person_name is highly unique.

Partition Properties