Establish Connectivity to Google BigQuery
This article details how to establish connectivity to Google BigQuery.
PREREQUISITES:
- Server registered with Google. See Integrating Metric Insights with Google Services
- Obtained Client Credentials. See Obtaining Client Application credentials from Google Projects
- The following Google endpoints have to be whitelisted:
- http://www.googleapis.com/
- https://www.googleapis.com/bigquery/v2
- https://oauth2.googleapis.com/token
- https://accounts.google.com/o/oauth2/auth?
- https://www.googleapis.com/auth/cloud-platform
- https://www.googleapis.com/auth/drive
- https://www.googleapis.com/robot/v1/metadata/x509/
- *.pki.goog
- https://www.googleapis.com/oauth2/v4/token
1. Create New Data Source
Access Admin > Collection & Storage > Data Sources
- [+New Data Source]
- Choose "Google BigQuery" from the Other drop-down list
- [Next Step]
2. Specify Required Parameters
- Provide a descriptive phrase in Data Source Name
- Choose Auth Type:
- Service account key: proceed to Configure Optional Parameters section to provide a service account key
- OAuth: requires Client ID and Client Secret for token generation
Note: If Data Source utilizes service account key authorization, only objects from the according service account's parent project can be used.
- Enter Google services Client ID
- Provide Google services Client Secret
-
[Get Token]
- Next, you will be asked to enter Google account information in the dialog that opens
- The following dialog will ask you for permissions to view and manage BiqQuery data
Optionally, toggle on Enable On-Demand Element Creation
3. Configure Optional Parameters
Destination Dataset and Destination Table parameters work only with service account key authorization and need to be specified only for large queries.
Description | |
---|---|
1 | Enter a Destination Dataset for large queries processing |
2 | Enter a Destination Table for large queries processing |
3 | Upload a service account key:
|
4 | Specify if you want to be using Legacy SQL (non-standard variant of SQL used within Google)
|
4. Proceed with Advanced Configuration
Advanced Configuration settings can be set to default values unless Data Source requires more precise tuning. For more details on how to proceed, refer to Advanced Data Source Configuration.
- If Data Sources utilizes service account key authorization, you can use a Proxy
- [Test Connection] in the upper right corner