Big query has an interesting pricing and I do kinda like it. You pay for data in, while processing is basically free.
I don’t know the query they used, but limit can limit data scanned.
It’s been a long time since I used BQ, but I remember their query optimizer not being particularly advanced, so you had to be really careful where you put the limit.
I don’t know the query they used, but limit can limit data scanned.
It’s been a long time since I used BQ, but I remember their query optimizer not being particularly advanced, so you had to be really careful where you put the limit.