// [END build_service]
/// <summary>
/// Pages through the results of an arbitrary Bigquery request.
/// </summary>
/// <param name="jobRef">The job whose rows will be fetched.</param>
/// <param name="rowsPerPage">How many rows to fetch in each http
/// request?</param>
/// <returns>An IEnumerable of rows.</returns>
// [START paging]
public IEnumerable <TableRow> GetRows(JobReference jobRef,
long?rowsPerPage = null)
{
BigqueryService bigquery = CreateAuthorizedClient();
var request = new JobsResource.GetQueryResultsRequest(
bigquery, jobRef.ProjectId, jobRef.JobId);
request.MaxResults = rowsPerPage;
do
{
var response = request.Execute();
if (response.Rows != null)
{
foreach (var row in response.Rows)
{
yield return(row);
}
}
request.PageToken = response.PageToken;
} while (!String.IsNullOrEmpty(request.PageToken));
}
// [END build_service]
/// <summary>
/// Pages through the results of an arbitrary Bigquery request.
/// </summary>
/// <param name="bigquery">The bigquery service.</param>
/// <param name="jobRef">The job whose rows will be fetched.</param>
/// <param name="rowsPerPage">How many rows to fetch in each http request?</param>
/// <returns>An IEnumerable of rows.</returns>
// [START paging]
public static IEnumerable<TableRow> GetRows(BigqueryService bigquery, JobReference jobRef,
long? rowsPerPage = null)
{
var request = new JobsResource.GetQueryResultsRequest(
bigquery, jobRef.ProjectId,jobRef.JobId);
request.MaxResults = rowsPerPage;
do
{
var response = request.Execute();
if (response.Rows != null) foreach (var row in response.Rows)
yield return row;
request.PageToken = response.PageToken;
} while (!String.IsNullOrEmpty(request.PageToken));
}
