Skip to main content

Spice.ai Data Connector

The Spice.ai Data Connector enables federated SQL query across datasets in the Spice.ai Cloud Platform. Access to these datasets requires a free Spice.ai account.

Configuration​

Secrets​

Secrets will be written to a .env file by using the spice login command and logging in with an active Spice AI account. Learn more about the Env Secret Store.

  • api_key: A Spice.ai API key.
  • token: An active personal access token that is configured when logging in to spice via spice login

Parameters​

  • from: The Spice.ai dataset ID. For instance spice.ai/eth.recent_blocks or spice.ai/eth.recent_traces

Example​

- from: spice.ai/eth.recent_blocks
  name: eth_recent_blocks

Full Configuration Example​

- from: spice.ai/eth.recent_blocks
  name: eth_recent_blocks
  params:
    spiceai_api_key: ${secrets:spiceai_api_key}
  acceleration:
    enabled: true
    refresh_mode: append
Limitations

refresh_mode: append is supported for the following datasets:

  • eth.recent_blocks
  • eth.recent_transactions
  • eth.recent_traces

All other datasets need to be configured with refresh_mode: full.