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,
TL
1 Like