Skip to content

Projects have two primary components: datasets and jobs. Unlike other BigQuery objects, is no accompanying bq_project S3 class because a project is a simple string.

Usage

bq_project_datasets(x, page_size = 100, max_pages = 1, warn = TRUE)

bq_project_jobs(x, page_size = 100, max_pages = 1, warn = TRUE)

Arguments

x

A string giving a project name.

page_size

Number of items per page.

max_pages

Maximum number of pages to retrieve. Use Inf to retrieve all pages (this may take a long time!)

warn

If TRUE, warn when there are unretrieved pages.

Value

  • bq_project_datasets(): a list of bq_datasets

  • bq_project_jobs(): a list of bq_jobs.

Google BigQuery API documentation

One day we might also expose the general project metadata.

Examples

bq_project_datasets("bigquery-public-data")
#> Warning: Only first 100 results retrieved. Adjust with `max_pages` and `page_size` parameters.
#> [[1]]
#> <bq_dataset> bigquery-public-data.america_health_rankings
#> 
#> [[2]]
#> <bq_dataset> bigquery-public-data.austin_311
#> 
#> [[3]]
#> <bq_dataset> bigquery-public-data.austin_bikeshare
#> 
#> [[4]]
#> <bq_dataset> bigquery-public-data.austin_crime
#> 
#> [[5]]
#> <bq_dataset> bigquery-public-data.austin_incidents
#> 
#> [[6]]
#> <bq_dataset> bigquery-public-data.austin_waste
#> 
#> [[7]]
#> <bq_dataset> bigquery-public-data.baseball
#> 
#> [[8]]
#> <bq_dataset> bigquery-public-data.bbc_news
#> 
#> [[9]]
#> <bq_dataset> bigquery-public-data.bigqueryml_ncaa
#> 
#> [[10]]
#> <bq_dataset> bigquery-public-data.bitcoin_blockchain
#> 
#> [[11]]
#> <bq_dataset> bigquery-public-data.blackhole_database
#> 
#> [[12]]
#> <bq_dataset> bigquery-public-data.blockchain_analytics_ethereum_mainnet_us
#> 
#> [[13]]
#> <bq_dataset> bigquery-public-data.bls
#> 
#> [[14]]
#> <bq_dataset> bigquery-public-data.bls_qcew
#> 
#> [[15]]
#> <bq_dataset> bigquery-public-data.breathe
#> 
#> [[16]]
#> <bq_dataset> bigquery-public-data.broadstreet_adi
#> 
#> [[17]]
#> <bq_dataset> bigquery-public-data.catalonian_mobile_coverage
#> 
#> [[18]]
#> <bq_dataset> bigquery-public-data.catalonian_mobile_coverage_eu
#> 
#> [[19]]
#> <bq_dataset> bigquery-public-data.census_bureau_acs
#> 
#> [[20]]
#> <bq_dataset> bigquery-public-data.census_bureau_construction
#> 
#> [[21]]
#> <bq_dataset> bigquery-public-data.census_bureau_international
#> 
#> [[22]]
#> <bq_dataset> bigquery-public-data.census_bureau_usa
#> 
#> [[23]]
#> <bq_dataset> bigquery-public-data.census_opportunity_atlas
#> 
#> [[24]]
#> <bq_dataset> bigquery-public-data.census_utility
#> 
#> [[25]]
#> <bq_dataset> bigquery-public-data.cfpb_complaints
#> 
#> [[26]]
#> <bq_dataset> bigquery-public-data.chicago_crime
#> 
#> [[27]]
#> <bq_dataset> bigquery-public-data.chicago_taxi_trips
#> 
#> [[28]]
#> <bq_dataset> bigquery-public-data.clemson_dice
#> 
#> [[29]]
#> <bq_dataset> bigquery-public-data.cloud_storage_geo_index
#> 
#> [[30]]
#> <bq_dataset> bigquery-public-data.cms_codes
#> 
#> [[31]]
#> <bq_dataset> bigquery-public-data.cms_medicare
#> 
#> [[32]]
#> <bq_dataset> bigquery-public-data.cms_synthetic_patient_data_omop
#> 
#> [[33]]
#> <bq_dataset> bigquery-public-data.country_codes
#> 
#> [[34]]
#> <bq_dataset> bigquery-public-data.covid19_aha
#> 
#> [[35]]
#> <bq_dataset> bigquery-public-data.covid19_covidtracking
#> 
#> [[36]]
#> <bq_dataset> bigquery-public-data.covid19_ecdc
#> 
#> [[37]]
#> <bq_dataset> bigquery-public-data.covid19_ecdc_eu
#> 
#> [[38]]
#> <bq_dataset> bigquery-public-data.covid19_genome_sequence
#> 
#> [[39]]
#> <bq_dataset> bigquery-public-data.covid19_geotab_mobility_impact
#> 
#> [[40]]
#> <bq_dataset> bigquery-public-data.covid19_geotab_mobility_impact_eu
#> 
#> [[41]]
#> <bq_dataset> bigquery-public-data.covid19_google_mobility
#> 
#> [[42]]
#> <bq_dataset> bigquery-public-data.covid19_google_mobility_eu
#> 
#> [[43]]
#> <bq_dataset> bigquery-public-data.covid19_govt_response
#> 
#> [[44]]
#> <bq_dataset> bigquery-public-data.covid19_italy
#> 
#> [[45]]
#> <bq_dataset> bigquery-public-data.covid19_italy_eu
#> 
#> [[46]]
#> <bq_dataset> bigquery-public-data.covid19_jhu_csse
#> 
#> [[47]]
#> <bq_dataset> bigquery-public-data.covid19_jhu_csse_eu
#> 
#> [[48]]
#> <bq_dataset> bigquery-public-data.covid19_nyt
#> 
#> [[49]]
#> <bq_dataset> bigquery-public-data.covid19_open_data
#> 
#> [[50]]
#> <bq_dataset> bigquery-public-data.covid19_open_data_eu
#> 
#> [[51]]
#> <bq_dataset> bigquery-public-data.covid19_public_forecasts
#> 
#> [[52]]
#> <bq_dataset> bigquery-public-data.covid19_public_forecasts_asia_ne1
#> 
#> [[53]]
#> <bq_dataset> bigquery-public-data.covid19_rxrx19
#> 
#> [[54]]
#> <bq_dataset> bigquery-public-data.covid19_symptom_search
#> 
#> [[55]]
#> <bq_dataset> bigquery-public-data.covid19_tracking
#> 
#> [[56]]
#> <bq_dataset> bigquery-public-data.covid19_usafacts
#> 
#> [[57]]
#> <bq_dataset> bigquery-public-data.covid19_vaccination_access
#> 
#> [[58]]
#> <bq_dataset> bigquery-public-data.covid19_vaccination_search_insights
#> 
#> [[59]]
#> <bq_dataset> bigquery-public-data.covid19_weathersource_com
#> 
#> [[60]]
#> <bq_dataset> bigquery-public-data.crypto_band
#> 
#> [[61]]
#> <bq_dataset> bigquery-public-data.crypto_bitcoin
#> 
#> [[62]]
#> <bq_dataset> bigquery-public-data.crypto_bitcoin_cash
#> 
#> [[63]]
#> <bq_dataset> bigquery-public-data.crypto_dash
#> 
#> [[64]]
#> <bq_dataset> bigquery-public-data.crypto_dogecoin
#> 
#> [[65]]
#> <bq_dataset> bigquery-public-data.crypto_ethereum
#> 
#> [[66]]
#> <bq_dataset> bigquery-public-data.crypto_ethereum_classic
#> 
#> [[67]]
#> <bq_dataset> bigquery-public-data.crypto_iotex
#> 
#> [[68]]
#> <bq_dataset> bigquery-public-data.crypto_kusama
#> 
#> [[69]]
#> <bq_dataset> bigquery-public-data.crypto_litecoin
#> 
#> [[70]]
#> <bq_dataset> bigquery-public-data.crypto_multiversx_mainnet_eu
#> 
#> [[71]]
#> <bq_dataset> bigquery-public-data.crypto_near_mainnet_us
#> 
#> [[72]]
#> <bq_dataset> bigquery-public-data.crypto_polkadot
#> 
#> [[73]]
#> <bq_dataset> bigquery-public-data.crypto_solana_mainnet_us
#> 
#> [[74]]
#> <bq_dataset> bigquery-public-data.crypto_tezos
#> 
#> [[75]]
#> <bq_dataset> bigquery-public-data.crypto_theta
#> 
#> [[76]]
#> <bq_dataset> bigquery-public-data.crypto_zcash
#> 
#> [[77]]
#> <bq_dataset> bigquery-public-data.crypto_zilliqa
#> 
#> [[78]]
#> <bq_dataset> bigquery-public-data.cymbal_investments
#> 
#> [[79]]
#> <bq_dataset> bigquery-public-data.dataflix_covid
#> 
#> [[80]]
#> <bq_dataset> bigquery-public-data.dataflix_traffic_safety
#> 
#> [[81]]
#> <bq_dataset> bigquery-public-data.deepmind_alphafold
#> 
#> [[82]]
#> <bq_dataset> bigquery-public-data.deps_dev_v1
#> 
#> [[83]]
#> <bq_dataset> bigquery-public-data.dimensions_ai_covid19
#> 
#> [[84]]
#> <bq_dataset> bigquery-public-data.ebi_chembl
#> 
#> [[85]]
#> <bq_dataset> bigquery-public-data.ebi_surechembl
#> 
#> [[86]]
#> <bq_dataset> bigquery-public-data.eclipse_megamovie
#> 
#> [[87]]
#> <bq_dataset> bigquery-public-data.epa_historical_air_quality
#> 
#> [[88]]
#> <bq_dataset> bigquery-public-data.ethereum_blockchain
#> 
#> [[89]]
#> <bq_dataset> bigquery-public-data.etsi_technical_standards
#> 
#> [[90]]
#> <bq_dataset> bigquery-public-data.faa
#> 
#> [[91]]
#> <bq_dataset> bigquery-public-data.fcc_political_ads
#> 
#> [[92]]
#> <bq_dataset> bigquery-public-data.fda_drug
#> 
#> [[93]]
#> <bq_dataset> bigquery-public-data.fda_food
#> 
#> [[94]]
#> <bq_dataset> bigquery-public-data.fdic_banks
#> 
#> [[95]]
#> <bq_dataset> bigquery-public-data.fec
#> 
#> [[96]]
#> <bq_dataset> bigquery-public-data.fhir_synthea
#> 
#> [[97]]
#> <bq_dataset> bigquery-public-data.ga4_obfuscated_sample_ecommerce
#> 
#> [[98]]
#> <bq_dataset> bigquery-public-data.gbif
#> 
#> [[99]]
#> <bq_dataset> bigquery-public-data.gdelt_hathitrustbooks
#> 
#> [[100]]
#> <bq_dataset> bigquery-public-data.gdelt_internetarchivebooks
#> 
bq_project_datasets("githubarchive")
#> [[1]]
#> <bq_dataset> githubarchive.day
#> 
#> [[2]]
#> <bq_dataset> githubarchive.github
#> 
#> [[3]]
#> <bq_dataset> githubarchive.month
#> 
#> [[4]]
#> <bq_dataset> githubarchive.year
#> 

