year, month, day, weight_pounds FROM `publicdata.samples.natality`” tb <- bq_project_query(billing, sql) bq_table_download(tb, n_max = 10) #> # A tibble: 10 × 4 #> year month day weight_pounds #> <int> <int> <int> <dbl> #> 1 1969 3 15 6.88 #> 2 1969 7 11 6.12 #> 3 1969 11 8 7.50 #> 4 1969 3 15 7.69 #> 5 1969 3 12 6.31 #> 6 1969 10 24 7.19 #> 7 1969 5 14 7.69 #> 8 1969 10 14 4.31 #> 9 1969 4 5 8.44 #> 10 1969 2 6 8.50 from google.cloud import bigquery client object. client = bigquery.Client() query = ""” SELECT name, SUM(number) as total_people FROM `bigquery-public-data.usa_names.usa_1910_2013` WHERE state = 'TX’ GROUP BY name, state ORDER BY total_people DESC LIMIT 20 ""” query_job = client.query(query) # Make an API request. print("The query data:") for row in query_job: # Row values can be accessed by field name or index. print("name={}, count={}".format(row[0], row["total_people"])) https://cloud.google.com/bigquery/docs/reference/libraries?hl=ja# client-libraries-usage-python R Python