topic Re: Unable to run sql alert task using databricks job using service principal in Data Engineering

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

GANAPATI_HEGDE — Tue, 28 Oct 2025 03:59:31 GMT

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?

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

szymon_dybczak — Tue, 28 Oct 2025 07:04:26 GMT

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.

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

GANAPATI_HEGDE — Tue, 28 Oct 2025 07:16:50 GMT

Where do i pass the service principal name?

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

GANAPATI_HEGDE — Tue, 28 Oct 2025 07:18:04 GMT

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

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

szymon_dybczak — Tue, 28 Oct 2025 07:44:16 GMT

Hi,

It's described at their REST API docs:

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

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

GANAPATI_HEGDE — Tue, 28 Oct 2025 08:02:18 GMT

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

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

szymon_dybczak — Tue, 28 Oct 2025 08:30:26 GMT

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:

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

GANAPATI_HEGDE — Tue, 28 Oct 2025 08:41:59 GMT

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

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

szymon_dybczak — Tue, 28 Oct 2025 08:54:11 GMT

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