What is the difference between Batch and Interactive in Bigquery?

What is the difference between Batch and Interactive in Bigquery?

Add Comment
1 Answer(s)

Diyotta has provided the option to choose query priority as interactive and batch in the datapoint level.  By default, batch is given as priority which allows to run batch queries. BigQuery queues each batch query on your behalf, and starts the query as soon as idle resources are available in the Bigquery shared resource pool and this usually occurs within a few minutes. If BigQuery hasn’t started the query within 24 hours, BigQuery changes the job priority to interactive

If interactive priority as chosen, BigQuery runs interactive (on-demand) query jobs, which means that the query is executed as soon as possible. Interactive queries count towards your concurrent rate limit and your daily limit

Expert Answered on July 16, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.