Collecting Real Time data vs data from Device Twin in Azure


Situation: I have a sensor setup, sending data to a gateway device, which is transmitting to Azure. I can access this data with a Stream Analytics job & I also see messages coming in using the Azure CLI.

Concern(s): 1) I am seeing a discrepancy between timestamps when viewing transmissions using the CLI vs in the Device twin on azure. 2) This leads me to question whether I am accessing real time data with my stream analytics job when I query the device twin.

Essentially, I would like to determine the best way to query real time data from my sensors in Azure.

Bonus questions:

What then, is the best way to visualize this data in a dashboard?
What is a simple way to store this data in a database on Azure?

Thank you for your time. Please let me know if there’s anything I can clarify.