December 2017
Beginner to intermediate
264 pages
5h 38m
English
Content preview from Learning Google BigQuery
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
SELECT
The SELECT statement is used to select individual columns (with the exception of *, which can be used to select all columns in a table). In BigQuery, it is not encouraged to use SELECT * when querying tables because BigQuery bills projects by the number of bytes searched, and if we add all columns, then all of the data in the table will be searched for the query.