Forum Discussion
009co
3 years agoHelper IV
Dataflow Gen 2 dataflow queries with PIVOT long running, never return results
My Dataflow Gen 2 dataflow query does following: * Sources from 4 Lakehouse tables each with 3 columns - datetime, string, number. * Appends 4 tables as new (about 4,500 rows total). * Pivot ne...
009co
3 years agoHelper IV
Hey miguel, it appears that Dataflow Gen 2 simply cannot do the pivot transform. My guess is that it is related to lack of resources. But maybe it is just on my trial account? But are you able to use the data I linked below to replicate my steps?
miguel
3 years agoCommunity Admin
Hey! sorry for the late reply.
We're working on some improvements to the overall architecture behind the scenes. Will update this thread once I have more information that I can share, but thanks for sharing the info!