Issue with Google Big Query Input and Output using a service account file

Question

Hello folks,

I'm running into an issue when trying to leverage the service account authentication mode within the google big query component.

Whenever I open a workflow that has been saved by another user, I consistently encounter the following error message (see screenshots attached).

We have attempted to utilize a shared folder and have also tried using the exact same file path on our respective machines, but the issue persists.

Has anyone else experienced a similar problem, and if so, how did you manage to collaborate effectively on the workflow?

Thanks

Emilien

alteryxIssue2.png

alteryxIssue.png

apathetichell · Answer

You can connect IN-DB with the SIMBA driver - but I guess my first question would be - why are you sharing a workflow with a .json connection versus an oauth individual connection?

Also on an IN-DB workflow - metadata tends to need to be refreshed - that requires running to setup. I would expect your workflow would require being run when ported to a new system to reset the connection.

caltang · Answer

In addition, I believe the GBQ Input and Output tool for Alteryx has been deprecated. You can use the normal Input and Output tools but connect to a data source instead of a file.

caltang · Answer

You need the JSON Service Account file. Where did you store it?

In addition, do you have the SIMBA ODBC for GBQ in your ODBC Data sources?