title: BigQuery: Insert into temporary table
body: <p>What is the closest approximation in BigQuery to this MS-SQL (T-SQL) syntax? I am running the browser version of Google's BigQuery.</p>
  <pre><code>select * 
  into #myNewTempTable
  from myTable
  </code></pre>
  <p>In MS-SQL this will create a temporary table without having to specify the table structure. (I don't particularly care about how long the table persists.) Thank you!</p>
  <p><strong>Hint</strong>: This will create a table without having to specify the table structure, but it's not a temporary table.</p>
  <pre><code>create table `datascience-291801.temp.premier_cohort_heart` as
  </code></pre>