Google BigQuery
  • 08 Oct 2023
  • 1 Minute to read
  • Dark
  • PDF

Google BigQuery

  • Dark
  • PDF

Article summary

BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and machine learning built in.
This adapter is similar to the CSV adapter.
The format of the table must be simliar to that described for the CSV adapter.

Types of Assets Fetched

This adapter fetches the following types of assets:

  • Devices


  1. Project ID (required) - The ID of the Google Cloud Project.

  2. Dataset ID (required) - TheThe ID of the Google Big Query Dataset.

  3. Table ID (required) - The ID of the Google Big Query Table.

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

  5. HTTPS Proxy (optional) - Connect the adapter to a proxy instead of directly connecting it to the domain.

  6. HTTPS Proxy User Name (optional) - The user name to use when connecting to the value supplied in Host Name or IP Address via the value supplied in HTTPS Proxy.

  7. HTTPS Proxy Password (optional) - The password to use when connecting to the server using the HTTPS Proxy.

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



Axonius uses the Google BigQuery API

Required Permissions

The following permissions are required:

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

  • Requires one of the following OAuth scopes:

  • The following permissions are required to run a query job: 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

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.