How to query public data sets using BigQuery
BigQuery is a fully managed data warehouse and analytics platform. The public datasets listed on this page are available for you to analyze using SQL queries. You can access BigQuery public data sets using theweb UI thecommand-line tool, or by making calls to theBigQuery REST API using a variety ofclient libraries such asJava,.NET, orPython.
The first terabyte of data processed per month is free, so you can start querying public data without enabling billing. To get started running some sample queries, select or create a project and then run the example queries on the NOAA GSOD weather dataset.
- Select or create a Cloud Platform Console project.
- Go to the NOAA GSOD dataset in the BigQuery Web UI.
Go to NOAA GSOD dataset
- Click the COMPOSE QUERY button.
- Copy and paste the SQL examples on the NOAA GSOD page.
Other Public Datasets
There are many other public datasets available for you to query, some of which are also hosted by Google, but many more that are hosted by third parties. You can share any of your datasets with the public by changing the sharing permissions associated with your dataset. For more information about sharing datasets, seeAccess Control.
- Sample Tables
- Google Genomics Public Data
- Datasets publicly available on Google BigQuery (reddit.com)
How to list your public data set on BigQuery
If you have any questions about listing a public data set on this page, please contact us at firstname.lastname@example.org.