In this tutorial, we will walk through how to connect to Google BigQuery from our favorite SQL/BI/ETL tools using different authentications supported by Progress DataDirect Google BigQuery JDBC Connector. There are two types of Authentication covered in this document:
Let’s look at how we can authenticate ourselves using these two authentication schemes when using Progress DataDirect Google BigQuery JDBC Connector.
Project - Your Project ID, this can be found in your Google Console
DataSet - The Dataset name you want to connect to
ServiceAccountEmail – Service Account ID you created above. You should find it in IAM->Service Accounts as shown below
ServiceAccountPrivateKey – Path to JSON or .p12 file you saved earlier.
We hope this tutorial helped to get started with the Progress DataDirect Google BigQuery JDBC Connector and explained how to work with different authentications. Please feel free to contact us with any questions and we will be happy to help.