2 ms·
For this trial we are transferring some data from AWS, which is already partitioned in S3 by quite a few dimensions, including DAY. As BQ only supports DAY par
by djhworld 8y ago
For this trial we are transferring some data from AWS, which is already partitioned in S3 by quite a few dimensions, including DAY.
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