Deleteing intermediary Dataset values after final OutputDataset
Hi I Am new to Domo we have a lot of very large etls that are broken down in stages.
after each stage an intermediary dataset it created to the pont we have billions of rows in datasets that are only used as staging tables.
my question is these tables take up space.
once the final table is created, how can we delete all the rows from the input and intermediary tables.
we would still maintain the structure of the tables with column names but with 0 rows or data size.
i have tried creating a query via MYSql to delete from the etl and the source tables but it does not work
it seems very inefficiant to keep these tables that occupy space .