Uploaded November 2025 | Updated September 2026, 1 week ago
RIPE RIS collects BGP data from collectors worldwide, providing visibility into routing dynamics. While this data powers RIPEstat and various third-party applications, operators and researchers often need analyses beyond what standard tools offer. On the other hand, using raw data MRT directly, is challenging. It is computationally intensive and requires custom parsing scripts.
We are now publishing RIPE RIS data as indexed Parquet files, covering recent BGP
RIBs and updates. This means you can query routing data using SQL or datascience
tools rather than using MRT parsers. An analysis that previously took 10+ minutes
can now be done in seconds.
This approach has already proved valuable for our internal operations. When the
Baltic Sea cables were damaged, we could quickly explore the BGP impact. When analysis
the effects of the Iberian Peninsula power outage on BGP, we could investigate effects
within minutes instead of hours. This new data makes using route collector data
much faster and much more accessible.
This presentation will introduce the files and show how to use these new capabilities
through practical examples. I'll show how network operators can analyse bview/RIB/bgp snapshot
data and BGP updates this way - from investigating routing over time, to analysing stuck prefixes, or analysing the upstreams of a network as seen by collectors.
This data removes the traditional barriers of MRT processing, and makes BGP data analysis much more accessible, using much more tools and skills.
Ties de Kock: Ties de Kock is a software engineer at RIPE NCC where he works on internet measurement projects RIS and RIPEstat. In this role, he analyses BGP datasets for both operational incidents and long-term routing trends. Ties mostly spends his time developing tools that help network operators and researchers understand global routing behaviour. Prior to this, he worked on RPKI - from building certificate authority software to contributing to RPKI standardisation.
RIPE RIS collects BGP data from collectors worldwide, providing visibility into routing dynamics. While this data powers RIPEstat and various third-party applications, operators and researchers often need analyses beyond what standard tools offer. On the other hand, using raw data MRT directly, is challenging. It is computationally intensive and requires custom parsing scripts.
We are now publishing RIPE RIS data as indexed Parquet files, covering recent BGP
RIBs and updates. This means you can query routing data using SQL or datascience
tools rather than using MRT parsers. An analysis that previously took 10+ minutes
can now be done in seconds.
This approach has already proved valuable for our internal operations. When the
Baltic Sea cables were damaged, we could quickly explore the BGP impact. When analysis
the effects of the Iberian Peninsula power outage on BGP, we could investigate effects
within minutes instead of hours. This new data makes using route collector data
much faster and much more accessible.
This presentation will introduce the files and show how to use these new capabilities
through practical examples. I'll show how network operators can analyse bview/RIB/bgp snapshot
data and BGP updates this way - from investigating routing over time, to analysing stuck prefixes, or analysing the upstreams of a network as seen by collectors.
This data removes the traditional barriers of MRT processing, and makes BGP data analysis much more accessible, using much more tools and skills.
Ties de Kock: Ties de Kock is a software engineer at RIPE NCC where he works on internet measurement projects RIS and RIPEstat. In this role, he analyses BGP datasets for both operational incidents and long-term routing trends. Ties mostly spends his time developing tools that help network operators and researchers understand global routing behaviour. Prior to this, he worked on RPKI - from building certificate authority software to contributing to RPKI standardisation.
