Forum Discussion
Catalogging Table - Handling Email Attachments
Hi aputhuraya ,
Due to a lack of Data Manipulation Language (DML) support, it is not possible to insert rows into a delta table in Lakehouse.
I saw a case with a similar problem to the one you are experiencing:
Solved: store data from email attachment - Microsoft Fabric Community
His solution was to set up a query that looked at his Outlook account and copied attachments to lakehouse.
He used the “Data Destination” option in the “Query Settings” section of the data flow and selected “Append” from the update method options, which allowed him to add the new data to the lakehouse All-in-One.
You can try his method that will load the attachments in your email he table into lakehouse.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi aputhuraya ,
Due to a lack of Data Manipulation Language (DML) support, it is not possible to insert rows into a delta table in Lakehouse.
I saw a case with a similar problem to the one you are experiencing:
Solved: store data from email attachment - Microsoft Fabric Community
His solution was to set up a query that looked at his Outlook account and copied attachments to lakehouse.
He used the “Data Destination” option in the “Query Settings” section of the data flow and selected “Append” from the update method options, which allowed him to add the new data to the lakehouse All-in-One.
You can try his method that will load the attachments in your email he table into lakehouse.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!