Truncate Table in Azure SQL Database for Azure ML Experiment

Question

In my Azure ML experiment I am using a writer to write data into a table in Azure SQL Database. However, I would like to truncate the data in that table before each insert. Is there any way that I can achieve this through the experiment itself? Any inbuilt module through which I can achieve this?

I know from sql using triggers I can achieve this.

Have you tried executing a SQL command to truncate the table? — Panagiotis Kanavos
That worked like a charm. I put the truncate statement in reader module followed by a dummy select statement. Awesome. Thanks — Rajendra Prasad

Rajendra Prasad Rajendra Prasad · Accepted Answer · 2015-12-15T18:18:05

2

votes

truncate table written in reader module did the trick. Thanks Panagiotis

Truncate Table in Azure SQL Database for Azure ML Experiment

1 Answers