A duckdb extension to execute SQL queries on compliant Arrow Flight servers
- Compile the extension:
make configure
make release- Load the extension (NOTE: enable unsigned support in duckdb):
duckdb -unsigned
...
D Load 'path/to/flight_school.duckdb_extension';- Ensure the Arrow Flight SQL server is running in the background
- Query the flight server:
D SELECT * FROM flight_school('SELECT id FROM users', remote='http://example-flight-server:8080');Airport is an Arrow Flight SQL server backed by a duckdb instance, connect to it through flight_school extension to run SQL remotely.
RUST_LOG=info cargo run --bin airport --no-default-features --features server