m-lab / etl-gardener

Gardener provides services for maintaining and reprocessing mlab data.
Apache License 2.0
13 stars 5 forks source link

Server location annotations should be based on site info, not on IP geolocation #319

Open critzo opened 3 years ago

critzo commented 3 years ago

This is needed sooner than later. Multiple users now wish to query to know the locations of our servers and need it to support their funding requests in addition to using it in their analyses.

critzo commented 3 years ago

FYI, I'm going to create an interim solution by exporting server metadata from siteinfo and loading that into a BigQuery table.

critzo commented 3 years ago

Also noting that after chatting with @mattmathis the ndt7 data does contain the correct server location annotations but the ndt5 data does not.