Hi all 🙂
MySQL ---> Snowflake issue/question.
What’s the correct way of moving an Airbyte Snowflake table from an old destination schema to another?
I don’t wanna resync the entire set of data since some of the tables may be very big.
The behavior at the moment with AB v.40.17 and mySQL connector v.1.0.13:
1. Original schema contains 2 destination tables: X and X_SCD.
2. Once I change the destination schema, new tables are created. X contains only the increment and X_SCD only the increments with no former versions.
Is moving the old data manually from the new schema to both of these tables the right way to go here?
I would appreciate any kind of feedback.
Thanks!