# Connecting to BigQuery Using JSON private keys

**URL:** <https://forum.knime.com/t/connecting-to-bigquery-using-json-private-keys/78435>\
**Category:** KNIME Extensions\
**Tags:** other-knime-extensions\
**Created:** [April 9, 2024, 8:56pm UTC](https://forum.knime.com/t/connecting-to-bigquery-using-json-private-keys/78435 "2024-04-09T20:56:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![San\_Diego\_Web\_Analyst](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/c6cbf5/32.png) [@San\_Diego\_Web\_Analyst](https://forum.knime.com/u/San_Diego_Web_Analyst)\
**Post date:** [April 9, 2024, 8:56pm UTC](https://forum.knime.com/t/connecting-to-bigquery-using-json-private-keys/78435/1 "2024-04-09T20:56:59Z")

</div>

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.

> [@Obsolete API Key support for Google Authentication (API Key) node](https://forum.knime.com/t/obsolete-api-key-support-for-google-authentication-api-key-node/49032/1):
>
> This node desperately needs to be updated to support JSON key formats. P12 keys have been deprecated by Google, and use of JSON keys is highly recommended: Recommendation: We recommend that you use JSON (.json) private keys to activate service accounts. JSON private keys do not require the special crypto library explained on this page. To create a new JSON private key for a service account, follow the steps in [Authorizing with a service account](https://cloud.google.com/sdk/docs/authorizing#authorizing_with_a_service_account). For steps to activate the service account with …

---

<div class="post-metadata">

**Author:** ![thor\_landstrom](https://forum-cdn.knime.com/user_avatar/forum.knime.com/thor_landstrom/32/65984_2.png) [@thor\_landstrom](https://forum.knime.com/u/thor_landstrom)\
**Post date:** [April 30, 2024, 3:17pm UTC](https://forum.knime.com/t/connecting-to-bigquery-using-json-private-keys/78435/2 "2024-04-30T15:17:32Z")

</div>

Hello @San_Diego_Web_Analyst,

For general instructions on setting up big query driver, you can follow this link: [KNIME Database Extension Guide](https://docs.knime.com/latest/db_extension_guide/index.html#register_jdbc)

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

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/d/8d9ecb201c24fa24e6c4d74ce50d2e0ef25c735f.jpeg)

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

> **[Working with Google cloud services – knime](https://hub.knime.com/knime/spaces/Examples/10_Big_Data/01_Big_Data_Connectors/04_GoogleCloudExample~a22M2L1-7Jbd-QTY/current-state)**
>
> This workflow demonstrates how to connect to various Google Cloud Services such as Google BigQuery, Google Dataproc, and Google Cloud Storage from within KNIME…

Hope this helps,  
TL

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [July 29, 2024, 3:18pm UTC](https://forum.knime.com/t/connecting-to-bigquery-using-json-private-keys/78435/3 "2024-07-29T15:18:31Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.