cancel
Showing results forĀ 
Search instead forĀ 
Did you mean:Ā 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forĀ 
Search instead forĀ 
Did you mean:Ā 

Unable to update view comment via SQL/API unless owner, but column comments work (Unity Catalog)

shadman140
Visitor

I’m working with Databricks Unity Catalog and observing an inconsistent permission behavior for views.

Scenario

  • A view exists that was created by another user

  • I have sufficient privileges on the catalog/schema/view (SELECT, MODIFY, ALL PRIVILEGES)

  • I can:

    • Query the view

    • Add column comments for view successfully using SQL editor in databricks UI and /statements api end point with COMMENT ON COLUMN query

    • Update the view comment via Databricks UI

  • But I cannot update the view-level comment via SQL editor in databricks UI or API

Question

  • Why Views is bound by this owner condition while table works with MODIFY permission only?
  • While documentation says, "Comment on column" will only work for owners but I am able to use it even when I don't own the view? 
0 REPLIES 0