Maybe you materialized the table and later substitute it with temporary table ( just guess).

There were some changes recently that you have only tables and materialized views only in DLT and they let use legacy syntax , so there is chance e.g. that something run on certain version of DLT pipeline and is not working on new version ( and you don't have control over version) .

Again that is just guess, as I did not saw your code and piepliens before and after changes and artifacts created by DLT.

When you Merge code and pipelines  there is always chance something goes wrong , especially in DLT as you don't have control over objects like in classic approach 😕

I could not replicated your issue with code that you provided.