# BigQuery doesn't get all rows matching query

**URL:** <https://community.glideapps.com/t/bigquery-doesnt-get-all-rows-matching-query/63170>\
**Category:** Ask for Help\
**Created:** [June 26, 2023, 3:47pm UTC](https://community.glideapps.com/t/bigquery-doesnt-get-all-rows-matching-query/63170 "2023-06-26T15:47:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![derek1](https://avatars.discourse-cdn.com/v4/letter/d/a5b964/32.png) [@derek1](https://community.glideapps.com/u/derek1)\
**Post date:** [June 26, 2023, 3:47pm UTC](https://community.glideapps.com/t/bigquery-doesnt-get-all-rows-matching-query/63170/1 "2023-06-26T15:47:13Z")

</div>

Hello,

When I write my query

SELECT  
\*  
FROM  
`my_database`  
WHERE  
score \> 3  
LIMIT  
1000

In the BigQuery native search, I get 29 matches. Glideapp, with the same query copy-pasted, only pulls in 4 matches. Why?

---

<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:** [June 26, 2023, 11:17pm UTC](https://community.glideapps.com/t/bigquery-doesnt-get-all-rows-matching-query/63170/2 "2023-06-26T23:17:16Z")

</div>

I think you have used BigQuery @Eric_Penn . Do you have any insights?

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [June 27, 2023, 12:41am UTC](https://community.glideapps.com/t/bigquery-doesnt-get-all-rows-matching-query/63170/3 "2023-06-27T00:41:07Z")

</div>

Hmmm query looks ok. If your data came from GSheet CSV Export one thing I noticed is that if I formatted my columns in GSheet first it helped with the Auto Detect Schema option.

 ![Screen Shot 2023-04-18 at 4.07.00 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/73ed73b0609317cfced60dcbaf2a320e0d8445a5.png)

I never tried Select \* but assume that should work.

Here’s a query I found that I had working with BQ

```auto
SELECT
UID as id,
SUM(Profit) as total_profit, SUM(Tips) as total_tips
FROM
  `project-lt-314.Database.CompleteRecords`
GROUP BY UID
LIMIT
  2000

```

---

<div class="post-metadata">

**Author:** ![derek1](https://avatars.discourse-cdn.com/v4/letter/d/a5b964/32.png) [@derek1](https://community.glideapps.com/u/derek1)\
**Post date:** [June 27, 2023, 4:12pm UTC](https://community.glideapps.com/t/bigquery-doesnt-get-all-rows-matching-query/63170/4 "2023-06-27T16:12:51Z")

</div>

> [@Eric\_Penn](#):
>
> Hmmm query looks ok. If your data came from GSheet CSV Export one thing I noticed is that if I formatted my columns in GSheet first it helped with the Auto Detect Schema option.

My data did not come from a GSheet CSV Export. It’s just a database we built in BigQuery. It’s not a columns issue. It’s a rows issue - like, why are only 4 rows being added? Instead of the 29 that show if I do the same query in my BigQuery console

---

<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:** [June 27, 2023, 4:20pm UTC](https://community.glideapps.com/t/bigquery-doesnt-get-all-rows-matching-query/63170/5 "2023-06-27T16:20:25Z")

</div>

I don’t think there’s a lot of folks with Big Query experience here in the Community. In this case, you might be best raising a ticket directly with Glide Support.

---

<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:** [June 28, 2023, 1:06am UTC](https://community.glideapps.com/t/bigquery-doesnt-get-all-rows-matching-query/63170/6 "2023-06-28T01:06:46Z")

</div>

> [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2):
>
> Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: Glide will prompt you to create a support link for your App. Click on Create Link:

Here’s the way to submit a ticket.