I‘m new to Influx and looking for some best practices regarding database structure and how cumulative values should be stored.
We have weather sensors from different manufacturers. Depending on the manufacturer they send different data sets. All send at least the current temperature, some also send the wind velocity and others the illumination.
Because mostly all available data values for a device will be queried, does it make sense to create one “big table” containing all these different measurements and adding some empty dummy value if the specific device does not provide a measurment? Is it still better to create one table per measurement? Or is there any other approach to this, that makes more sense?
(As a tag I wanted to use the device id, which should be fine, right?)
From some devices we also get a “hours of sunlight” per day value from the sensors. How would you store such a once-per-day value?
Thanks for your help!