https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
b

Boggdan Barrientos

12/10/2021, 7:38 PM
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.
1
u

[DEPRECATED] Marcos Marx

12/10/2021, 11:55 PM
Not using the UI, but you can manually edit the entry in the airbyte-db container.
b

Boggdan Barrientos

12/11/2021, 6:49 PM
Interesting, it's any documentation to follow it?
u

[DEPRECATED] Marcos Marx

12/14/2021, 12:36 AM
No, you need to access the database and find where to change:
docker exec -ti airbyte-db psql -U docker airbyte
b

Boggdan Barrientos

12/28/2021, 12:17 AM
Hi @[DEPRECATED] Marcos Marx 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
Copy code
{"sync": {"state": {"state": {"cdc": false, "streams": [{"cursor": "2021-10-31T00:00:00Z", "stream_name": "PROMOCIONESGENERADAS", "cursor_field": ["Fecha"], ....
u

[DEPRECATED] Marcos Marx

12/28/2021, 12:23 AM
change only the cursor
b

Boggdan Barrientos

12/30/2021, 5:58 PM
Hi @[DEPRECATED] Marcos Marx 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. 🔥 What I should expect if my connection is incremental+deduped? only have unique registries?
5 Views