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.

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.