create temp table


I am trying to create a temp table to build a query but I have this message :

cannot execute CREATE TABLE AS in a read-only transaction

I am not sure about the problem, is it a setting problem ? What do I need to check ?


2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • I've just noticed that the error message is CREATE TABLE AS but the query is 

    "create temp table my_temp_table AS" (not create my_temp_table) Thanks

  • Hi Patrick LAMOTTE ,


    Thanks for reaching out! So this is not a Mode error- this error is being returned by your native database. This is most likely a permissions issue, as it looks like the credentials for your database have read-only permissions while creating temp tables typically requires create permissions. However, I would reach out to your database administrator to double check. Let me know if you have any further questions at all, thanks!

Like Follow
  • 1 yr agoLast active
  • 2Replies
  • 444Views
  • 2 Following