search

m-lab / etl

M-Lab ingestion pipeline
Apache License 2.0
22 stars 7 forks source link

Add ArchiveSize and FileSize attribute to the ParseInfo structure #1116

Open stephen-soltesz opened 1 year ago

stephen-soltesz commented 1 year ago

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 commented 1 year ago

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

stephen-soltesz commented 1 year ago

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