In this tutorial, we will walk through how to connect to Google BigQuery from SQL/BI/ETL tools using Progress DataDirect's JDBC Connector for Google BigQuery .
Name: <Any name>
Class Name: com.ddtek.jdbc.googlebigquery.GoogleBigQueryDriver
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 explained connecting to Google BigQuery and querying data using Progress DataDirect's JDBC Connector for Google BigQuery. Feel free to contact us with any questions.