add new field using dataflow2 storing to lakehouse

[amien]

i have a dataflowgen2 which stores the data into a lakehouse. Works all fine. It adds data on a daily basis

This all works fine.

However, i want to add a new column to my lakehouse, however, i don't see any option to do so. Do i actually need to drop the whole table in the lakehouse and re-created it again? any other options? 

[Anonymous · Accepted solution]

Hi @amien,

I'd like to suggest you open the dataflow then enter to the query editor and manually check and modify the existed query steps which cached the table structures to add new fields to it. If these operations also not works, you can try to re-create a new one.

Regards,

Xiaoxin Sheng