Dear Team,
Dremio cloud API’s are taking more time than expected. Not sure if anything has been changed from Dremio side rececently. we are observing this slowness from last 3-4 days.
https://api.dremio.cloud/v0/projects/project-id/sql
https://api.dremio.cloud/v0/projects/project-id/jobs/results - it takes more than 20 seconds for some request
Regards,
Soumya Ranjan
Hi @s.ranjan0404 ,
I tested this on my end and the API executed almost immediately. I have messaged you for additional details.
Hi @s.ranjan0404 ,
Our engineering team has provided a temporary method to improve API performance if you are interested. This will require enabling the support key jobs.max.age_in_days
on your project. This support key will change the default 30 days of jobs to a X amount of your choice, i.e 7 days. The lower the amount of days, the better the performance, as it will ignore jobs older than X amount of days.
Please let @hope know if you would like this enabled, and for how many days.
Cindy
Hi @cindy.la / @hope ,
Let’s not change for now. as we are connecting Dremio cloud using arrow flight. will let you know if we face any performance issue using arrow flight.
Regards,
Soumya Ranjan
Hi @s.ranjan0404,
Sounds good, let me know if you encounter anything or would like the support key set in the future!
Cindy