how to set jobs permission with rest api

guostong — Mon, 31 Jul 2023 15:51:08 GMT

create job with cli, but can not set the permission with cli,
have to use rest api to set permission:
https://docs.databricks.com/api/workspace/permissions/set

below is my command in windows to set permission:
curl -X PUT https://my-workspace-url.azuredatabricks.net/api/2.0/permissions/jobs/my-job-id^
-H "Authorization: Bearer my-personal-token" ^
-H "Content-Type: application/json" ^
--data "{\"access_control_list\":[{\"user_name\": \"xxx@company.com\", \"permission_level\": \"CAN_VIEW\"}]}"

I got below error message:
{"error_code":"INVALID_PARAMETER_VALUE","message":"The job must have exactly one owner."}

anybody have the experience?

Thanks,

Re: how to set jobs permission with rest api

youssefmrini — Tue, 08 Aug 2023 16:14:07 GMT

This error message occurs because the Databricks REST API requires that every job have exactly one owner. When you try to set permissions using the API, you are required to specify the owner of the job using the owner field in the job metadata.

To resolve this issue, you need to make sure that the job has exactly one owner specified in the job metadata. You can update the job metadata using the Databricks CLI or API. Here is an example of how to update the job metadata using the Databricks API:

text

# set variables
TOKEN="<databricks-token>"
JOB_ID="<job-id>"
USERNAME="<username>"

# get current job metadata
JOB_META=`curl -s -X GET -H "Authorization: Bearer ${TOKEN}" "https://<databricks-instance>/api/2.0/jobs/get?job_id=${JOB_ID}"`

# parse job metadata
JOB_META_JSON=$(echo "${JOB_META}" | jq '.job')

# set owner in job metadata
JOB_META_JSON=`echo "${JOB_META_JSON}" | jq ".owner_username=\"${USERNAME}\""`

# update job metadata
curl -s -X POST -H "Authorization: Bearer ${TOKEN}" "https://<databricks-instance>/api/2.0/jobs/reset" \
-d "{\"job_id\": \"${JOB_ID}\", \"new_settings\": ${JOB_META_JSON}}"

This script uses the curl command and the jq command-line JSON processor to retrieve the current job metadata, add the specified owner to the job metadata, and then update the job with the new metadata.

Replace <databricks-token> with your Databricks token, <job-id> with the ID of your job, and <username> with the username of the owner you want to set. This script will update the job metadata to set <username> as the sole owner of the job.

After setting the owner in the job metadata, you should be able to set permissions using the Databricks REST API without encountering the "The job must have exactly one owner." error message.

Re: how to set jobs permission with rest api

guostong — Tue, 05 Sep 2023 15:40:19 GMT

thank you, the new permission list should be a whole list, not the new permission

topic how to set jobs permission with rest api in Data Engineering

how to set jobs permission with rest api

Re: how to set jobs permission with rest api

Re: how to set jobs permission with rest api