bq_project_jobs(bq_test_project(), page_size = 10)
#> Warning: Only first 10 results retrieved. Adjust with `max_pages` and `page_size` parameters.
#> [[1]]
#> <bq_job> gargle-169921.job_Y97jqLJ8umJDw851bvAbnJrjfiHW.US
#> 
#> [[2]]
#> <bq_job> gargle-169921.job_j2g0Z514cQw-MJ7mFtexCHsROy5N.US
#> 
#> [[3]]
#> <bq_job> gargle-169921.job_5nWTlMv_gKxq6EVBC1ZxUW3Gs7J1.US
#> 
#> [[4]]
#> <bq_job> gargle-169921.job_SL5yz8oIwYBMKYdvkOV9ZPsKYvIR.US
#> 
#> [[5]]
#> <bq_job> gargle-169921.job_tXeNvHXAKRW2dZfUJw3I91qk-UsJ.US
#> 
#> [[6]]
#> <bq_job> gargle-169921.job_490MYCpxuMFy3W1a53-FvBeNEj2d.US
#> 
#> [[7]]
#> <bq_job> gargle-169921.job_nKzIl6t4jZyYeFpC7N1HcgwYkQe_.US
#> 
#> [[8]]
#> <bq_job> gargle-169921.job_rPlfEehrz-E75-TOapzIahq01BKV.US
#> 
#> [[9]]
#> <bq_job> gargle-169921.job_sX9V_oojTXEz-AUofAnVU6fMAWr8.US
#> 
#> [[10]]
#> <bq_job> gargle-169921.job_AADIDMsPSPSiEEV6RPLrk7FoiwOU.US
#>