<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi,<br>
</p>
<div class="moz-cite-prefix">On 22/04/2021 14:01, Sanaa GHANDI
wrote:</div>
<blockquote type="cite"
cite="mid:1068358647.5286432.1619092864749.JavaMail.zimbra@imt-atlantique.fr">
<pre class="moz-quote-pre" wrap="">For example, I want to get the results coming from sources: X and Y, and targeting the anchor 6771.</pre>
</blockquote>
<p>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]).</p>
<p>Something as simple as this query would be a good start for the
question above:<br>
</p>
<p>> select distinct msm_id<br>
> from `ripencc-atlas`.yesterday.traceroute<br>
> where (prb_id = X or prb_id = Y)<br>
> and (af = 4 and dst_addr = "91.201.7.243")<br>
</p>
<p><br>
Note we're expanding the available public datasets a bit from
what's currently in the docs:<br>
</p>
<ul>
<li>"yesterday" is a dataset that refers to measurements collected
yesterday</li>
<li>"24hours" is a dataset referring to the most recent 24 hours</li>
<li>"samples" is a truly tiny dataset for prototyping and is great
for getting started</li>
<li>"measurements" is most data reaching 18+ months back, and
where you should definitely use a date filter in the query :-)</li>
</ul>
<p>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 <a class="moz-txt-link-abbreviated" href="mailto:atlas-bq@ripe.net">atlas-bq@ripe.net</a></p>
<p><br>
</p>
<p>Cheers,</p>
<p>S.</p>
<p><br>
</p>
<p><br>
</p>
<p>[1] <a class="moz-txt-link-freetext" href="https://github.com/RIPE-NCC/ripe-atlas-bigquery">https://github.com/RIPE-NCC/ripe-atlas-bigquery</a><br>
[2]
<a class="moz-txt-link-freetext" href="https://github.com/RIPE-NCC/ripe-atlas-bigquery/blob/main/docs/gettingstarted.md">https://github.com/RIPE-NCC/ripe-atlas-bigquery/blob/main/docs/gettingstarted.md</a><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<blockquote type="cite"
cite="mid:1068358647.5286432.1619092864749.JavaMail.zimbra@imt-atlantique.fr">
<pre class="moz-quote-pre" wrap="">
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
</pre>
</blockquote>
</body>
</html>