I have a table in Snowflake that I’m monitoring from my Losant instance. I’d like to track if the value I’m tracking there has changed value since the last received value. Is the most efficient approach to use the ‘Time Series Query’ module in my workflow, and limit it to a brief amount of time, or should I use a new Data Table to simply track the last entry and compare?
I would use the On Change Node. Use the Snowflake Node to fetch your value and place it on your payload, and reference that same payload path as the value to monitor in the On Change Node.
That’s an interesting thought. I’ve not used On Change because historically the payloads all come from different devices, so there’s not alot of continuity from run to run. This one has quite a bit of continuity, so it might be very appropriate. I’ll report back here if it works. Thanks Dylan.