Unable to run sql alert task using databricks job using service principal

[GANAPATI_HEGDE]

I am trying to run a SQL alert task in data bricks job, Service principal is the run_as as set to the job, and task fails with below error message.

 I also checked if SPN can be granted permission on SQL alert and SQL query, turns out only user id or AD group can be granted permissions.  Has anyone seen this error before?

[szymon_dybczak]

Hi @GANAPATI_HEGDE ,

According to docs:

• For service principal: Set service_principal_name to the application ID. Requires the servicePrincipal/user role. If not specified, the alert will run as the request user.

So instead of using service principal name try to pass application ID.

[GANAPATI_HEGDE]

Where do i pass the service principal name?

[GANAPATI_HEGDE]

Can you share the docs as well so that i can read about it?

[szymon_dybczak]

Hi, 

It's described at their REST API docs:

Create an alert | Alerts V2 API | REST API reference | Databricks on AWS

[GANAPATI_HEGDE]

It doesnt really explain where to set the run as username for alerts, when i check in the jobs UI, i dont see option to set run_as as well

[szymon_dybczak]

Create Alert in regular way. After your alert is created:

1. Go to Alerts

2. Select your alert

3. Click pencil next to run as to edit:

4. Provide application id of your service principal and clik save:

[GANAPATI_HEGDE]

unfortunately, only these options are available in my UI, is it the new UI?

[szymon_dybczak]

Yes, it seems that you're  using legacy alerts:

What are legacy alerts? | Databricks on AWS

To switch to alerts v2 follow this guide:

Databricks SQL alerts | Databricks on AWS