# \[KShare\] How to connect to BigQuery from Katalon Studio?

**URL:** <https://forum.katalon.com/t/kshare-how-to-connect-to-bigquery-from-katalon-studio/129502>\
**Category:** Kshare\
**Tags:** quan-trinh, gatedknowledge, support, web-testing, katalon-studio\
**Created:** [April 26, 2024, 4:29am UTC](https://forum.katalon.com/t/kshare-how-to-connect-to-bigquery-from-katalon-studio/129502 "2024-04-26T04:29:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![support.squad](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/support.squad/32/23139_2.png) [@support.squad](https://forum.katalon.com/u/support.squad)\
**Post date:** [April 26, 2024, 4:29am UTC](https://forum.katalon.com/t/kshare-how-to-connect-to-bigquery-from-katalon-studio/129502/1 "2024-04-26T04:29:00Z")

</div>

Hi Community members, 👋

We believe you might be sticking to Data-Driven testing with a database. Especially, this article will guide you on how to connect to BigQuery - a service offered by Google Cloud Platform that functions as a data warehouse that Katalon have not had any official documents to drive you into this connection.

 ![image](https://europe1.discourse-cdn.com/katalon/original/3X/d/7/d75f5c3850cb80c6b19623452bf47238ff9d2660.jpeg)

To establish the connection between Katalon Studio and your Big Query database, please do as follows:

**Step 1** : Importing all the [Google BigQuery JDBC classes](https://drive.google.com/drive/folders/1TtlOXtAD_hdAoO9fYdgBqjiKOLD3S9Ht?usp=sharing), but we will also need to **exclude** a conflicting class built in to Katalon Studio:

 ![image](https://europe1.discourse-cdn.com/katalon/original/3X/9/8/98d623cb7d8b67824ab20bdac6d807a393fe9f8d.jpeg)

**Step 2:** Configure your database, click “Secure User and Password” because we will set those values below the properties section.

**Step 3:** For JDBC driver, please user: `com.simba.googlebigquery.jdbc42.Driver`

**Step 4:** For the connection URL, please use: `jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443`

**Step 5:** Set the following connection properties as shown below:

- `ProjectId` : means your project ID on BigQuery
- `OAuthType` : should be `0`
- `OAuthServiceAcctEmail` : means the client email.
- `OAuthPvtKeyPath` : means the path of your json file which contains all of your credential access to Big Query
- `EnableSession` : should be `1`

**Step 6:** Click **Test Connection** to verify whether your database is connected successfully.

 ![image](https://europe1.discourse-cdn.com/katalon/original/3X/7/f/7fcc663f62c958fa01fff59eb91c9b78f183604e.jpeg)

**Step 7:** Click **Apply and Close** to save your setting and start working on your data-driven testing.

* * *

If you find this article helpful, then don’t forget to leave us a like 👍 or a heart ❤ and share it to your teammates and colleagues!

> ℹ For more [KShare](https://forum.katalon.com/c/product-insights/73) articles, simply navigate to our #support tag.

---

<div class="post-metadata">

**Author:** ![albert.vu](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/albert.vu/32/20595_2.png) [@albert.vu](https://forum.katalon.com/u/albert.vu)\
**Post date:** [April 26, 2024, 4:30am UTC](https://forum.katalon.com/t/kshare-how-to-connect-to-bigquery-from-katalon-studio/129502/2 "2024-04-26T04:30:36Z")

</div>

Thank you the Product Support team (@support.squad) and Chris Trinh (@quan.trinh) for yet another insightful article on WebUI testing.

| ![Chris](https://europe1.discourse-cdn.com/katalon/original/3X/2/0/20db0a52955d980dbc669b633f754fcc39601dd5.png) |
| --- |
| **Quan Trinh - Chris** (@quan.trinh) - Product Support Specialist |
| Quan (Chris) is a Product Support Specialist who has offered informative and insightful advice to Katalon users worldwide for years. He is devoted to sustaining your testing journey with Katalon. No limits!!! |

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/katalon/original/3X/d/5/d55596ab02785a255798e87ede769734747b30c4.svg) [@system](https://forum.katalon.com/u/system)\
**Post date:** [April 26, 2025, 4:29am UTC](https://forum.katalon.com/t/kshare-how-to-connect-to-bigquery-from-katalon-studio/129502/3 "2025-04-26T04:29:38Z")

</div>

Closed on April 26, 2025, 4:29am UTC

This topic was automatically closed after 364 days. New replies are no longer allowed.