Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

DE34272: Receive "ERROR: The session is read-only" using pre/post SQL option in the Input Data tool when attempting to perform any operation that is not a select statement

ntobon
Alteryx
Alteryx
Created

Alteryx Designer
  • All Alteryx version
  • Amazon Redshift
  • Amazon Redshift Drivers
    • Simba Amazon Redshift 1.04.21.1000
    • Amazon Redshift version 1.4.34.1000

When attempting to run any command that is not a select statement, such as dropping/creating tables with regular Input Tool using pre/post SQL option you receive the following error message:
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

image.png
The issue occurs when using Driver Simba Amazon Redshift 1.04.21.1000 or Driver Amazon Redshift version 1.4.34.1000.
The issue is not observed when using old driver Amazon Redshift 1.04.13.1000.

Defect: DE34272
Status: Open.

Defect DE34272 is target for resolution in future release.

Workaround
Use driver Amazon Redshift 1.04.13.1000

Additional Resources

Receive Error when attempting to run "drop table" command with IN-DB tool



null
No ratings
Comments
ScotiaTheOne
5 - Atom

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