Connect to Google BigQuery

You can create a connection to a Google BigQuery database and use the connection to visualize data in a BigQuery project.

Before you start, note the following:

• Creating a connection to Google BigQuery is resource-intensive. It's best to create one connection and share it with other users, rather than having multiple users create their own connection.
• Oracle Analytics builds a cache of tables and schemas for each project in Google BigQuery. You should limit the projects, tables, and schemas to only those required for the analysis.
• Depending on the amount of Google BigQuery data, creating a connection can take up to several hours, so allow time for this process to complete.
• After the connection is created, allow time before you use the connection to start analyzing your data.

1. In Google BigQuery, create a Service Account.
   1. Add a role (for example, BigQuery User) with the permission bigquery.jobs.create to the Service Account.
   2. Add Users to the role.
   3. Add a JSON key.
2. On the Oracle Analytics Home page, click Create, and then click Connection.
3. Click BigQuery.
4. 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 you want to analyze using the name exactly as defined in Google BigQuery (case-sensitive).
   • In Service Account Email, specify the email address used to log into Google BigQuery.
   • In Service Account Private Key, upload the Service Account Private Key (JSON format).
5. Save the details.

   You can now create analytics dataset workbooks based on your Google BigQuery data. When you create a dataset, you navigate to BigQuery tables and select the data facts and measures to analyze. Alternatively, you can use a SQL Query to get the data directly.