Just to be clear we are using managed delta table not external table. I am not sure if above solution will still work. Thanks very much for your feedback