We are getting data from GCP BigQuery and it’s working well.
However, each query can obviously return many different size of records. Which is the best way to handle the data so that we can use it to display in the dashboard in a table and graph format?
Hi @Dirk_Swart, and welcome to the Losant Forums.
You’ll want to create a device to represent this data and define attributes on the device to represent each of the telemetry points. Once you are recording these values as device state (using a Device: State Node in this same workflow), you can then visualize that data in a dashboard or access aggregated/bucketed or raw data through our public API.
This is a very “getting started with Losant” type of question so, if you haven’t done so already, I recommend going through our Weather Station Walkthrough to learn about these core concepts. You can complete the tutorial in about an hour, and save for switching your BigQuery data source out for a third-party API accessed through an HTTP Node, the concepts are remarkably similar to what you are trying to do here.
Let us know if you have any questions, and again, welcome to Losant!