Teammate cannot edit bigquery scheduled query

Question

I created a scheduled query in bigquery and I want my teammate to be able to edit it. However when they attempt to update and save the query there is a error message that only says "Scheduled Query Error". They can edit their own scheduled queries but cannot edit ones that I created.

I can confirm that they have all of the permissions in the link below. https://cloud.google.com/bigquery/docs/scheduling-queries#required_permissions

Any idea how to resolve this issue?

user_16929145 · Answer

A solution could be to create a service account and assign the correct permissions. Then you need to grant access to the users who will access this scheduled query.

You can follow these steps:

Create a service account in the IAM menu.You can see this documentation.

Grant access to the users (users who access the scheduled query) to the service account you will use.

Teammate cannot edit bigquery scheduled query

1 Answers