Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

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

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

 

2 REPLIES 2

Hi All,

 

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

masterarun
5 - Atom

Hi, Is there a solution for this?