[atlas] Filtering measurements

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 at 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/gettingstarted.md




>
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </ripe/mail/archives/ripe-atlas/attachments/20210422/566c2e17/attachment.html>