search

aerosense-ai / data-gateway

Data influx for Aerosense.
https://www.aerosense.ai/
Other
3 stars 1 forks source link

Cloud function fails to add sensor data. #116

Closed time-trader closed 1 year ago

time-trader commented 1 year ago

Bug report

What is the current behavior?

Cloud function will not add sensor data to greta.sensor_data because there is no column named "measurement_campaign_reference" in that table.

What is the expected behavior?

I am not sure there is a need to have measurement_campaign_reference column at all in greta.sensor_data, Including this column makes measurement_campaign table redundant, because it would be simply generated with a query over sensor_data.

cortadocodes commented 1 year ago

I'm aware of this, updating the tables is the final step in adding the measurement campaign concept. I'll update them this morning

cortadocodes commented 1 year ago

The measurement_campaign_reference column is just the reference for the measurement campaign (not the rest of the data associated with it) and was added to the sensor_data table so you're able to tell which data was produced in which measurement campaign.

cortadocodes commented 1 year ago

I've just added the new columns to the tables