Want to auto update table in Snowflake in case of schema drift.

[DivyaniP7768]

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

[miguel · Accepted solution]

Dataflow Gen2 in Fabric doesn't currently support Snowflake as a destination (target).

Please do share your feedback for having Snowflake as a destination in the Fabric ideas portal (https://aka.ms/FabricIdeas) 

[DivyaniP7768]

@miguel  I am using Azure Data factory

[miguel]

Makes sense! This forum is only for topics related to Microsoft Fabric. The Dataflow available in Microsoft Fabric Data Factory is different from the one available in Azure Data Factory.

Do feel free to post this question in the Azure Data Factory forum (link below):

https://techcommunity.microsoft.com/category/azuredatabases/discussions/azuredatafactory