All excellent points. The best is when most workloads on the cluster use a temp table with an identical name. Then someone comes along and accidentally drops the TEMP from the their temp table ctas and it gets smashed into the public schema.
“Table already exists…”scheduled job run failure galore, fun times.
“Table already exists…”scheduled job run failure galore, fun times.