I’m writing in SQL and I want to copy some data into a new table. I want 3 variables from existingtable to go into a new table called newtable. I am running the following query:

SELECT var1, var2, v3
INTO `myproject.mydataset.newtable` 
FROM `myproject.mydataset.existingtable`;

I get the error message:

Syntax error: Expected end of input but got keyword INTO at [2:1]

My code seems identically structured to some tutorial articles such as the one here. What am I doing wrong? I’m sorry I know there are a lot of similar posts with this basic error message but I have followed the advice from many different articles and haven’t been able to solve it as the error message is so vague.