# Using BigQuery data and managing related information with Connected Sheets

**URL:** <https://community.glideapps.com/t/using-bigquery-data-and-managing-related-information-with-connected-sheets/85966>\
**Category:** Ask for Help\
**Created:** [January 10, 2026, 1:01am UTC](https://community.glideapps.com/t/using-bigquery-data-and-managing-related-information-with-connected-sheets/85966 "2026-01-10T01:01:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![swampyedwards](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/swampyedwards/32/92638_2.png) [@swampyedwards](https://community.glideapps.com/u/swampyedwards)\
**Post date:** [January 10, 2026, 1:01am UTC](https://community.glideapps.com/t/using-bigquery-data-and-managing-related-information-with-connected-sheets/85966/1 "2026-01-10T01:01:44Z")

</div>

I have started using a data source from BigQuery but soon came up against the limitation where you cannot use related values to look up records in BQ. I have however managed to use the Connected Sheet function in Google Sheets to get to the data source and have extracted that data set to a seperate sheet. This Google sheet is linked to my app and I am seeing full lookup etc.

My question is has anyone else used this method and should I be wary of any gotch yas?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 10, 2026, 3:12am UTC](https://community.glideapps.com/t/using-bigquery-data-and-managing-related-information-with-connected-sheets/85966/2 "2026-01-10T03:12:03Z")

</div>

Interesting, can you tell me more about the limitation on not being able to use related values to look up records? I haven’t used Big Query in Glide before, is this some sort of a calculation limitation like we have with Glide Big Tables?

---

<div class="post-metadata">

**Author:** ![swampyedwards](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/swampyedwards/32/92638_2.png) [@swampyedwards](https://community.glideapps.com/u/swampyedwards)\
**Post date:** [January 14, 2026, 3:52pm UTC](https://community.glideapps.com/t/using-bigquery-data-and-managing-related-information-with-connected-sheets/85966/3 "2026-01-14T15:52:40Z")

</div>

I believe so - but setting up an extract in to a Google Sheet tab with a scheduled refresh fixed my issue (also I wasn’t expecting to use too many rows as the data is a rolling 6 week set of data)