What would be the best practice to automate the cursor change. Make a python script that runs inside the server?
Manual process reference: update-cursor
The steps you should perform would be:
- Login to the Airbyte database.
- Select the connection
- Apply the query that does the update
This would be executed with a cron.