上传失败：超出配额：您的表超出了每个表的导入或查询附加配额。了解更多信息 [英] Upload failure: Quota exceeded: Your table exceeded quota for imports or query appends per table. For more information

问题描述

我试图将旧的备份数据上传到bigquery表中。有时会出现以下错误。目前还不清楚哪个配额超出了，我们如何找到它或解决这个错误？

I am trying to upload old backup data in to bigquery table. It fails at times with the error below. It's not clear which quota is exceeded, how do we find it or workaround this error?

{
  "errorResult" : {
  "message" : "Quota exceeded: Your table exceeded quota for imports or query appends per table. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors",
  "location" : "load_job_per_table.long",
  "reason" : "quotaExceeded"
  },
  "state" : "DONE",
  "errors" : [
    {
      "reason" : "quotaExceeded",
      "location" : "load_job_per_table.long",
      "message" : "Quota exceeded: Your table exceeded quota for imports or query appends per table. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors"
    }
  ]
}

推荐答案

这很可能是加载作业限制：

像每日限制：每天每个表格有1,000个加载作业（包括故障），每个项目每天有10,000个加载作业（包括故障）

Like Daily limit : 1,000 load jobs per table per day (including failures), 10,000 load jobs per project per day (including failures)

这篇关于上传失败：超出配额：您的表超出了每个表的导入或查询附加配额。了解更多信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！