How to Download a Dataset from Google Bigquery as CSV

The steps are:

1. Go to the Google BigQuery page and see what the table of interest is called by looking at what its nested under.
   • Eg. The table I’m trying to download is “bigquery-public-data.chicago_taxi_trips.taxi_trips”. A very long name.
2. Create a basic SQL query as a test to see if you’ve actually located the correct sheet.
   • SELECT * FROM `bigquery-public-data.chicago_taxi_trips.taxi_trips` LIMIT 10
   • If you can’t type a query, make sure you have the correct link.
3. Query with:
   • SELECT * FROM `bigquery-public-data.chicago_taxi_trips.taxi_trips` LIMIT 25000
4. Now you can either do your queries directly from BigQuery, or upload the CSV into MySQL, whichever you prefer. 
5. If you want to go for the CSV route, click on Save Results:
   • 
6. You can save a CSV up to 1GB in Google Drive. The 25,000 rows for me was only 6.5MB.
   •