A Source Table is a partial representation of a table you provide to Provably, which will be referenced during the collection creation process. It acts as a master collection or a view of your existing database table. This feature allows you to select which columns to include in the Provably system and which to exclude.

Viewing Source Tables

To see all source tables linked to a specific data source, click on the corresponding data source record. This will expand a collapsible section displaying the source tables. In this table, you will find:

• Source Table Name: The custom name you assigned.
• Schema: The schema associated with the source table.
• Actual Table Name: The name of the referenced table from your database.
• Connection Status: Indicates the current status of the connection.

To the right of each source table entry, you'll find action buttons for editing or deleting that source table.

Adding a Source Table

To create a new source table, click the Add Source Table button. A modal will appear, allowing you to configure the new source table under a specific data source connection. In the modal:

1. Name Your Source Table: Enter a name of your choice.

2. Provide Table Information:

• Schema Name
• Table Name
• Column Names and Their Types

To add a new column, click the Add New button. To remove a column, click the trash bin icon located next to the column type input. For each column, after entering the name, click on the input labeled "Select Column Type" to choose from a list of common column types.

Once you are satisfied with your configuration, click Save. If you've provided valid schema and table names along with the correct column types, your new source table will be ready for use. If there are any issues, an error message will be displayed in the modal, and the source table will not be added.

The system continuously checks the configuration for accuracy. If any changes affect the validity, the source table status will update to "Invalid Configuration," notifying you of the issue.