How can I “reset connection state”

To reset the connection state in Airbyte, you can follow these steps: 1. In the Airbyte UI, click on Connections and then click on the connection you want to modify. 2. Click on the Settings tab on the Connection page. 3. Click on the Advanced dropdown arrow. The Connection State displays. To edit the connection state: 1. Click anywhere in the Connection state to start editing. 2. Confirm changes by clicking "Update state". Discard any changes by clicking "Revert changes". 3. Confirm the changes to the connection state update. Please note that updates to the connection state should be handled with extreme care. Updates may break your syncs, requiring a full historical sync of your data to fix. Make changes only as directed by the Airbyte team. In some cases, you might need to use the API to update the state of the connector. You can find more information about this in the [API documentation](https://airbyte-public-api-docs.s3.us-east-2.amazonaws.com/rapidoc-api-docs.html#post-/v1/state/create_or_update). Also, note that in the newer versions of Airbyte, the

Reset

functionality has been replaced with

Clear

to reduce confusion.

Clear

performs the same removal of the state, but does not trigger a sync afterwards. You can read more about this in the [Clear documentation](https://docs.airbyte.com/operator-guides/clear). Sources: - [Managing Airbyte Cloud](https://docs.airbyte.com/cloud/managing-airbyte-cloud/manage-connection-state) - [Forum Post: Connector state appears to be doubled up](https://discuss.airbyte.io/t/2024) - [Release Notes April 2024](https://docs.airbyte.com/release_notes/april_2024#platform-releases)

@kapa.ai Saved offset is before replication slot’s confirmed lsn. Please reset the connection How do I reset the connection?

To reset the connection in Airbyte, you need to follow these steps: 1. Select Connections in the main navbar. 2. Select the connection(s) affected by the update. 3. Select the Replication tab. 4. Select Refresh source schema. 5. Select OK. Any detected schema changes will be listed for your review. 6. Select Save changes at the bottom of the page. Ensure the Reset all streams option is checked. 7. Select Save connection. This will reset the data in your destination and initiate a fresh sync. For more information on resetting your data in Airbyte, you can refer to [this page](https://docs.airbyte.com/operator-guides/clear). Please note that resetting the connection will initiate a fresh sync, which means all the data in your destination will be reset. Sources: - [Monday Migration Guide](https://docs.airbyte.com/integrations/sources/monday-migrations#refresh-schemas-and-reset-data) - [Mailchimp Migration Guide](https://docs.airbyte.com/integrations/sources/mailchimp-migrations#refresh-affected-schemas-and-reset-data)