Comment on page
Python SDK
The Python SDK uses Apache Apache Flight to efficiently stream data to the client and Apache Arrow Records as data frames which are then easily converted to Pandas data frames.
- Python 3.8+
The following packages are required and will be automatically installed by pip:
pyarrowpandasweb3
Apple M1 Macs require an arm64 compatible version of
pyarrow which can be installed using miniforge. We recommend the following procedure:brew install --cask miniforge
- Initialize conda in your terminal with:
conda init "$(basename "${SHELL}")"
- Install
pyarrowandpandaswith:
conda install pyarrow pandas
Install the
spicepy package directly from the Spice Github Repository at https://github.com/spiceai/spicepy:pip install git+https://github.com/spiceai/[email protected]
Import
spicepy and create a Client by providing your API Key.You can then submit queries using the query function.
import spicepy
client = spicepy.Client('API_KEY')
block_data = client.query('SELECT * FROM eth.recent_blocks LIMIT 10;').read_pandas()
transaction_Data = client.query('SELECT * FROM eth.recent_transactions LIMIT 10;').read_pandas()
Querying data is done through a
Client object that initializes the connection with the Spice.ai endpoint. Client has the following arguments:- api_key (string, required): API key to authenticate with the endpoint.
- url (string, optional): URL of the endpoint to use (default: grpc+tls://flight.spiceai.io)
- tls_root_cert (Path or string, optional): Path to the tls certificate to use for the secure connection (ommit for automatic detection)
Once a
Client is obtained queries can be made using the query() function. The query() function has the following arguments:- query (string, required): The SQL query.
- timeout (int, optional): The timeout in seconds.
A custom timeout can be set by passing the
timeout parameter in the query function call. If no timeout is specified, it will default to a 10 min timeout then cancel the query, and a TimeoutError exception will be raised.Last modified 1mo ago