topic Re: Delete delta live table without deleting DLT pipeline in Data Engineering

Delete delta live table without deleting DLT pipeline

AngadSingh — Fri, 04 Oct 2024 10:19:21 GMT

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

Re: Delete delta live table without deleting DLT pipeline

filipniziol — Sat, 05 Oct 2024 16:24:30 GMT

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.

Re: Delete delta live table without deleting DLT pipeline

AngadSingh — Wed, 23 Oct 2024 08:11:43 GMT

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