Need help with connection to Google Big Query

[Augusta19]

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.

[apathetichell]

How are you signing in with your ODBC 64 connection? assuming you are using the same method in Alteryx - and have it configured correctly to use/not use DCM as applicable -> turn on logging in your ODBC 64 driver settings. capture your logs -> troubleshoot if it's a GCP issue (my hunch is no) -> open a ticket with Alteryx if it's an Alteryx issue. Supply logs with any redacted information.

[apathetichell]

Worth noting -> Alteryx specifically notes it tested on ODBC driver 2.4.6 -> you can try with that version. https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers still has it up. (https://storage.googleapis.com/simba-bq-release/odbc/SimbaODBCDriverforGoogleBigQuery64_2.4.6.1015.m...)

[Augusta19]

Thank you so much for your help! Do you mean support ticket through my.alteryx?

[apathetichell]

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.

[Augusta19]

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-l...  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]

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.