上载失败:超出配额:您的表超出了每个表的导入或查询追加配额.了解更多信息

Question

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

{
  "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"
    }
  ]
}

Answer 1

最有可能的是加载作业限制：

类似于每日限制：每天每个表1000个加载作业（包括失败），每天每个项目10000个加载作业