Google BigQuery

BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and machine learning built in.

📘

Note

This adapter is similar to the Custom Files/CSV adapters. The format of the table must be similar to that described in Asset Fields Imported in File-Based Adapters.

Asset Types Fetched

• Devices , Aggregated Security Findings , Software, SaaS Applications

Before You Begin

APIs

Axonius uses the Google BigQuery API.

Required Permissions

• Google BigQuery API must be enabled in the Google Cloud project

• Requires one of the following OAuth scopes:

  https://www.googleapis.com/auth/bigquery

  https://www.googleapis.com/auth/cloud-platform

  https://www.googleapis.com/auth/bigquery.readonly

  https://www.googleapis.com/auth/cloud-platform.read-only

• The following permissions are required to run a query job:

  bigquery.jobs.create on the project.

  bigquery.tables.getData on all tables and views that your query references. To query views, you also need this permission on all underlying tables and views. If you're using authorized views or authorized datasets, you don't need access to the underlying source data.

Supported From Version

Supported from Axonius version 6.0

Connecting the Adapter in Axonius

Note: All fields are required.

1. Project ID - The ID of the Google Cloud Project.

2. Dataset ID - The ID of the Google Big Query Dataset.

3. Table ID - The ID of the Google Big Query Table.

4. JSON Key pair for the service account - A JSON-document containing service-account credentials to GCP. For details, see Connect Axonius to Google Cloud Platform.

To learn more about common adapter connection parameters and buttons, see Adding a New Adapter Connection.