April 2018
Intermediate to advanced
280 pages
6h 18m
English
Content preview from Google Cloud Platform Cookbook
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
There's more...
In addition to querying via the web interface, BigQuery data can be queried by using the command line, and API calls, and via client SDKs. There are two modes to execute the queries— interactive mode and batch mode.
In the interactive mode, the queries are executed immediately whereas, in the batch mode, the queries are queued to be processed when resources become available. By waiting for available resources, batch queries do not count toward the concurrent rate limit and daily limit.
The following is an example of the command-line query in interactive and batch modes:
$ bq query "SELECT screen_name FROM [<Project ID>:TwitterData.theTweets] LIMIT 1000"Waiting on bqjob_r6e562a9ffa61eb18_00000161fd61f724_1 ... (0s) Current ...