Hi @werners, i tried that option as well. But it will create a managed table. But i want a external table. So now i created a external table prior to the streaming part.

What i understand from the research i did is, we cannot write to external table in writestream query.