I want my scheduled query to call an endpoint predefined by me whenever it runs and returns results
Support pagination natively via the API
When querying the API we'll need to implement pagination by passing specific LIMIT / OFFSET parameters to the query. We want to be able to gauge the full data size in the response, even with these parameters added. Currently suggested workaround are: creating a separate SELECT count(*) FROM query create a conditional loop These are fine interim solution, but could get expensive and we'd like to be cost efficient as we scale. Thus, we'd love to have pagination natively supported via the API.
More economic execution type for low latency queries
Add another execution type for queries which need to be executed very frequently via the API but which execute in a few seconds.
API: Date format mismatch between parameter and data
Currently, the returned date is in the format: 2022-10-22T00:00:00+00:00 but a parameter is in the format: 2022-10-22 00:00:00 In order to minimize our datapoint usage of the API, we store the last replication key value, but because of this format mismatch, we need to convert returned dates to parameter dates.
Terraform Provider Support
As Dune API is launched, this opens up the possibility of having a terraform provider for it. This might not make sense for individuals. But for medium to larger teams, it might allow ease of managing multiple queries and dashboards as well as the changes made to them. I'm keen to kickstart this but want to see if there are enough interest in this ?