I am streaming data into BQ, every day I run a scheduled job in Dataprep that takes 24 hours of data and modifies some data and creates a new table in the BQ dataset with 24 hours of data.

The original table though stays unmodified and keeps on gathering data.

What I would like to do is delete all rows in the table after the dataprep makes a copy so that a new 24 hours of data streaming is gathered

How can I make this automated, I can't seem to find anything in dataprep that drops the original table and creating a new table.