5 word coolnames are not cool about data-gateway

[time-trader]

As discussed before, the goal to introduce "measurement campaign" concept for easier data retrieval/filtering. Essentially it is similar to "installation", depending on how you define installation. It is surely possible to get a table that contains information similar to the "measuremnt campaign" one using the following query on sensor data:

SELECT installation_reference, min(datetime) as start, max(datetime) as finish, node_id, sensor_type_reference FROM `aerosense-twined.greta.sensor_data`
GROUP BY installation_reference, node_id, sensor_type_reference

Now, whether "measurement campaign" is sufficiently narrower than the "installation" to warrant it's own existence, is a separate topic. But the idea is to have additional metadata, particularly: "On a specific installation, what nodes and sensor were active during certain period of time and for what purpose ?"
I guess the question is "what should be the "primary key" (not entirely correct term, but you get the idea) to get the desired data series?