RE: What is the difference between Batch and Interactive in Bigquery?
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