liveBook · Manning

Arrow Database Connectivity

As explained in Architecting an Apache Iceberg Lakehouse

ADBC is an Arrow-based database connectivity interface for high-performance access to analytical data systems.

Arrow Database Connectivity (ADBC) is a cross-language, database-style API for low-latency columnar access. It uses Apache Arrow as the in-memory format, reducing serialization and copying overhead compared with traditional drivers. section 8.2.3 section 9.3.2

Within a federated lakehouse, ADBC complements JDBC and ODBC by providing a fast path for notebooks, AI platforms, and custom applications retrieving governed datasets from query engines. section 8.2.3 section 9.3.2

ADBC and its Arrow Flight foundation support:

  • Large dataset retrieval with reduced serialization costs and memory overhead. section 8.2.3
  • Partitioned, parallelized results and intersystem execution across distributed query engines. section 8.2.3
  • Authentication tokens, parallel streams, and interoperability with Arrow Flight SQL. section 9.3.2
Figure 9.3 JDBC transfers data in a row-based format, while Apache Arrow Flight transfers data in a columnar format that’s ideal for analytics.

Contrasts JDBC row-based transfer with Arrow Flight columnar transport optimized for analytics. section 9.3.2

How Architecting an Apache Iceberg Lakehouse covers it

How deep it goes
Explains Arrow columnar transport, reduced copying, parallel streams, and API relationships, but omits implementation-level driver details.
Examples
Uses Dremio, notebooks, Python, R, AI platforms, custom applications, and large federated datasets as usage examples.
What it assumes
Assumes familiarity with federated lakehouse architecture, query engines, and traditional database connectivity interfaces.
What you can do after
Apply it via ADBC and Arrow Flight to retrieve governed analytical datasets efficiently from supported query engines.
How it connects
Ties ADBC to Apache Arrow, Arrow Flight, Arrow Flight SQL, JDBC, ODBC, query engines, and Iceberg tables.

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Architecting an Apache Iceberg Lakehouse. The section links point to the parts of the book it draws on.