BigQuery排程:错误代码3:与重新验证相关的错误 [英] BigQuery scheduling: Error code 3 : reauth related error

问题描述

我已安排BigQuery查询.

I have scheduled queries on BigQuery.

自上周四以来，他们失败了.

They have failed since last Thursday.

我在运行细节"部分遇到以下错误

I got the error below on the Run Detail section

Error code 3 : reauth related error (invalid_rapt)

在BigQuery文档的疑难解答中找不到错误代码.

Cannot find the error code on Troubleshooting on BigQuery document.

推荐答案

用户身份验证，引入了Cloud ReAuth政策.Cloud ReAuth策略包括必须在每个API请求中提供的附加令牌.20小时后，令牌将失效，用户必须重新认证才能使用GCP API，使用 gcloud 或访问Google Cloud Platform UI.

The problem you are posting is being treated in this public issue tracker. It appears that this issue is related with the Google Cloud authentication permissions. Recently, the Cloud ReAuth policy was introduced in order to improve the user authentication. The Cloud ReAuth policy includes an additional token that must be provided in each API request. After 20 hours, the token will expire and the user must reauthenticate in order to use GCP APIs, use gcloud or access to the Google Cloud Platform UI.

当BigQuery引发错误错误代码3:重新认证相关的错误(invalid_rapt)时，可以使用更新用户凭据的变通办法.有两种方法可以完成此操作:

Updating the user credentials can be employed as a workaround when BigQuery raises the error Error code 3 : reauth related error (invalid_rapt) for a particular query. There are two ways this can be done:

1-按照 gcloud 命令

1 - From the Google Cloud SDK following the instructions of the gcloud command gcloud auth application-default login.

2-在 BigQuery网络用户界面中.在计划的查询详细信息"内，您会在右侧找到更多"选项.通过单击更多"->更新凭据"，将为此特定查询更新用户凭据.

2 - From the BigQuery web UI. Inside the "Scheduled query details" you will find the "MORE" options on the right side. By clicking on "MORE" -> "Update credentials" the user credentials will be updated for this particular query.

这篇关于BigQuery排程:错误代码3:与重新验证相关的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！