Google BigQuery Data Export Connector

Visier can send data through this connector if the following requirements are met.

Prerequisites

• Create a service account in Google Cloud Platform (GCP). For more information, see Create service accounts.
• Generate a service account key in JSON format. For more information, see Create and delete service account keys.
• Enable the Data Lineage API in your project. For more information, see View data lineage for Google Cloud systems.
• Allow network and data traffic between Visier and your source system. For more information, see Allow Visier Connections.

Service account

Assign the appropriate security access to the service account. For more information about dataset level permissions, see Grant access to a dataset. For more information about project level permissions, see Manage access to projects, folders, and organizations.

1
2
3
GRANT `roles/bigquery.dataEditor`
ON SCHEMA `your_project_id.your_dataset_name`
TO "serviceAccount:your-service-account@your-project-id.iam.gserviceaccount.com";

Connector credentials

Provide the following credentials in Visier. For more information, see Add data export connector credentials in Visier.