Delete delta live table without deleting DLT pipeline
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 03:19 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-05-2024 09:23 AM - edited 10-05-2024 09:24 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2024 01:11 AM
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
![](/skins/images/582998B45490C7019731A5B3A872C751/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/582998B45490C7019731A5B3A872C751/responsive_peak/images/icon_anonymous_message.png)