Confusing error message when table does not exist

[neelasha23]

Reproducing steps:

%%sql
CREATE TABLE temp AS
(SELECT * FROM penguins.csv)

%%sql --save snippet
SELECT * FROM penguins.csv

%%sql
DROP TABLE temp;

Then if we run the below query it says snippet does not exist whereas it's actually the table temp.