Query
Fetch, export, delete and subscribe to data
Overview
The Query API allows developers to list available data to query, fetch, export and delete data from the internal in-memory database.
Database schema where the table resides. Dynamically set by the use case DSL as the stream processing name
standardQuoteAnalyticsStream
Table to trigger data export
quotes
Date time parameter to define point in time to start from.
2022-10-14 17:00:00
Date time parameter to define point in time to go too.
2022-10-14 18:00:00
Page offset to fetch next set of events.
1
Number of events to return.
1000
GET /joule/query/{schema}/{table}?offset=1 HTTP/1.1
Host:
Accept: */*
[
{
"eventType": "text",
"lineage": {
"ANY_ADDITIONAL_PROPERTY": 1
},
"eventTime": 1,
"ingestTime": 1,
"value": {},
"uUID": "text",
"subType": {},
"dictionary": {
"ANY_ADDITIONAL_PROPERTY": {}
},
"snapshot": {
"": {},
"present": true,
"empty": true
}
}
]
Database schema where the table resides. Dynamically set by the use case DSL as the stream processing name.
standardQuoteAnalyticsStream
Table to trigger data export upon.
processed
The data export type. Supported types parquet and csv.
parquet
Date time parameter to define point in time to start from.
2022-10-14 17:00:00
Date time parameter to define point in time to go too.
2022-10-14 18:00:00
Place to land export file too
~/quotes.parquet
GET /joule/export/{schema}/{table}/{type}?from=2022-10-14+17%3A00%3A00&to=2022-10-14+18%3A00%3A00&path=~%2Fquotes.parquet HTTP/1.1
Host:
Accept: */*
No content
Database schema where the table resides. Dynamically set by the use case DSL as the stream processing name.
standardQuoteAnalyticsStream
Table to trigger data delete upon.
processed
Date time parameter to define point in time to start from.
2022-10-14 17:00:00
Date time parameter to define point in time to go too.
2022-10-14 18:00:00
DELETE /joule/delete/{schema}/{table}?from=2022-10-14+17%3A00%3A00&to=2022-10-14+18%3A00%3A00 HTTP/1.1
Host:
Accept: */*
No content
Last updated
Was this helpful?