How to switch credentials per user without duplicating workflows

[bryanmac_92]

Hello!

I’m trying to figure out a way to switch Google Cloud Storage (GCS) credentials per user without duplicating the same workflow for each person.

The data being accessed from GCS is the same, but each user has their own credentials (i.e. google sig-in/email). Since we don’t have access to Alteryx Server, I’m looking for a solution within Alteryx Designer only.

Ideally, I’d like to set this up so each user can run the same workflow but authenticate with their own credentials — maybe by using a macro to dynamically load their credentials, but I’m not sure how to go about it.

[davidskaife]

Hi @bryanmac_92 

Could you not have a generic 'Alteryx' login to GCS that the workflow uses?

Another option would be to turn it into an Analytical App, which the user inputs their credentials at run time, which is then used to access GCS

[Deano478]

@bryanmac_92 you could also get a service account setup for this which would be useful for future proofing