# Cant read boolean data from google bigquery database

**URL:** <https://community.grafana.com/t/cant-read-boolean-data-from-google-bigquery-database/164120>\
**Category:** Dashboards\
**Created:** [August 11, 2026, 7:04pm UTC](https://community.grafana.com/t/cant-read-boolean-data-from-google-bigquery-database/164120 "2026-08-11T19:04:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fangdi](https://avatars.discourse-cdn.com/v4/letter/f/ecb155/32.png) [@fangdi](https://community.grafana.com/u/fangdi)\
**Post date:** [August 11, 2026, 7:04pm UTC](https://community.grafana.com/t/cant-read-boolean-data-from-google-bigquery-database/164120/1 "2026-08-11T19:04:26Z")

</div>

- What Grafana version and what operating system are you using?  
**13.2.0** (build `bb1a9a86`), **Cloud Advanced** edition, in the `production` environment.

- **What** are you trying to achieve?  
Pull data from data souce

- **How** are you trying to achieve it?

- Via Bigquery connector

- What happened?

- Any Boolean pulled will not have correct data, it takes the last boolean of any col and apply to all rows

- What did you **expect** to happen?  
It should read the actual data in my data source

- Can you copy/paste the configuration(s) that you are having problems with?  
The code i run:  
select true as `check`

- Did you receive any errors in the Grafana UI or in related logs? If so, please tell us **exactly** what they were.  
No error

- Did you follow any online instructions? If so, what is the URL?  
No

---

<div class="post-metadata">

**Author:** ![fangdi](https://avatars.discourse-cdn.com/v4/letter/f/ecb155/32.png) [@fangdi](https://community.grafana.com/u/fangdi)\
**Post date:** [August 11, 2026, 7:05pm UTC](https://community.grafana.com/t/cant-read-boolean-data-from-google-bigquery-database/164120/2 "2026-08-11T19:05:03Z")

</div>

Here are two test query

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/b/8/b86f6999415632934b6d88e3f30ed5918a8fb733.png)

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/9/a/9a3c8a38ba147a0270a7b9b1eb108590bc97060e.png)

---

<div class="post-metadata">

**Author:** ![infofcc3](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/infofcc3/32/51248_2.png) [@infofcc3](https://community.grafana.com/u/infofcc3)\
**Post date:** [August 12, 2026, 2:33am UTC](https://community.grafana.com/t/cant-read-boolean-data-from-google-bigquery-database/164120/3 "2026-08-12T02:33:33Z")

</div>

It looks like the native BOOL→dataframe conversion in the plugin isn’t copying each row’s value independently as every row ends up pointing at whatever the last row’s value was by the time the frame is built.

**Panel 1 → native BOOL :**

Query →

> select true as `check` union all select false union all select true union all select false

All 4 rows returned `false` → matches the last value in the query, not the actual per row data.

 ![Screenshot (466)](https://us1.discourse-cdn.com/grafana/original/3X/9/e/9ecc8070c0e10012ebb436fdbd0bd6d75f7755dd.png)

**Panel 2 → same values, cast to string (fixed):**

Query →

> select cast(true as string) as `check` union all select cast(false as string) union all select cast(true as string) union all select cast(false as string)

Result → correctly returned `true, false, true, false`.

 ![Screenshot (467)](https://us1.discourse-cdn.com/grafana/original/3X/c/a/ca17a6305b82d453a3367f68a23daf1fa722ee49.png)

Workaround is to cast any BOOLEAN column to STRING in your SQL instead of returning it natively. If you want it to display/filter as a boolean again, you can add a value mapping (`"true"` → true, `"false"` → false) via a field override on the panel.

Open this as a GitHub issue on the plugin repo if one doesn’t already exist →

> **[Issues · grafana/google-bigquery-datasource](https://github.com/grafana/google-bigquery-datasource/issues)**
>
> Google BigQuery Datasource Plugin for Grafana. Contribute to grafana/google-bigquery-datasource development by creating an account on GitHub.

---

<div class="post-metadata">

**Author:** ![infofcc3](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/infofcc3/32/51248_2.png) [@infofcc3](https://community.grafana.com/u/infofcc3)\
**Post date:** [August 14, 2026, 5:33am UTC](https://community.grafana.com/t/cant-read-boolean-data-from-google-bigquery-database/164120/4 "2026-08-14T05:33:05Z")

</div>

Hi @fangdi just wanted to check if you got the solution . Happy to help further if you are facing any issues .