topic Re: Databricks Job API: The job must have exactly one owner in Data Engineering

Databricks Job API: The job must have exactly one owner

ameet9257 — Tue, 19 Nov 2024 03:07:12 GMT

Hi Team,

I'm trying to set the Job Permission using the Databricks Job API but getting the below error.

{

"error_code": "INVALID_PARAMETER_VALUE",

"message": "The job must have exactly one owner."

}

I first tried to get the job permission using the below API.

GET https://adb-xxxxxxx.10.azuredatabricks.net/api/2.0/permissions/jobs/18660

Below is the response I received.

I used these details along with new permission to apply for the Job.

PUT https://adb-XXXXXXXXXX.10.azuredatabricks.net/api/2.0/permissions/jobs/18660

Body:

Response:

Let me know if anyone has faced the same issue.

#databricks #jobs #api

Re: Databricks Job API: The job must have exactly one owner

ameet9257 — Tue, 19 Nov 2024 03:27:46 GMT

Hi Team,

Right after this post, I tried to monitor the network log by inspecting an element from the UI Browser and found that the UI API is taking different parameters.

{"access_control_list":[{"user_name":"xxxxxxx@xxxxxx.com","permission_level":"IS_OWNER"},{"group_name":"data-scientists-dev","permission_level":"CAN_MANAGE"}]}

Then I used the same body param and was able to set the permission.

If you guys have any other inputs please do share.

Re: Databricks Job API: The job must have exactly one owner

Andolina — Fri, 03 Jan 2025 17:30:43 GMT

Thank you for the solution Amit. I have been trying to update the permissions for my workflows since 1 day. I came across your post, changed the structure of the payload and it worked fine. So basically when you do a get request to fetch the ACLs, you get :

'access_control_list': [{'user_name': 'xyz@abc.org', 'display_name': 'Xyz, Fgv', 'all_permissions': [{'permission_level': 'IS_OWNER', 'inherited': False}]}]

But while updating, you need to discard the 'all_permissions' list and add everything inside in the dict. I wonder why it works this way when while fetching the ACLs we get it with the 'all_permissions'.

Also I have seen if there are any inherited ACL, we do not have to mention that in the payload. It take the permission for that group (eg. admin) automatically.

Regards,

Andolina

Re: Databricks Job API: The job must have exactly one owner

NR_Modugula — Thu, 09 Jan 2025 05:58:06 GMT

Hi , I have tried the same approach but it ddint work for me. Iam using api/2.0 with PUT Request