AmanSehgal
Honored Contributor III

In Databricks Delta Live Tables (DLT), you can't directly truncate a streaming table, as streaming tables are append-only by design. 

However in your scenario, you could possibly use a job workflow, where the first task runs a sql statement (using serverless sql) to truncate the table and the following job runs your DLT pipeline.