'Truncate Table in Azure SQL Database for Azure ML Experiment

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.

tsqlazure-sql-databaseazure-machine-learning-studio


Solution 1:[1]

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Rajendra Prasad

Related Questions

Return a value if no rows are found in Microsoft tSQL

Return a value if no rows are found in Microsoft tSQL

Return a value if no rows are found in Microsoft tSQL

Getting maximum value of float in SQL programmatically

Getting maximum value of float in SQL programmatically

Getting maximum value of float in SQL programmatically

Getting maximum value of float in SQL programmatically

Conversion failed when converting date from character string

How do I create a SQL Function to return a BIT?

CONCAT_WS() for SQL Server

Export database schema into XML file

SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

Using a SELECT statement to return a row where a DateTime column = variable of type Date?

Is it necessary to test for NULL if also testing for greater than?

SSMS 2012: Convert DATETIME to Excel serial number