# Bigquery data limit

**URL:** <https://community.glideapps.com/t/bigquery-data-limit/57641>\
**Category:** Ask for Help\
**Created:** [February 8, 2023, 3:49am UTC](https://community.glideapps.com/t/bigquery-data-limit/57641 "2023-02-08T03:49:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Larry\_engineer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/larry_engineer/32/18874_2.png) [@Larry\_engineer](https://community.glideapps.com/u/Larry_engineer)\
**Post date:** [February 8, 2023, 3:49am UTC](https://community.glideapps.com/t/bigquery-data-limit/57641/1 "2023-02-08T03:49:13Z")

</div>

I’m a bit confused. If I’m using bigquery. How does the row limit work??? If my bigquery/my query contains more than 25k rows and I have a Glide Business subscription, how do I control which data to show?

Thank you guys! 🙂

---

<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:** [February 8, 2023, 11:49pm UTC](https://community.glideapps.com/t/bigquery-data-limit/57641/3 "2023-02-08T23:49:56Z")

</div>

@Darren_Murphy @Robert_Petitto have you guys had experience with BigQuery?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 9, 2023, 2:03am UTC](https://community.glideapps.com/t/bigquery-data-limit/57641/4 "2023-02-09T02:03:21Z")

</div>

With BigQuery the idea is that you do all of your data aggregation using SQL, and just present the results to Glide. For example, you might have a BigQuery table that contains 1 billion rows, but what you would probably do is write an SQL query that aggregates that table by day/year/month/whatever. So instead of trying to load 1 billion rows into Glide, you might only be loading 12. Or 365…

---

<div class="post-metadata">

**Author:** ![Larry\_engineer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/larry_engineer/32/18874_2.png) [@Larry\_engineer](https://community.glideapps.com/u/Larry_engineer)\
**Post date:** [February 10, 2023, 9:30am UTC](https://community.glideapps.com/t/bigquery-data-limit/57641/5 "2023-02-10T09:30:40Z")

</div>

So what happens if my aggregation contains more than the row limit? They cut off the data?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 10, 2023, 9:43am UTC](https://community.glideapps.com/t/bigquery-data-limit/57641/6 "2023-02-10T09:43:35Z")

</div>

I can’t answer that question.

I suspect with things like Big Query and Glide Big Tables just around the corner, Glide might reviewing row limits sometime in the future.

One thing that David made clear in his presentation last month is that they want to remove row count as a limiting factor of Glide. So as long as you are willing to pay, there will always be an option available that supports very large data sources.