Skip to main content

Google BigQuery

Integrating Google BigQuery with Osano

Connecting to Google BigQuery


In order for Osano to discover data stored in your systems, we must connect to those data providers via an API. We require, at minimum, read-only access to establish a connection to these providers. Each provider you connect may require different information. Please see the linked vendor documentation for instructions on where and how to obtain this data.


Required Fields

  • Tables
  • Service Account JSON Key

Here are links to instructions from Google on how to locate the Tables and Service Account Key listed as required above.

Instructions for creating your Service Account JSON Key. It's important to use the JSON key type and have an account with the appropriate scopes.

Required Scopes

  • BigQuery Data Viewer
  • BigQuery Job User

Core Functionality

  • Data Discovery
  • User Search
  • Data Deletion

Base URL

https://cloud.google.com/bigquery/docs/reference/libraries-overview

Auth

  • oauth
  • apiKey

Service account JSON key

  • email
  • name
  • phoneNumber
  • address
  • birthday
  • userId

Data Deletion

Data deletion is not fully implemented as the user will need to confirm the data returned is correct