etl icon indicating copy to clipboard operation
etl copied to clipboard

Add ArchiveSize and FileSize attribute to the ParseInfo structure

Open stephen-soltesz opened this issue 1 year ago • 2 comments

From the analysis of scamper1 data, we suspect that a significant portion (as high as 70% of some datatypes) of all archive data is either operation or ambient traffic - rather than data from NDT and other service measurements.

To estimate the portion of data in these various categories and the potential to save resources, we want to add new ParseInfo fields for the ArchiveSize (in GCS) and FileSize (uncompressed). With these fields, we can construct aggregate queries to find the total bytes used and billed for real test data or other sources.

stephen-soltesz avatar Jun 01 '23 20:06 stephen-soltesz

https://github.com/m-lab/etl/releases/tag/prod-v2.27.0

stephen-soltesz avatar Jun 06 '23 19:06 stephen-soltesz

Production deployment caused a brief outage until we manually repaired the web100 tables with the updated schemas.

stephen-soltesz avatar Jun 06 '23 19:06 stephen-soltesz