Hi Team, we are using a singlestore stored procedure for shaping our data. Is there a way to truncate a table before a file load is done.
Our use-case is like, the CSV file generated will be self sufficient and will have all the data required. so if we receive a file, we want to truncate the target table and load the data .
As per my understanding, we can’t run a DDL command in singlestore stored procedure linked to a pipeline, we can write a delete query inside the query. But a delete would be inefficient, since it wouldn’t be deleted at that time itself.(will be cleared when garbage collection runs)