cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Permissions on job with SQL task

stravi001
Visitor

Hello,

I am authenticated as GCP service account. I have to create query, run job as service principle and get result.

I'm both cases, I set permissions CAN_MANAGE for group "users" for both query and job. When I create the query with RunAsMode.OWNER, it gets limited permissions of invoker SP, but I can then access output of the task. When I create query with RunAsMode.VIEWER it gets required permissions of RunAs SP, but I am not able to access output of the task. I get error: insufficient privileges to access object queryExecutionSessions/*. As I understand from the roles description, it should have permissions with CAN_MANAGE.

Thank you for help.

1 REPLY 1

stravi001
Visitor

To make my question simpler. I have created Query with my personal account. I have set run as mode to viewer. I run it in task under SP, it succeeds, but I (as query owner) am not able to see output of that task, telling me I have no permissions for the query.