title: SELECT INTO syntax for Snowflake Datawarehouse
body: <p>I believe there's an <code>SELECT INTO</code>-like syntax in Snowflake, but I am unable to find documentation or examples to use it.</p>
  
  <pre><code>CREATE TABLE raw_data (
      Timestamp TIMESTAMP NOT NULL, 
      Date DATE NOT NULL, 
      UserID STRING,
      Address STRING,
      Phone STRING,
      Value INTEGER
  );
  
  COPY INTO raw_data from 's3://my_bucket'
  CREDENTIALS=(AWS_KEY_ID='XXXXX' AWS_SECRET_KEY='XXXX')
  ON_ERROR=CONTINUE;
  
  CREATE TABLE summary (
      Date DATE NOT NULL,
      UserID STRING,
      Value INTEGER
  );
  
  INSERT INTO summary 
  SELECT Date, UserID, Value FROM raw_data
  </code></pre>
  
  <p>The above works, but rather than defining the table <code>summary</code> I want to <code>SELECT INTO</code> and have the SQL parser create the table for me.</p>