title: SQL compilation error: syntax error line 5 at position 157 unexpected '<EOF>'
body: <p>what could possibly be wrong here??</p>
  <pre><code>create or replace temp table Whse_Role_Spend as
  with 
  Warehouse_Spend as (select sum(total_elapsed_time) Total_Elapsed, warehouse_name from 
  &quot;SNOWFLAKE&quot;.&quot;ACCOUNT_USAGE&quot;.&quot;QUERY_HISTORY&quot; group by warehouse_name),
  Role_Spend as (select sum(total_elapsed_time) Total_Elapsed, warehouse_name, role_name from 
  &quot;SNOWFLAKE&quot;.&quot;ACCOUNT_USAGE&quot;.&quot;QUERY_HISTORY&quot; group by warehouse_name, role_name),
  Credits_Used as (select sum(Credits_used) Credits_Used, warehouse_name from 
  &quot;SNOWFLAKE&quot;.&quot;ACCOUNT_USAGE&quot;.&quot;WAREHOUSE_METERING_HISTORY&quot; group by warehouse_name)
  </code></pre>