Apache Arrow Flight API
Query web3 data with SQL via the Apache Arrow Flight API
SQL query results are now available as Apache Arrow data frames via a high-performance Apache Arrow Flight endpoint.
You may also use Apache's
pyarrow
library directly.- Use the gRPC + TLS URL:
grpc+tls://flight.spiceai.io
- Use basic authentication
- Username can be set to an empty string
- Password should be set to the API key of your app
If you get this error:
Could not get default pem root certs
First download the
roots.pem
file from the Let's Encrypt server:curl -Lo isrgrootx1.pem https://letsencrypt.org/certs/isrgrootx1.pem
Before running your code/jupyter notebook the environment variable
GRPC_DEFAULT_SSL_ROOTS_FILE_PATH
must be set to the pem file path. If you are using command from a terminal this can be done from the folder containing isrgrootx1.pem
with:export GRPC_DEFAULT_SSL_ROOTS_FILE_PATH="$PWD/isrgrootx1.pem"
The
export
command will set this variable for this specific terminal and thus will need to be run every time you open a new terminal. Additionally you can add to your terminal profile.Note that
$PWD
is a bash-specific variable that will be replaced by the current directory path. You can download the certificate file isrgrootx1.pem
in a specific location and inform this path instead of $PWD
.Last modified 4mo ago