Hands-On Industrial Internet of Things

BigQuery

BigQuery is a very robust and mature technology provided by GCP to execute complex OLAP queries. We can use BigQuery for interactive queries. GCP provides a command-line tool to execute complex queries. Alternatively, we can use the online tool, which can be found at https://bigquery.cloud.google.com/welcome.

In this simple example, we are going to use the console tool. We assume that the tool has already been installed. From the command line, execute the following command:

$ bq query --use_legacy_sql=false 'select count(*) from `signals.iiot-book`'

The query counts the number of events that were previously stored in our Bigtable.