- Getting Started
- Managing Tenants and Spaces
- Using Development Mode
- Using Datasources
- Connecting Databases
- MySQL
- Postgres
- Amazon RedShift
- Microsoft SQL Server
- BigQuery
- Snowflake
- MongoDB
- ClickHouse
- Hive
- ETable
- Impala
- Oracle
- Teradata
- Google Sheets
- Google Analytics
- Public Dataset
- Using Projects
- Using Datasets and Reports
- Using Visualizations
- Using Dashboards
Connecting a BigQuery Database
CONTENTS
Home
- Overview
- Getting Started
- Managing Tenants and Spaces
- Using Development Mode
- Using Datasources
- Connecting Databases
- MySQL
- Postgres
- Amazon RedShift
- Microsoft SQL Server
- BigQuery
- Snowflake
- MongoDB
- ClickHouse
- Hive
- ETable
- Impala
- Oracle
- Teradata
- Google Sheets
- Google Analytics
- Public Dataset
- Using Projects
- Using Datasets and Reports
- Using Visualizations
- Using Dashboards
Connect to Google BigQuery
Here is what you need to connect:
- Name of the Google Cloud Platform (Project field)
- Google BigQuery Service Account credential file in a JSON file (Credentials field)
- Database connection information
- Credentials
Create a Service Account
bipp requires a service account to connect to Google BigQuery. Here are the instructions to create the account if you do not already have one.
-
Sign-in to Google Cloud Platform and choose your project.
-
Select IAM & admin > Service accounts.
-
Click Create Service Account.
-
Enter the Service account details and click Create.
-
Select the Grant this service account access to project roles. bipp requires at least the BigQuery User and BigQuery Data Viewer roles. Click Continue.
-
No action is needed for Grant users access to this service account. Click Done.
-
After the service account is created, click Actions > Manage Keys.
-
Click Add Key > Create new key. This key is used to authenticate the service account with Google BigQuery.
-
Select JSON as the key type and click Create.
-
The private key is downloaded to your local computer. The key is required when you create a BigQuery Datasource in bipp.
Create a BigQuery Datasource in bipp
-
Select Datasources from the Home Navigation pane to open the Datasources page.
-
Click New Datasource on the Datasources page.
-
Enter a Name. For example, TestBigQuery.
-
Select BigQuery for SQL Dialect for your database. bipp creates and enforces the rules for the selected dialect.
-
Enter the information for your BigQuery database instance:
- Project: Add Project ID mapped to your GCP project. This can be accessed by clicking on the Project name in the top navigation bar of GCP console.
- Credentials: Click Choose file and navigate to the location of your Service Account credentials JSON key file.
- Project: Add Project ID mapped to your GCP project. This can be accessed by clicking on the Project name in the top navigation bar of GCP console.
-
Click Test to verify the datasource connectivity. If you have an error, fix the connection or credentials problem and click Test again.
-
Click Create to add the datasource.
Congratulations! You have successfully created a BigQuery datasource in bipp.
IN THIS PAGE