Hi, On 22/04/2021 14:01, Sanaa GHANDI wrote:
For example, I want to get the results coming from sources: X and Y, and targeting the anchor 6771.
This kind of query can be where the public bigquery datasets are useful, because bigquery will let you walk through the result data directly. (Some details and pre-requisites are at [1,2]). Something as simple as this query would be a good start for the question above:
select distinct msm_id from `ripencc-atlas`.yesterday.traceroute where (prb_id = X or prb_id = Y) and (af = 4 and dst_addr = "91.201.7.243")
Note we're expanding the available public datasets a bit from what's currently in the docs: * "yesterday" is a dataset that refers to measurements collected yesterday * "24hours" is a dataset referring to the most recent 24 hours * "samples" is a truly tiny dataset for prototyping and is great for getting started * "measurements" is most data reaching 18+ months back, and where you should definitely use a date filter in the query :-) Depending on what you're trying to get out of the data, the above might be enough to get you started. Feel free to throw general questions here, or technical questions to atlas-bq@ripe.net Cheers, S. [1] https://github.com/RIPE-NCC/ripe-atlas-bigquery [2] https://github.com/RIPE-NCC/ripe-atlas-bigquery/blob/main/docs/gettingstarte...
Now I can get the measures targeting the anchor 6771 using this code from Altas Cousteau
################################################################## from ripe.atlas.cousteau import MeasurementRequest
filters = {'tags': ['anchoring','mesh',6771] }
measurements = MeasurementRequest(**filters) ####################################################################
But I have no idea of how to make a filter on the sources as well, since all we can access through the measurements are the number of anchors requested and not their ids.
Do you know a way to get access to the sources of a measurement via Atlas Cousteau or another Ripe Tool ?
Thank you
-- Sanaa