protected async Task <(List <BigQueryRow>, long, double)> RunQueryAsync(BigQueryClient bigQueryClient, string sql, BigQueryParameter[] parameters)
{
// Show SQL query in browser
ShowQuery(sql, parameters);
// Time the BigQuery execution with a StopWatch
var stopwatch = new Stopwatch();
stopwatch.Start();
// Execute BigQuery SQL query.
var result = await bigQueryClient.ExecuteQueryAsync(sql, parameters);
// Query finished, stop the StopWatch
stopwatch.Stop();
// Get a job reference, for statistics
var job = await bigQueryClient.GetJobAsync(result.JobReference);
// Get result list
var resultList = result.ToList();
// Time and data statistics
long processedMb = job.Statistics.TotalBytesProcessed.Value / (1024 * 1024);
double secs = stopwatch.Elapsed.TotalSeconds;
return(resultList, processedMb, secs);
}
