Thanks Daniel, that worked

i also had a workaround going with an alter table set tblproperties (optimizewrite = true) which I have set as a default anyway. But just touching the table triggered a metadata refresh

i prefer your command tho as that is its primary purpose