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

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

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"]
2

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

3

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.

4

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

5

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

6

Oh sorry in the connection page