importcom.google.cloud.bigquery.BigQuery;importcom.google.cloud.bigquery.BigQueryException;importcom.google.cloud.bigquery.BigQueryOptions;importcom.google.cloud.bigquery.QueryJobConfiguration;importcom.google.cloud.bigquery.TableId;importcom.google.cloud.bigquery.TableResult;// Sample to run query with pagination.publicclassQueryPagination{publicstaticvoidmain(String[]args){StringdatasetName="MY_DATASET_NAME";StringtableName="MY_TABLE_NAME";Stringquery="SELECT name, SUM(number) as total_people"+" FROM `bigquery-public-data.usa_names.usa_1910_2013`"+" GROUP BY name"+" ORDER BY total_people DESC"+" LIMIT 100";queryPagination(datasetName,tableName,query);}publicstaticvoidqueryPagination(StringdatasetName,StringtableName,Stringquery){try{// Initialize client that will be used to send requests. This client only needs to be created// once, and can be reused for multiple requests.BigQuerybigquery=BigQueryOptions.getDefaultInstance().getService();TableIdtableId=TableId.of(datasetName,tableName);QueryJobConfigurationqueryConfig=QueryJobConfiguration.newBuilder(query)// save results into a table..setDestinationTable(tableId).build();bigquery.query(queryConfig);TableResultresults=bigquery.listTableData(tableId,BigQuery.TableDataListOption.pageSize(20));// First Pageresults.getValues().forEach(row->row.forEach(val->System.out.printf("%s,\n",val.toString())));while(results.hasNextPage()){// Remaining Pagesresults=results.getNextPage();results.getValues().forEach(row->row.forEach(val->System.out.printf("%s,\n",val.toString())));}System.out.println("Query pagination performed successfully.");}catch(BigQueryException|InterruptedExceptione){System.out.println("Query not performed \n"+e.toString());}}}

// Import the Google Cloud client library using default credentialsconst{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();asyncfunctionqueryPagination(){// Run a query and get rows using automatic pagination.constquery=`SELECT name, SUM(number) as total_people  FROM \`bigquery-public-data.usa_names.usa_1910_2013\`  GROUP BY name  ORDER BY total_people DESC  LIMIT 100`;// Run the query as a job.const[job]=awaitbigquery.createQueryJob(query);// Wait for job to complete and get rows.// The client library automatically handles pagination.// See more info on how to configure paging calls at://  * https://github.com/googleapis/gax-nodejs/blob/main/client-libraries.md#auto-pagination//  * https://cloud.google.com/bigquery/docs/paging-results#iterate_through_client_libraries_resultsconst[rows]=awaitjob.getQueryResults();console.log('Query results:');rows.forEach(row=>{console.log(`name:${row.name},${row.total_people} total people`);});}queryPagination();

fromgoogle.cloudimportbigquery# Construct a BigQuery client object.client=bigquery.Client()query="""    SELECT name, SUM(number) as total_people    FROM `bigquery-public-data.usa_names.usa_1910_2013`    GROUP BY name    ORDER BY total_people DESC"""query_job=client.query(query)# Make an API request.query_job.result()# Wait for the query to complete.# Get the destination table for the query results.## All queries write to a destination table. If a destination table is not# specified, the BigQuery populates it with a reference to a temporary# anonymous table after the query completes.destination=query_job.destination# Get the schema (and other properties) for the destination table.## A schema is useful for converting from BigQuery types to Python types.destination=client.get_table(destination)# Download rows.## The client library automatically handles pagination.print("The query data:")rows=client.list_rows(destination,max_results=20)forrowinrows:print("name={}, count={}".format(row["name"],row["total_people"]))