Delete delta live table without deleting DLT pipeline

[AngadSingh]

Hi,

I am wondering how do I delete the managed DLT table without deleting the DLT pipeline? I tried commenting the code for the table definition but the DLT pipeline complains that source code has no table to create or update. 

Thanks in advance.

#dataengineering #deltalivetable

[filipniziol]

Hello @AngadSingh ,

The error message you've shared identifies the issue you're encountering. The error message:

Source code has no table to create or update.

occurs because your Delta Live Tables (DLT) pipeline does not have any streaming tables defined after you commented out the table definition. Delta Live Tables require at least one table in the pipeline code to execute. Without any table, the pipeline has nothing to process, leading to the error.

[AngadSingh]

Hi I understand the error which is displayed on in my screenshot. I was trying to delete the table by commenting the code. Hence the error.

However, my question is that is there another way to delete table without commenting code or deleting the pipeline? I  mean hard delete like deleting checkpoint and directories like we can do for delta tables. 

Thanks

Angad