Merging Airbyte internal tables for streams in Snowflake destination v2


When upgrading to Destination v2 in Snowflake, there are two Airbyte internal tables for streams with different separators. The user wants to merge them into a single table per stream.


I upgraded an incremental connection with a Snowflake destination to Destination v2. I copied the existing airbyte internal data to the expected new structure. I now have two airbyte internal tables for streams. (One with double underscore and one with triple underscore separators. ie, public_raw__stream_source and public_raw___stream_source). How can I safely merge the two airbyte internal tables so there is only one per stream?

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

["merge", "airbyte-internal-tables", "snowflake-destination-v2", "stream"]