All Questions
2 questions
0
votes
1
answer
268
views
Unioned table costs more to query in BigQuery than individual tables?
BigQuery cost scenarios
When I query a large unioned table - partitioned by date field and clustered by a clientkey field - for a specific client's data it appears to process more data than if I just ...
19
votes
1
answer
7k
views
What's a good balance to decide when to partition a table in BigQuery?
We are using a public dataset to benchmark BigQuery. We took the same table and partitioned it by day, but it's not clear we are getting many benefits. What's a good balance?
SELECT sum(score)
FROM ...
- 59.5k