Signup/Login Blog Twitter Discord Telegram

DuckDB Export Database

Exporting Firecache for import into DuckDB.

The underlying DuckDB database behind Firecache can be exported and downloaded via the /firecache/export API, which can be useful for local analysis and debugging.

Warning: Running export on a high-load Firecache can significantly affect its performance during the export and should be used with caution.

POST to the API to download the archive as Parquet. E.g.

curl --request POST \
  --url https://data.spiceai.io/v1/firecache/export \
  --header 'X-API-Key: <Your API Key>'
  --output firecache.zip

Then unzip the archive and import into DuckDB.

// Run in DuckDB
IMPORT DATABASE 'firecache';

Options can be passed via the body E.g.

curl --request POST \
  --url https://data.spiceai.io/v1/firecache/export \
  --header 'Content-Type: application/json' \
  --header 'X-API-Key: <Your API Key>'
  --data '{
	"format": "csv"
}'
  --output firecache_csv.zip

See the DuckDB import/export documentation for all format/compression options and more information on importing to DuckDB.

Firecache Export Database

POST https://data.spiceai.io/v1/firecache/export

Export the underlying DuckDB Database as CSV or Parquet for import into DuckDB.

Request Body

Last updated