Will Fivetran Generate an Error if I Drop a Table in the Destination?

Question

Will Fivetran generate an error or alert if I drop a table from the destination?

Environment

All destinations

Answer

No, we don't generate errors, alerts, or notifications when you drop a table from the destination database. If the table still exists in the source when the next sync runs, we will re-create it. However, we will only sync data that has been added or changed since the last sync, and we won't perform a full re-sync.

To fully restore the data, you must re-sync the table or connection.