v2

latestOpenAPI 3.1.02026-08-05313314398.1 KB
databases

Query Database

Run a DuckDB SQL query against the database's Parquet data.

get/api/v1/databases/{database_id}/query

Path parameters

database_idstring uuid required

Query parameters

sqlstring required

SQL query (table is named 'data')

SQL query (table is named 'data')

limitinteger

Response

Successful Response

columnsstring[] required
rowsobject[] required
total_rowsinteger required
truncatedboolean required