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 ?
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!Reply