I am trying to create a temporary table from an RStudio chunk.
-- save baseline table at participant grain CREATE LOCAL TEMPORARY TABLE my_temp ON COMMIT PRESERVE ROWS AS /*+direct*/ SELECT treatment_name, id, assign_date, FROM my_table;
The query works within RStudio if I don't try to create a temp table, but the temp table creation triggers the following error
Error in .verify.JDBC.result(r, "Unable to retrieve JDBC result set for ", :
Unable to retrieve JDBC result set for
...restates my query...
Failed to execute SQL chunk
I can use this exact code to create a temp table from Alation, but I'm trying to automate report creation in RStudio so I'd prefer all the queries to initiate in RStudio.