bigquery/ERR/2023_008
User has the required roles to create or modify scheduled queries.
Product: BigQuery
Rule class: ERR - Something that is very likely to be wrong
Description
To verify that the user trying to create or modify scheduled queries has the role roles/bigquery.admin. If pub sub notification is configured, then user should also have permission pubsub.topics.getIamPolicy which is part of the role roles/pubsub.admin.
Remediation
If the user trying to create or modify scheduled queries doesn’t have the role roles/bigquery.admin, then please add it by following Grant an IAM role
If pub sub notification is also configured and user doesn’t have permission pubsub.topics.getIamPolicy, then please add the permission using a custom role or add role roles/pubsub.admin which contains this permission.