Hi Community, We have a table that records events emitted by an entity (timestamp, entity_id, status (OPEN/CLOSED)). Events are sparse, emitted only when there is a state change. We want to compute at any given point in time, how many entities are open (also want to track the trend, in a time range plot the trend of # of entities open). Are there any time series functions to help with this ?
07/20/2021, 6:26 AM
using upsert feature, you should be able to solve both
other approach is to have two tables - one upsert enabled and the other append only mode
07/20/2021, 7:00 AM
Could you elaborate more ? How can upsert solve this ?
These are discrete events periodically emitted by the entity.