Need help with connection to Google Big Query

Question

I am struggling to connect with Google Big Query. I am using Google BigQuery Simba to connect . The test of the DSN is okay and I am able to authorize in google.Yet when I get back to the tool I get an error. I checked the roles of the credentials in Google Cloud and they are sufficient to query data.

I have no problems connecting from Jupyter Notebook but with Alteryx nothing seem to work.

Please find enclosed the screenshots.

ODBC test.png

GoogleAuthorise.png

Error.png

Setup.png

apathetichell · Answer

Hey  - sorry I might not have been clear - you need to turn on logs for your driver in odbc 64 - you capture the odbc logs - not the Alteryx

logs. your odbc logs should be more verbose and explain what kind of error you are receiving and why. Your Alteryx logs will be useless here.

Augusta19 · Answer

Logging seems to be not helpful as logs are created every time a workflow runs as it is described here https://help.alteryx.com/current/en/designer/get-started/user-settings/output-log-file.html#output-log-file  When logging is enabled, the content of the log file resembles the contents of the Results window each time a workflow is run, including all runs from the GUI, command line, or API.

I have tested it but during the connection logs are not created. If I try to run a workflow without a connection I can see an error which isn't informative:

00:00:00.029 - Error - ToolId 1: Set up a Connection to use the Tool
Finished in 00:00:00.077 with 1 error

apathetichell · Answer

If you downgrade your odbc driver as noted and capture logs in your odbc driver - yes. open a support ticket there. try to troubleshoot the log errors first.