08-02-2021 07:44 AM - edited 06-10-2022 02:13 PM
Input Data (2) Executing PostSQL: "drop table "public".nt_sales4;" : [Simba][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 59001] ERROR: The session is read-only
Receive Error when attempting to run "drop table" command with IN-DB tool
Hi ntobon,
Has this been resolved? I'm able to run my flow with an INSERT in the post-SQL statement on my local machine, but can't run the same flow on a remote machine.
My local machine is running v1.2.6.1006 (64 bit)
My remote machine is running v1.4.16.1000 (64 bit)
How do I resolve this?
Many thanks
Scott
@ScotiaTheOne The defect is still open, but we have identified a workaround. Please try workaround #2.
Doesn't work in a Post-SQL statement though does it? thanks
@ScotiaTheOne workaround #2 should also work for Post-SQL statement
Got thsi working, thanks @ntobon
Works now in Post-SQL with the SET ReadOnly = 0; at the start of the query