Desktop Automation with BigQuery ODBC

Alteryx Version: 2024.1.1.93 Patch: 3

Simba BQ ODBC Version: 3.0.5.1011

I am able to setup a DCM connection and successfully run queries manually, but when I schedule them, they hang indefinitely. The ODBC driver is DSN and in the connection manager i'm able to connect to BigQuery using google credentials.

Previously I setup System DSN ODBC with no issues in automation. Do i have to go back to previous version?

Database Connection

Scheduler

Accepted answers

apathetichell

Then let's blame it on the python.

All comments

apathetichell

when you say "google credentials" do you mean oauth? how long is your token for? if your token expires no automation (alteryx or otherwise) can occur. If you mean JWT - could be lack of Python connectivity in desktop automation/scheduler.

anthony_fiel

Screenshot 2024-08-13 092653.jpg

Yes, OAuth. It opens a window and has me select my email.

anthony_fiel

I'm also testing it immediately, so it should still be signed in.

apathetichell

Yeah - so that can't really wortk with desktop automation because it's user specific and expires fairly fast - and clearly my question on what "Google Credentials" means should be directed to whoever built the DCM interface verbiage. Desktop Automation should be system specific vs user specific.

anthony_fiel

downgraded Alteryx to 2023.2. created an ODBC connection to the system DSN (simba), and everything is working again.

apathetichell

Then let's blame it on the python.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335