Hello all, I’m relatively new to Meltano and recently inherited a (fairly simple) extraction pipeline. I’ve been looking around and have had trouble finding clarification/guidance on what happens when the data source schema changes and how best to manage those situations. In my case I’m using a binlog-based incremental replication strategy with tap-mysql into a snowflake target. What happens when a source table adds a new column? e.g. will existing entries in the target be updated? Is there a different story for other kinds of alterations like removing or altering a column? In what situations might I need to manually trigger a full resync of a table? Thanks!

@mark_gordon assuming you’re using the transferwise variant checkout the advanced topics section at the bottom of the hub page https://hub.meltano.com/loaders/target-snowflake#advanced-topics