How to setup Google Big Query as an external system for pushing data into BigQuery table
edited September 2020 in General discussion
Did anybody try using the Google Big Query 6.0 JDBC and know how to configure the credential details for Aperture data studio to connect to the bigquery table?
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.
Thanks for reaching out. Data Studio's Google Big Query 6.0 JDBC driver does not support Google user account (OAuthType = 1) authentication. To connect you will require both the Access Token as well as the Refresh Token. You can retrieve this via OAuth 2.0 Playground. For more instructions on generating the Access Token and Refresh Token, please refer here.
The setup steps are as below:
Hope this helps. Do let me know if you're able to set this up successfuly or if you have further questions. Thanks.
Thanks for your insightful information. But I can not get pass the OAuth 2.0 Playground. step 3 "Configure request to API". As the environment of our Aperture data Studio is isolated internally inside an AWS VPC, so can not get the request URI working in the Google developer console.
So need to make the aws vpc allow to connect to google first.
Update on this: The Google BigQuery connector in Data Studio now supports authentication using:
Both auth types are described in the Google BigQuery driver user documentation.