# 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.

<figure><img src="https://2027008842-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaO8uOTM2rdJeIbVeXK0c%2Fuploads%2FlFDTEeFcSdh2Cg3OP8Tt%2Fimage.png?alt=media&#x26;token=3a4cf970-9d16-4045-b08c-d55c5601d008" alt=""><figcaption></figcaption></figure>

#### 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.

<figure><img src="https://2027008842-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaO8uOTM2rdJeIbVeXK0c%2Fuploads%2FGlYidnIK1oqTEgH5NTDL%2FScreenshot%202024-12-16%20211448.png?alt=media&#x26;token=83c7b985-f741-4e90-ae46-140a4c0551f1" alt=""><figcaption><p>Partition Properties</p></figcaption></figure>

{% embed url="<https://youtu.be/fUi9JzBE0oQ>" %}
