Add priority option to Google BigQuery Service Connector setting

JonavilCello

Google BigQuery has two types of priority, Running interactive and batch query jobs.
https://cloud.google.com/bigquery/docs/running-queries

 

But Domo seems to only use interactive in default and we don't have a way to set it to batch.
The difference is, if it is batch, it will wait for the other tasks to finish,
while the interactive runs exactly with the schedule,
ending up crashing if the allowed data limit within a certain span of time was reached.

I know this can be solved by manually adjusting the schedule..but if you have hundreds of it and it will be very hard to adjust one by one.