cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Help
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Permissions on job with SQL task

stravi001
Visitor

yesterday

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.

0 Kudos
1 REPLY 1

stravi001
Visitor

4 hours ago

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.

0 Kudos
Announcements