One for those with an under-the-hood understanding here. Two questions:
1. Should "reset your data" empty SCD tables?
2. Does "reset your data" empty SCD tables?
The documentation doesn't mention one way or the other and a Google search is proving inconclusive (suggesting that it maybe it should, but that it doesn't).
Bonus third questions:
3. Does Airbyte hold any data relating to tables locally?
I ask this question because I've got duplicate errors in normalization that are solved by resetting my data, but I can only rationalize this to myself as a solution if the sync is testing against values (cursor seed values possibly?) stored within Airbyte itself and not derived from the destination data.
Stuart