Hello, everyone! Is that possible to migrate a connection destination from snowflake account A to B, copying synced data into account B and keeping sync status?

Migrating a connection destination from Snowflake account A to account B in Airbyte—while copying synced data and preserving sync status (state)—is not directly supported as a built-in, automated feature. However, you can achieve this with a combination of manual steps: 1. Copy Data from Account A to B: You need to manually copy the relevant tables (including raw and final tables) from Snowflake account A to account B. This can be done using Snowflake's data export/import tools or SQL commands outside of Airbyte. 2. Recreate the Destination in Airbyte: In your Airbyte instance, create a new destination pointing to Snowflake account B. Then, create a new connection (or update the existing one) to use this new destination. 3. Preserve Sync Status (State): To avoid re-syncing all historical data (especially for incremental syncs), you need to transfer the connection state. - In Airbyte, you can access the connection state from the existing connection (Settings → Advanced settings). - Copy the state from the old connection and set it in the new connection pointing to account B. This ensures incremental syncs continue from where they left off, rather than starting from scratch. This process is described in the context of dual-writing and migration between instances, but the same principle applies when changing destinations, as long as the data and state are consistent between the two accounts. See: [Upgrading Connections One by One with Dual-Writing](https://docs.airbyte.com/release_notes/upgrading_to_destinations_v2#upgrading-connections-one-by-one-with-dual-writing). Important Caveats: - Airbyte does not automate the data copy between Snowflake accounts; you must handle this outside of Airbyte. - The state transfer is a manual process and requires careful handling to ensure no data is missed or duplicated. - If the schema or data structure changes during the migration, you may need to adjust downstream models or transformations. Summary: Yes, it is possible, but it requires manual data migration and careful state management. There is no one-click migration for this scenario in Airbyte as of now. For more details, refer to the official documentation on [dual-writing migration](https://docs.airbyte.com/release_notes/upgrading_to_destinations_v2#upgrading-connections-one-by-one-with-dual-writing).