Skip to Content
Google BigQuery Analytics
book

Google BigQuery Analytics

by Siddartha Naidu, Jordan Tigani
June 2014
Intermediate to advanced
528 pages
13h 54m
English
Wiley
Content preview from Google BigQuery Analytics

Chapter 5Talking to the BigQuery API

The last chapter described the principal abstractions used by BigQuery: projects, datasets, tables, and jobs. This chapter shows you how those concepts map into interaction with the BigQuery service. We introduce the BigQuery REST API by describing the raw underlying HTTP format. We show that there is no magic involved: The BigQuery service is just a server that accepts HTTP requests and returns JSON responses. After reading this chapter, you should understand the API model and be able to interact with the service.

If you do not plan to write code to access BigQuery—that is, you plan to use only tools such as bq or the BigQuery web interface to use BigQuery—you may want to skip this chapter. That said, understanding how the BigQuery API works may make your interaction with BigQuery tools make more sense because those tools use the BigQuery API underneath the covers.

Introduction to Google APIs

Google has a number of externally facing APIs for accessing Google products: the Maps API, a Google+ API, several AdSense APIs, and more. You can see a list of them all in the Google Cloud Console. (Go to https://console.developers.google.com. click the name of a project, then click the APIs & auth tab.) BigQuery is just one of these APIs and shares a lot in common with other Google web services.

This section gives information about the basics of accessing any of the REST-based Google web APIs, with a focus on how these operations work in 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,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

BigQuery for Data Warehousing: Managed Data Analysis in the Google Cloud

BigQuery for Data Warehousing: Managed Data Analysis in the Google Cloud

Mark Mucchetti
Advanced Analytics with PySpark

Advanced Analytics with PySpark

Akash Tandon, Sandy Ryza, Uri Laserson, Sean Owen, Josh Wills

Publisher Resources

ISBN: 9781118824795Purchase book