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?

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

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] I never tried Select * but assume that should work. Here’s a query I found that…

[image] Eric Penner: 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…

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.

[image] How to open a support ticket? Ask for Help 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 Glid…

BigQuery doesn't get all rows matching query

Ask for Help

ThinhDinh June 28, 2023, 1:06am 6

Here’s the way to submit a ticket.

Topic		Replies	Views
Big Table Q&A Ask for Help big-tables	2	493	April 2, 2023
Choice component in Glide Big Table Ask for Help	5	48	September 28, 2024
Help Glide Bigtable Ask for Help	1	184	September 28, 2023
Glide API: Can I only get rows from Big Tables? Ask for Help api	6	100	February 2, 2025
How to Export Big Tables Natively (No Make Required) Project Showcase tutorial	3	109	February 19, 2026

BigQuery doesn't get all rows matching query

Related topics