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.
I never tried Select * but assume that should work.
Here’s a query I found that I had working with BQ
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
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
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.
1 Like
Here’s the way to submit a ticket.
1 Like