# Google Cloud Platform: BigQuery **URL:** \ **Category:** Ignition\ **Created:** [August 19, 2019, 4:54pm UTC](https://forum.inductiveautomation.com/t/google-cloud-platform-bigquery/27576 "2019-08-19T16:54:14Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![WillMT10](https://avatars.discourse-cdn.com/v4/letter/w/7feea3/32.png) [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Post date:** [August 19, 2019, 4:54pm UTC](https://forum.inductiveautomation.com/t/google-cloud-platform-bigquery/27576/1 "2019-08-19T16:54:14Z")
Our company is looking at possibly integrating Google’s BigQuery database into our processes. We already use their Firestore/Firebase offering (which was painful to integrate due to the access token security) and we have a number of MySQL cloud databases. Just wondering if anyone here has tried integrating BigQuery with Ignition? They do have a JDBC driver but I’ve read that it has some differences that could be problematic. I’ll be digging into it and doing some testing but was hoping others may have already tried. ---
**Author:** ![kmcmorrow](https://avatars.discourse-cdn.com/v4/letter/k/d2c977/32.png) [@kmcmorrow](https://forum.inductiveautomation.com/u/kmcmorrow)\ **Post date:** [March 24, 2021, 2:46pm UTC](https://forum.inductiveautomation.com/t/google-cloud-platform-bigquery/27576/2 "2021-03-24T14:46:27Z")
I have this type of system design as well, but the Cloud Function meant to detect the pub/sub message is not handling the Schema of the JSON payload well… I am requesting a walk through like the one they have fore AZURE to explain in more detail the setup needed for the table entries so they map correctly. ---
**Author:** ![WillMT10](https://avatars.discourse-cdn.com/v4/letter/w/7feea3/32.png) [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Post date:** [March 24, 2021, 4:00pm UTC](https://forum.inductiveautomation.com/t/google-cloud-platform-bigquery/27576/3 "2021-03-24T16:00:31Z")
I wish I had some additional insight to offer but we ended up using Elastic instead of BigQuery and it was fairly straight forward to get data into Ignition via Elastic’s REST API. If you end up with any additional learnings, please post back here as I would be very interested! btw - welcome to the community! ---
**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Post date:** [May 27, 2025, 8:45pm UTC](https://forum.inductiveautomation.com/t/google-cloud-platform-bigquery/27576/4 "2025-05-27T20:45:27Z")
Did you get Big Query working? I didn't see any connectors? ---
**Author:** ![calimero100582](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/calimero100582/32/18630_2.png) [@calimero100582](https://forum.inductiveautomation.com/u/calimero100582)\ **Post date:** [June 3, 2025, 3:49pm UTC](https://forum.inductiveautomation.com/t/google-cloud-platform-bigquery/27576/5 "2025-06-03T15:49:21Z")
We have it working. Download JDBC driver from google: [ODBC and JDBC drivers for BigQuery  |  Google Cloud](https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers#current_jdbc_driver) To avoid adding every individual file in the next step, from the downloaded file, copy all JAR file to %Ignition%/user-lib/jdbc In Database -\> Drivers, add a new driver ![BigQuery.database.drivers](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/3/23753c6f773c9102a8adcbf63a05c68181dcd239.png) You can then create a new connection using this driver using a connection string like: jdbc:bigquery://[https://www.googleapis.com/bigquery/v2:443;ProjectId=your-project-name;OAuthType=0;OAuthServiceAcctEmail=service-account-name@project-full-name.something.com;OAuthPvtKeyPath=/full/path/connection-credential-from-google.json](https://www.googleapis.com/bigquery/v2:443;ProjectId=your-project-name;OAuthType=0;OAuthServiceAcctEmail=service-account-name@project-full-name.something.com;OAuthPvtKeyPath=/full/path/connection-credential-from-google.json); No need to specify username or password. For further information, in the link above, in JDBC, Installation and configuration guide, look at the section "Using a Google Service Account" ---
**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Post date:** [June 4, 2025, 1:51pm UTC](https://forum.inductiveautomation.com/t/google-cloud-platform-bigquery/27576/6 "2025-06-04T13:51:58Z")
Thanks!