To store our data, we need the support of Cloud Storage. We can use three different data storage services—Cloud BigQuery, Cloud Bigtable, and Cloud Datastore. To store time-series, Google suggest that you use Bigtable. Bigtable is very similar to the popular open source platform Apache HBase. Bigtable is organized in tables, rows, columns, and families of columns:
- A table is a collection of rows
- A row is a collection of column families
- A column family is a collection of columns
- A column is a collection of key value pairs
In our exercise, we are going to build a schema, where a combination of device IDs and timestamps is the row key and the column families are the sensors. Please look into the layout and the content of the following table:
|
|
Column family |
Column family |
||
|
|
sensor1 |
sensor2 |
||
|
Row key |
Column |
Column |
Column |
Column |
|
Deviceid... |