Google BigQuery

Overview

Use this connector to extract metadata from Google BigQuery datasets using a Service Account.

Create User & Grant Permissions

Run the following SQL commands to create a dedicated user and grant the required read-only permissions:

• Create a Service Account in Google Cloud IAM
• Grant roles:
  • BigQuery Job User
  • BigQuery Metadata Viewer
  • BigQuery Resource Viewer
  • BigQuery Data Viewer
• Create a JSON key and upload it in Connetra.

Connection Setup in Connetra

When adding a data connector in Connetra, provide the following details.

• Configuration name
• Service Account JSON Key file

Before you can save the data connector you must first test the connection.