Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hi all!
Is possible to set the cursor manually? My cursor is timestamp. I want to re-sync only one day.
I'm using source Oracle DB to Redshift.

Not using the UI, but you can manually edit the entry in the airbyte-db container.

Interesting, it's any documentation to follow it?

No, you need to access the database and find where to change: `docker exec -ti airbyte-db psql -U docker airbyte`

Hi <@U01MMSDJGC9> I enter to the database and find the jobs that I want to change the cursor.

Do I need to change all the field of config, right?  or can I access directly to the cursor? I'm using the tables `jobs`
``` {"sync": {"state": {"state": {"cdc": false, "streams": [{"cursor": "2021-10-31T00:00:00Z", "stream_name": "PROMOCIONESGENERADAS", "cursor_field": ["Fecha"], ....```

Hi <@U01MMSDJGC9> first thanks for your help. I was able to change the value of the cursor with your guide in the other thread.
But now when I run the next sync, my cursor is the same, it has not changed.
I change it in `jobs` table and in `attemps` table. What could be wrong?

I run again and now it's working, Airbyte takes the changes in the cursor. :airbyte-fire:
What I should expect if my connection is incremental+deduped? only have unique registries?