Question

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

Environment

Connector: 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 re-sync when it is selected again. The table level re-sync 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 re-sync. 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 re-sync.

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.