4 of 11Image
To run a Query, type it in, then click the “RUN QUERY” button or just tap Ctrl-Enter on your keyboard. While the query is running, the query text area is disabled and the elapsed query time clock runs up, right next to the “Query running” label.
BigQuery does not permit “SELECT *”-style queries; instead, you must specify all column names. And although you’ll be querying large datasets, you will want to keep your result sets small. To do that, make use of aggregating queries (using aggregate functions and GROUP BY) and/or the LIMIT n clause at the end of your query as was done here (i.e. “LIMIT 200” appears at the end of the query).
Tables are identified using a syntax of datasetname.tablename. If you reference any table from the samples dataset, you’ll need to use the “publicdata:” prefix before the “samples” dataset name.