FIDO is Explo’s data orchestration service. There are a lot of benefits compared to the previous data querying architecture including:

  • Persistent database connection management, eliminating connection latency for queries (connection and SSH tunneling time)
  • Longer timeouts configurable for queries
  • Querying databases within a certain region of the world for data residency requirements and speed optimizations
  • Connect via SSH tunneling, AWS PrivateLink, and more

​
Resources

  • We’ve also talked about it a bit on our engineering blog if you’d like to read more.

  • Here is a slide that we presented with a partner showing one customer’s speed-up (your results may vary of course). Data Orchestration Results

  • Here is a talk that Gary (co-founder) gave about the query service

    Optimizing Analytics Platforms with ClickHouse (March 2025)