- All Alteryx version
- Amazon Redshift
- Amazon Redshift Drivers
- Simba Amazon Redshift 1.04.21.1000
- Amazon Redshift version 220.127.116.110
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
The issue occurs when using Driver Simba Amazon Redshift 1.04.21.1000 or Driver Amazon Redshift version 18.104.22.1680.
The issue is not observed when using old driver Amazon Redshift 1.04.13.1000.
Defect: DE34272 / TSIM-915
Status: Fixed in version 2021.1. Workarounds
driver Amazon Redshift 1.04.13.1000Workaround #2:
You can manually turn Read Only off in a pre-sql statement by doing this:
SET ReadOnly = 0;image.pngAdditional Resources
Receive Error when attempting to run "drop table" command with IN-DB tool