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

prashant_killada1486 — Mon, 14 Feb 2022 11:29:45 GMT

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.

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

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

Thanks for your help and support

Regards

Prashant

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

prashant_killada1486 — Tue, 22 Feb 2022 08:09:52 GMT

Hi All,

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

masterarun — Mon, 19 Feb 2024 09:51:06 GMT

Hi, Is there a solution for this?