title: CREATE TABLE on BigQuery?
body: <p>How do I create a table on BigQuery from another existing table?</p>
  
  <p>For example, I have a table:</p>
  
  <pre><code>col_1, col_2, val
  ...  , ...  , ...
  </code></pre>
  
  <p>And I want to create a new table as:</p>
  
  <pre><code>CREATE TABLE new_table AS (
  SELECT col_1, SUM(val) AS sum_val FROM old_table) WITH DATA;
  </code></pre>
  
  <p>However, I cannot first query the result and then save the result because the result is too large.</p>