Alteryx Fails to Read data from the objects coming from redshift data sharing.

Question

Hello Everyone,

Need your help and suggestion on the use case i am working with.

I am able to read data from the redshift regular tables and views using input action and IN DB actions in Alteryx

but not able to read data from the objects (views/tables) thats coming from the redshift datasharing.

For pre-req info on redshift datasharing -> https://aws.amazon.com/blogs/big-data/sharing-amazon-redshift-data-securely-across-amazon-redshift-clusters-for-workload-isolation/

I see this error when connecting and reading data from the datashared objects->

Error: This session is Read Only, cannot read data, same as below

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/DE34272-TSIM-915-Receive-quot-ERROR-The-session-is-read-only/ta-p/795334

Tried to apply the pre-sql ..... SET ReadOnly = 0  (same error This session is Read Only, )

Thanks  for your help and support

Regards

Prashant

masterarun · Answer

Hi, Is there a solution for this?

prashant_killada1486 · Answer

Hi All,

Any suggestions on the above scenario on how to fix it?