Over the past few decades, using big data sets required businesses to perform increasingly complex analyses. Lower memory costs spurred the creation of technologies that support in-memory query processing for https://www.influxdata.com/glossary/olap/ (online analytical processing) and data warehousing systems.
Another benefit of Apache Arrow is its integration with Apache Arrow Flight SQL.
https://arrow.apache.org/blog/2022/02/16/introducing-arrow-flight-sql/ is a “new client-server protocol developed by the Apache Arrow community for interacting with SQL databases that makes use of the Arrow in-memory columnar format and the Flight RPC framework.”
It also enables faster data transfer with the help of Apache Arrow Flight SQL.