Running a Query

Created by Bianca Mounce, Modified on Wed, 6 Mar at 1:21 AM by Alsabana Sahubarali

Once you're logged into BigQuery, you can write and run queries!

We’ve created a sample dataset in your project called sample_acs.zip_codes_2018_5yr. To run a query against it:

SELECT * FROM `bigquery-public-data.geo_census_blockgroups.us_blockgroups_national`
LIMIT 10

Ready to export the data? Simply click “Save Results” and then “Google Sheets.” Save Query Results

Then, click on the link to the resulting Google Sheet. That’s it! You’ve successfully run a query and have exported the results to a Google Sheet.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article