Operations allows to manage and troubleshoot the data pipeline, control the synchronization process, and handle the schema changes. To manage the data ingestion pipeline, navigate to the Operations tab.

Select the following according to your requirements.

1. On/Off toggle: Turns the scheduler on or off. When the scheduler is disabled, Ingest stops looking for changes in the source database.

   If the scheduler state changes either manually or automatically (e.g., after a service restart or user change to the toggle), a message appears next to the it explaining the reason for the state change (e.g., "Manual on", "Restore on startup").

   Same as the On/Off toggle in the Schedule section of the dashboard.

2. Full Extract: Trigger the initial bulk load for all the selected tables, except those marked as Skip Initial Extract. Every Ingest pipeline must undergo a full extract at least once to begin with.

3. Sync New Tables: Trigger the initial bulk load for tables marked as Redo Initial Extract and newly added tables in an ongoing replication. This operation cannot replace a full extract.

4. Sync Struct: Compare and fix the table structure in the destination database. Load fails if the schema changes. The operator identifies when the load started failing and rolls back to a point just before the initial failure. During this operation, Ingest compares and updates the structure of the destination table without losing data. If a significant amount of time has passed or the log file is unavailable, triggers a Redo Initial Extract to sync the table.

5. Rollback: Replay logs from a specific point to reapply changes to the destination. If the primary key columns are correctly selected, there should be no duplicates in the destination table. Rollback affects all tables in the selected list.

6. Manual Delta : Triggers a manual delta extract to process incremental changes.