Hello,
I have a CTAS statement that needs to be scheduled once a day. The underlying query is too slow for real-time usage (10 mins) and it would be better if I scheduled it. Is there any functionality that would allow this?
Thanks
Theo
You could write and script that logins into Dremio and submits the CTAS job via our HTTP API:
https://docs.dremio.com/rest-api/sql/post-sql.html at the desired interval
1 Like