Connecting to BigQuery Using JSON private keys

I see from this thread it’s possibel to connect to BigQuery with a JSON private key using the DB connector. Do you have any examples of the manual configuration needed to do that? I’m new to BigQuery.

Hello @San_Diego_Web_Analyst,

For general instructions on setting up big query driver, you can follow this link: KNIME Database Extension Guide

For configuring use of a JSON key, you can open up the configuration dialog and change from ‘Interactive’ → ‘API key’ and select JSON:

Here is a sample workflow that shows how to connect (you can use ‘Google Authenticator’ alternatively to the one used in the provided workflow):

Hope this helps,

1 Like