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

[prashant_killada1486]

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-c...

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...

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

Thanks  for your help and support

Regards

Prashant

[prashant_killada1486]

Hi All,

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

[masterarun]

Hi, Is there a solution for this?