Apache Arrow Flight API
SQL Query Apache Arrow Flight API
SQL query results can be served via a high-performance Apache Arrow Flight endpoint. Arrow Flight uses the gRPC protocol for efficient data transfer.
This setup enables high-speed access to your data in Python, Go, C++, C#, Rust, Java, and C# and makes it easy to use libraries like Pandas and NumPy.
SDKs
It's recommended to use the Spice.ai SDKs to connect and query the Arrow Flight endpoint. SDKs are available for Python, Node.js, Go, Rust, Java, and Dotnet.
In Python, query results can be easily converted to Pandas or NumPy formats.
You may also use Apache's pyarrow
library directly.
Connecting to the Endpoint
Endpoint URL:
grpc+tls://flight.spiceai.io
Basic Authentication:
Username can be set to an empty string
Password should be set to the API key of your app
Requirements
Table names must be fully-qualified. For example
spiceai.quickstart
Samples
Find code samples in Python in Arrow Flight Samples.
Troubleshooting
Mac/Windows Certificate issue
If you get this error:
Could not get default pem root certs
Install the Let's Encrypt root certificates.
Last updated
Was this helpful?