Skip to main content

DCS Query Examples




SQL Query Data Example  

The query allows a user to make a request using natural language. OpenAI ChatGPT will attempt to generate a complex SQL query. The query will then be sent to ElasticSearch. Both query and results are returned to the user.
Examples:
find three goes records with agency = 'NOANOS' since yesterday
find 5 goes records with agency = 'NOANOS' between '2023-04-02' and '2023-05-03'
retrieve ten goes records from last two days
find 3 goes records with platformId=CE44B7BA



Search Query Example

The query allows a user to make a filtered request. Filters can be applied using existing attribute:value
agency:NOANOS
platformId:CE44B7BA
Baud:1200
flags:0x00081c55




Get Example

The query allows a user to download a DCP given a specific Content ID (cid).
User can also specify a storage class such as s3,cf (Cloudfront) or r2 (CloudFlare if available)
The system will return a presigned url valid for 15mn
User can also download from the browser using the download button
agency:NOANOS
platformId:CE44B7BA
Baud:1200
flags:0x00081c55





Code Snippet