Create an Oracle Analytics Connection to Google BigQuery

You can create a system connection to a Google BigQuery database and use the connection to model the Google BigQuery project.

Before you start, download the Service Account Private Key (in JSON format) for your Google BigQuery service.

1. On the Oracle Analytics home page, click Create, and then click Connection.
2. Click BigQuery.
3. Enter the connection details.
   • In Connection Name, specify a user-friendly name to identify the connection details in Oracle Analytics.
   • In Project, specify the BigQuery project name in lowercase of the project that you want to analyze.
   • In Service Account Private Key, click Select and upload the Service Account Private Key (JSON format) for your BigQuery service. The Service Account Email is populated from the uploaded key details.
   • In System connection, select this option.
     
     
     Description of the illustration googlebq1.png
     
     
4. Save the details.