Issue with incremental sync in Airbyte after updating user credentials and removing schema

Summary

User is facing an issue with incremental sync in Airbyte after updating user credentials and removing schema. They are trying to understand why a full refresh is not initiated and how to completely clear the initial data.


Question

Good morning Everyone,

In the latest Airbyte version, I updated the user credentials. In my postgres DB I removed the schema previously pushed to, and the related _airbyte schema. After running a sync, I anticipated that those configured with incremental append and deduped would initiate a full refresh at the beginning, but it seems that’s not the case. Can you help me understand what’s going on? How do I completely clear the initial data?



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["incremental-sync", "user-credentials", "schema-removal", "full-refresh", "clear-initial-data"]

Did you try to delete the state obejct in the Settings page?

Hi <@U01MMSDJGC9> , I’m not sure what that is, I don’t see anything like that on my settings page.

Please see the snip attached.

Okay, no I didn’t. Do I clear it out?

I tried to, but once I save, it automatically refills with the same json data. In general, I noticed that the clear data option isn’t working currently