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.
- A connection to Goole BigQuery is defined explicitly to a single project. If you require data from multiple projects, then the connection must be created by a service user that has access to the projects and datasets. Dataset outputs can be blended.