ODBC Connections - Google BigQuery

[jj1755]

Hello,

Several years ago I setup a connection to Google BigQuery via Input tool. My company is now rotating JSON access keys and as a result, I am at risk of losing access unless I implement the new key.

I can use your help in confirming my current settings as I am not sure if I am accessing data via JSON or Google Login.

Is anyone here able to guide me in recreating this connection or to the correct knowledge base documentation? I have tried multiple times via Connections Manager and creating test User DSNs in ODBC Data Source Administrator but have hit roadblocks.

I've attached a screenshot of my current Input settings.

[Warcry]

Try: DSN=BigQuery

[jj1755]

Thank you! I tried that but I receive the Validation Error - Can't use workflow-based passwords in current DCM mode, use a DCM Connection instead.

Ultimately, I am trying to re-create this input with the same settings. I have been attempting this using Generic ODBC or Google BigQuery ODBC as the connection but am not able to replicate.

I've attached my workflow with the original input and new input.

Original

New

[apathetichell]

What version of Alteryx are you using? Are you using Server (ie are you connecting via DCM on Server)? Assuming no -> you'll need to toggle off DCM. I'm purely BQ technical and Alteryx functional here - ie I've never had to do this. I can tell you how it 'should' work -> but I've generally found that Alteryx and BQ specifically are not the best fit. In theory you should be using your .json file as service account credentials to open a BQ Client/ODBC connection - > and then you should be able to connect as your currently do. I do not know the specific way that Alteryx requires you to implement it and they throw around Oauth way too much in their description. I can't tell if they mean it's only supporting client/Oauth 2.0 with user credentials or they are supporting a .json file with Oauth/service account keys. It could be either.

In a worst case scenario -> I'd recommend seeing if you can port over your logic to Python -and open the BQ client there.

Sorry I don't have more information and your .yxmd is basically useless here since so much of this is based on settings logic vs workflow logic.

[jj1755]

I'm running Designer version 2024.2.1.14. I've never had issues connecting to BigQuery. Ultimately, I would like to recreate the instance where I am connecting via ODBC but cannot seem to recreate that setting regardless of selecting the data source as Google BigQuery ODBC, or Generic Connection ODBC. I think I will have to run with the current settings and hope for the best.

Thank you so much for attempting to help!