Hi Jenica:

One option would be to use Query.truncateTable(), then Query.insertRows(). You would not typically use executeSql(), which is an action more for viewing/querying data, not editing it.

I'm going to move this question to your private support portal, where we can give more customized assistance about the context of your question and use case.

Thank you for reaching out,

--Molly