- 08 Oct 2023
- 1 Minute to read
- Updated on 08 Oct 2023
- 1 Minute to read
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:
Project ID (required) - The ID of the Google Cloud Project.
Dataset ID (required) - TheThe ID of the Google Big Query Dataset.
Table ID (required) - The ID of the Google Big Query Table.
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.
HTTPS Proxy (optional) - Connect the adapter to a proxy instead of directly connecting it to the domain.
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.
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
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:
bigquery.jobs.createon the project.
bigquery.tables.getDataon 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