# BigQuery Data Display

**URL:** https://forums.losant.com/t/bigquery-data-display/4552
**Category:** Workflow Lab
**Created:** [May 26, 2022, 7:06am UTC](https://forums.losant.com/t/bigquery-data-display/4552 "2022-05-26T07:06:50Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Dirk\_Swart](https://avatars.discourse-cdn.com/v4/letter/d/e56c9b/32.png) [@Dirk\_Swart](https://forums.losant.com/u/Dirk_Swart)
#### Post date: [May 26, 2022, 7:06am UTC](https://forums.losant.com/t/bigquery-data-display/4552/1 "2022-05-26T07:06:50Z")

</div>

We are getting data from GCP BigQuery and it’s working well.

 ![Screenshot 2022-05-26 170155](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/1/1613d767e4cde44f604b5f6f2c3b3161838b0f39.png)

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?

---

<div class="post-metadata">

### Author: ![Dylan\_Schuster](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/dylan_schuster/32/2850_2.png) [@Dylan\_Schuster](https://forums.losant.com/u/Dylan_Schuster)
#### Post date: [May 26, 2022, 1:26pm UTC](https://forums.losant.com/t/bigquery-data-display/4552/2 "2022-05-26T13:26:05Z")

</div>

Hi @Dirk_Swart, and welcome to the Losant Forums.

You’ll want to create a [device](https://docs.losant.com/devices/overview/) to represent this data and define [attributes](https://docs.losant.com/devices/attributes/) on the device to represent each of the telemetry points. Once you are recording these values as [device state](https://docs.losant.com/devices/state/) (using a [Device: State Node](https://docs.losant.com/workflows/outputs/device-state/) in this same workflow), you can then visualize that data in a [dashboard](https://docs.losant.com/dashboards/overview/) or access aggregated/bucketed or raw data through our [public API](https://docs.losant.com/rest-api/data/).

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](https://docs.losant.com/getting-started/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!