As stated in previous post I am playing with Clickhouse database for a while and honestly getting addicted to put more & more tooling around it. With holding of full dumps as well as the capability to query them within a second opens up many possibilities. One of that is finding cases where more than two transit free tier 1 ASNs are appearing in AS_PATH. Understanding transit-free mesh Before proceeding with the data it’s important to understand what is wrong when three tier 1 ASNs appear i...