Can I Set Different Sync Frequencies for Source Polling and Destination Writes?
Question
Can I pull data from my source every 15 minutes but write to my destination only every 12 or 24 hours to reduce destination compute costs?
Environment
All connectors and destinations
Answer
No, Fivetran doesn't support separate schedules for source polling and destination writes. Each sync runs as a single end-to-end process. When you set a sync frequency, such as every 15 minutes, Fivetran:
- Queries the source.
- Processes any data changes.
- Writes updates to the destination.
These steps run together and can't be separated into different schedules. Fivetran doesn't provide a built-in option to buffer incremental source data and write it to your destination later in batches.