Hello 

I dropped all existing objects, deleted old DLT pipeline and creating a new one with same name but same problem is seen. 

Not sure why it complains about Temporary tables those would be created at runtime , even i tried to remove temporay flag but same problems.  Not sure what's wrong here, i am running out of options here.