Auto update of table in target(Snowflake) when source schema changes(SQL).

Hi,  So this is my use case: I have source as SQL server and target as Snowflake. I have dataflow in place to load historic and cdc records from sql to snowflake.I am using inline cdc option available in dataflow for cdc which uses sql's cdc functionality. Now the problem is some tables in my source have schema changes very often say once a month and I want the target tables to alter based on schema change. 

Note : 1. I could only found dataflow for loading since we dont have watermark columns in sql tables.

2.Recreating the table in target on each load is not an good option since we have billions of recors altogether . 

Please help me with solution on this .

Thanks