Store query results

Looking to run scheduled sql queries (most likely daily), and store these results back in Druid. This may require updating current records as well as storing new records in an existing Datasources. Main application is written in Java.

Is there a good or recommended way to do this?
Cheers

This can be done using appendToExisting for an existing data source. Further read: https://druid.apache.org/docs/latest/tutorials/tutorial-update-data.html