Did anyone found an automated way to schedule full...
# ask-community-for-troubleshootinga
Antoine Balliet
05/24/2023, 5:45 PMDid anyone found an automated way to schedule full refresh on incremental sync ?
-> This would be useful to reduce data inconsistencies over time when a lot of records are synced
I thought about resetting cursor using SQL. Is there a smarter way ?
k
kapa.ai
05/24/2023, 5:45 PMA message from kapa.ai
kapa.ai
05/24/2023, 5:46 PMHmm, I don't know enough to give you a confident answer yet. However, you can refer to the Airbyte documentation on [incremental data synchronization](https://airbyte.com/tutorials/incremental-data-synchronization) and [connections](https://docs.airbyte.com/understanding-airbyte/connections) for more information on how to manage your syncs.
e
Erica Struthers
05/24/2023, 6:04 PM
Hi Antoine, to my knowledge this is not possible today but I would be happy to submit this as a feature request. If you wouldn't mind providing more detail on the workflow reasoning for this request this will help us understand the use case.
👍 1
y
Yusuf Mirkar
05/24/2023, 6:18 PMI would suggest , suppose if your cursor is timestamp, update the timestamp of all rows to now()
can drop the column & re-add with default now() instead of update query
👀 1
Yusuf Mirkar
05/24/2023, 6:18 PMtest on local installation first but
👀 1
a
Antoine Balliet
05/24/2023, 7:07 PMShould I create an issue on Github for this ? @Erica Struthers
Antoine Balliet
05/24/2023, 7:07 PM(and try to provide some first solutions)
Antoine Balliet
05/24/2023, 7:07 PMDid not find related issue
e
Erica Struthers
05/24/2023, 7:08 PM
a
Antoine Balliet
05/24/2023, 7:52 PMStill WIP to detail the workflow but I created it : https://github.com/airbytehq/airbyte/issues/26513
✔️ 1