Bigquery Quoata Limit On Load Jobs

[rahulnpr]

I have a task to dump data into the bigquery, since few of my data are huge around 200gb. I need to dump or load into bq as chunks resulting in multiple loadjobs. I have encountered Quoata Limit Exceed error.

• So my question is how many load jobs are accepted per day per table?
• How to mitigate this issue?
• Can i increase quoata limits?

[mars124]

@rahulnpr

1. So my question is how many load jobs are accepted per day per table?
2. How to mitigate this issue?
3. Can i increase quoata limits?

1. Default is 1,500 load jobs per table per day.
2. Make your load sizes bigger since the maximum size per load job is 15 TB.
3. You can try in IAM & Admin > Quotas & System Limits

More info here:

https://cloud.google.com/bigquery/quotas#load_jobs