Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have some dimension tables with a Time Updated column in Snowflake. I'd prefer to SELECT from Snowflake only the rows with a Time Updated since the last refresh; and UPDATE the table in the Lakehouse.
Is there a method with Data Flow Gen2 to do something like Data Flow Gen1's incremental refresh?
Hi @DarinSpence
In Power Query select the Date column and filtered to the last date.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
When I tried that with Data Flow Gen2 Append, I got new; duplicate rows 😕