Updating a BigQuery scheduled query fails with Permission Denied

Problem

Updating a BigQuery scheduled query fails with an error of the following format:

PermissionDenied: 403 The caller does not have permission

Environment

BigQuery

Solution

Authenticate as the user account used created the scheduled query by running the following command in Cloud Shell or any terminal with Cloud SDK installed:

gcloud auth login

The bq update CLI can be used to modify the scheduled query as needed from the same terminal.

Cause

The account making the change should be the creator of the scheduled query. Not fulfilling this requirement leads to permission denied errors.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2024-12-10 UTC.