The the-psf:pypi.file_downloads table is partitioned by day, which makes time-limited queries easier to write than having to concatenate tables. Also, it is clustered by project, which makes the vast majority of queries people would want to do (count downloads for a specific package) much more efficient.
The
the-psf:pypi.file_downloadstable is partitioned by day, which makes time-limited queries easier to write than having to concatenate tables. Also, it is clustered byproject, which makes the vast majority of queries people would want to do (count downloads for a specific package) much more efficient.