CODEWITHSUNDEEP
google-bigquery
alek6dj
alek6dj

Reputation: 364

Error updating scheduled query: update_time cannot be updated

When I try to update a schedule query (modifying SQL code) I get this error: Error updating scheduled query: update_time cannot be updated.

I think that previously I made this kind of updates without problems... Any idea what could be happening now?

Upvotes: 10

Views: 2858

Answers (4)

RaptorX
RaptorX

Reputation: 139

Not sure if you got the answer. But for CLI based update you can try following - Get the transfer config location (us\asia) for the scheduled query- bq ls \

--transfer_config \ --transfer_location=

Execute bq update bq update \ --transfer_config \ --schedule='every xx minutes'

Above is just an example, you can update the update values for what you need to modify in the scheduled query.

Upvotes: 0

alek6dj
alek6dj

Reputation: 364

There is a fix fully deployed for the previous bug. Already tested in BigQuery web UI and works fine.

Upvotes: 0

F10
F10

Reputation: 2883

This is an issue already reported to the BigQuery engineering team.

You can track the progress of the research regarding this issue in this link. It seems an issue with the BigQuery UI as the Classic UI seems to be working

I suggest starring the issue to indicate you're being affected by this issue.

UPDATE

The classic UI may have issues regarding the dataset destination set.

I consider recreating the scheduled query would be the best workaround while the fix is released.

Upvotes: 7

Aphonso
Aphonso

Reputation: 1

It seems like a new bug in Scheduled Queries of GCP. Is it important to remember that this tool is on BETA yet.

Since a few months, I'm creating and updating queries and using a lot this tool and yesterday was the first time that I was faced to this message.

GCP Scheduled Queries error message

Upvotes: 0

Related Questions