Question

Does turning a table off/on in the dashboard cause a table-level resync?

Environment

Database and API connectors.

Answer

Database connectors:

Yes - If a table has been deselected within the Schema tab of the connector's dashboard, it will trigger a table-level historical resync when it is selected again. The table level resync will count towards MAR.

API connectors:

No - Deselecting a table in the Schema tab of the connector's dashboard will not trigger a table-level historical resync. The table will pick up from where it last left off and sync all data from the last time the cursor state was saved.

Cause

Database connectors:

Deselecting a table in the Schema tab of the connector's dashboard will remove the table from the state. When the table is reselected it will need to run a table-level historical resync.

API connectors:

Deselecting a table in the Schema tab of the connector's dashboard will pause the table's cursor within the saved state. When the table is reselected, it will pull in all data starting from the date that it was paused.