How do you find the querying costs?
It seems like for many use cases, you'd have to pay quite a bit of attention to partitioning the database in a way that minimizes query costs.
It seems like for many use cases, you'd have to pay quite a bit of attention to partitioning the database in a way that minimizes query costs.
As BQ only supports DAY partitioning, I had to create multiple tables that represent the other dimensions, but it seems to work OK, if a little clunky when you have to use wildcards/_TABLE_SUFFIX
Disclosure: I'm https://twitter.com/felipehoffa and I work for Google Cloud. And I'm really excited to reprocess all public tables into clustered ones.