// [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)); }