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

Airbyte

Is there a way to resync just a single table from scratch? I have Connection with multiple tables, and I'm using `Incremental | Deduped history` for most of them. However, one of the source tables was manually edited by a user, and we need to resync it from scratch. If I delete the destination table (in BigQuery), will Airbyte be smart enough to recreate the table and sync it from the start?

OK, it looks like I'll need to manually reset the state of this stream in Airbyte database. Any pointers on how to do this please?

OK, making some progress - it looks like there is a table called `state`, and I can see there is a record for each connection. Within each record, there is a `state` field that contains json. Do I just need to remove this from the json?
```{"cursor": "2022-06-29T10:37:24Z", "stream_name": "cart_revisions", "cursor_field": ["updated_at"], "stream_namespace": "foo"}```

Yes! Omg, I don't believe it, but it actually worked :joy: