Query Apache Arrow Flight SQL servers directly from DuckDB
Why DuckArrow?
DuckArrow bridges DuckDB with Apache Arrow Flight SQL servers, letting you query remote data with familiar SQL syntax. No ETL pipelines, no data movement—just query.
Features
- Simple Syntax — Query remote tables with
SELECT * FROM duckarrow."TableName" - Blazing Fast — 7-9x speedup with column projection pushdown
- Connection Pooling — Reuses gRPC connections for quick subsequent queries
- Full Type Support — 20+ Arrow types including DECIMAL, LIST, STRUCT, MAP
- Secure — SQL injection prevention, TLS encryption support
- Cross-Platform — Linux, macOS, Windows (x86_64 and ARM64)
Quick Start
-- Load the extension
LOAD './duckarrow.duckdb_extension';
-- Configure your Flight SQL server
SELECT duckarrow_configure('grpc+tls://server:31337', 'username', 'password');
-- Query remote tables like they're local
SELECT id, customer_name, total FROM duckarrow."Orders" LIMIT 10;
Learn More
MIT License — Built with DuckDB + Apache Arrow