Question

Is it possible to connect Fivetran to a database source that is restored periodically from a backup of another database?

Environment

Database Connectors

Answer

No, you cannot connect Fivetran to a database source that is restored periodically (for example, every night or every hour) from a backup of another database. Restoring the source database from a backup causes Fivetran to perform a complete re-sync, which may never complete if you perform a restore every day. More info here.