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 ...
