Alteryx RLS - Analytical app

[Ariharan]

Hi Team,

We have different service accounts for each country in our Alteryx current setup, which we have configured in the credentials page. Whenever a workflow is published to the gallery, the user will select the credentials for the relevant country, and the workflow will run based on those credentials. The issue we are facing is that we want to use RLS concepts for our workflows, but when we tried to use the GetEnvironmentVariable('User') in the Formula Tool in the local designer, it gave the correct user name, however, when it was run on the server, it gave the service account details rather than the specific user account.

We need to know who is running the workflow from our Gallery Analytics App. The further processing the data to be retrieved from the input will depend on this user who executing the workflow. Is there any way to get the user information from the Gallery in real-time when the workflow is being executed?

We have already looked at an article (https://community.alteryx.com/t5/Alteryx-Server-Discussions/Gallery-authentication-pass-thru-to-work...), but it was not helpful as we don't want to make our MongoDB information available to our users. Could you please provide a working solution for Row Level Security in the Analytics App?

Regards,
Ariharan Rengasamy