title: What is the equivalent of Select into in Google bigquery
body: <p>I am trying to write a SQL Command to insert some data from one table to a new table without any insert statement in bigquery but I cannot find a way to do it. (something similar to select into)</p>
  <p>Here is the table:</p>
  <pre><code>create table database1.table1 
  (
      pdesc string,
      num int64
  ); 
  </code></pre>
  <p>And here is the insert statement. I also tried the select into but it is not supported in bigquery.</p>
  <pre><code>insert into database1.table1
      select column1, count(column2) as num
      from database1.table2
      group by column1;
  </code></pre>
  <p>Above is a possible way to insert. but I am looking for a way that I do not need to use any select statement. I am looking for something similar to 'select into' statement.</p>
  <p>I am thinking of declaring variables and then somehow feed the data into the tables but do not know how.</p>