Forum Discussion
Solved
How to truncate a lakehouse table.
I have a multiple dataflowgen2 inserts data into the same lakehouse table. Before inserting data into lakehouse table, I would like to truncate the lakehouse table. How can I do that. The lakehouse t...
Notebook is the only option to drop the table right ?
Scott_Powell
Helper V
Helper VThat's exactly what I'm doing - running multiple jobs in parallel to populate a large table (in my case just over 1 billion rows). The first Gen2 dataflow does a "replace" which truncates the data, and then loads it's slice. After it's done, I launch the other Gen2 dataflows, all of which append in parallel.
Hope this helps,
Scott