Summary/Reported Issue
I am attempting to update the owner of a virtual dataset using the Dremio API. Using the PUT method, the call to api_url/api/v3/catalog/{object_id) returns a 200 response; however, ownership appears unchanged in the UI. The payload (data) contains the updated owner_id in the full object definition. How can I update an object's owner using the Dremio API?
Relevant Versions
Dremio 25.2.x
Troubleshooting Steps
- We confirmed the JSON file passed in the REST call was a properly formatted file.
- We were able to replicate internally the behavior, meaning that sending an update to an object did not update the owner of said object.
Cause
- We were able to confirm that the catalog API does not support changing the owner of an object.
Steps to Resolve
In order to update the owner of an object through the API you would need to use the SQL endpoint and simply run the respective GRANT command as if you were doing it in the Dremio UI.