CODEWITHSUNDEEP
google-bigquery
Vivek Pandey
Vivek Pandey

Reputation: 83

Upload failure: Quota exceeded: Your table exceeded quota for imports or query appends per table. For more information

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

Upvotes: 5

Views: 10846

Answers (2)

pmo511
pmo511

Reputation: 619

Your project can make up to 1,500 table modifications per table per day, whether the modification appends data, updates data, or truncates the table. This limit cannot be changed and includes the combined total of all load jobs, copy jobs, and query jobs that append to or overwrite a destination table.

see: https://cloud.google.com/bigquery/quotas#standard_tables

Upvotes: 0

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173046

It is most likely Load Jobs Limits:

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

Upvotes: 12

Related Questions