topic Re: Want to auto update table in Snowflake in case of schema drift. in Dataflow

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

DivyaniP7768 — Fri, 30 May 2025 14:49:03 GMT

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

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

miguel — Fri, 30 May 2025 20:48:43 GMT

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)

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

DivyaniP7768 — Mon, 02 Jun 2025 05:27:24 GMT

miguel I am using Azure Data factory

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

miguel — Mon, 02 Jun 2025 19:28:28 GMT

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