title: Is there a way to make a temp table in Snowflake via SQL without having to write the columns in everytime? WITH, INSERT INTO
body: <pre><code>insert into temp
  select  code, 
  case when code = 'S' then 1
  when code = 'U' then 0
  when code = 'R' then 4 
  end 
  from "table" r
  </code></pre>
  
  <p>temp table error-how do you make a temp table in snowflake without having to note each column</p>