Skip to main content
brendanm0004
New Participant
Sep 9, 2021 3:07 PM UTC
Question

Custom Data Source (JDBC) For Google BigQuery

We are looking to connect to customers Data Warehouse (Google BigQuery) by configuring a Custom Data Source (JDBC).  Curious if any others have implemented this successfully?   

4 replies

rodrigoe0001
rodrigoe0001
Known Participant
Oct 6, 2021 5:12 PM UTC

Hi there, 

I'm kind of on the same path, I am currently working on connecting Big Query to my app, I was able to make a connection using the API, the response returns all rows, but then the displayed data does not contain the rows. 

Were you able to make this work with Custom data source?

I think I'm close to get the information from BIgQuery but probably I need to figure out how to display the rows given on the JSON response 

brendanm0004Author
New Participant
Oct 30, 2021 5:09 AM UTC

Hi, we are going JDBC approach (not API) hence will need to create a Custom Connected System which wont be using JSON.  I'll let you know if anything comes up which may be relevant for your implementation (ie. API)

    rodrigoe0001
    rodrigoe0001
    Known Participant
    Nov 2, 2021 2:19 PM UTC

    Thanks! I was able to make it work actually, if you need help let me know but I did it with API. Does the JDBC allow you to update, delete and get data from bigQuery?

    Terms & ConditionsAccessibility statement