Tuncate a table in Azure SQL database through azure machine learning experiment

Question

I'm using Azure machine learning studio to create some predictions, at the end of pipeline I need to truncate previous data in a Azure sql table and then write the new prediction, this is going to happen on a daily basis. How I could truncate a table from an experiment, it seems that there were a solution with reader component in Azure ML classic, but it is not working from current ML studio?

Answer 1

In the reader write the truncate table and table name and it will execute.

Truncate table table_name;