Unable to add column comment on a View. Any way to update comments on multiple columns in bulk?

prasad_vaze
New Contributor III

I noticed that unlike "Alter Table" there is no "Alter View"  command to add comment on a column in the existing view. This is a regular view created on Tables (and not Materialized view).  

If the underlying table column has comment then the View inherits it but I want to update that only on View column. I am owner of the tables and View. Has anyone solved this or is this a gap in functionality or bug?

Alternatively ,Is there a way to mass apply or upload column comment on multiple columns across Tables or Views? I have a spreadsheet with column descriptions and want to mass apply /upload in Unity catalog instead of "Alter Table" command for each column