BigQuery

Create an integration to manage access to BigQuery datasets

Suggest Edits

Overview

Google BigQuery is a fast, scalable, secure, fully managed data warehouse service in the cloud, serving as a primary data store for vast datasets and analytic workloads. Google Cloud enables businesses to analyze their data using standard SQL and existing business intelligence tools, promoting insightful decision-making and integration with various Google Cloud services.

Through this integration, Apono helps you securely manage access to your BigQuery datasets.


Prerequisites

Before starting this integration, you will need the items listed in the following table.

ItemDescription
Apono ConnectorOn-prem connection serving as a bridge between a GCP instance and Apono

Make sure the connector has the BigQuery Data Viewer permission
Apono PremiumApono plan providing the most features and dedicated account support
Dataset NameName (dataset ID) of the database
Project IDIdentifier for the project associated with the BigQuery dataset

Integrate BigQuery

Use the following steps to complete the integration:

  1. On the Catalog tab, click Google BigQuery. The Connect BigQuery page appears.
  2. From the dropdown menu, select a connector.

    💡

    If the desired connector is not listed, click + Add new connector and follow the instructions for creating a GCP connector.


  1. Click Next. The Complete setup page appears.
  2. Enter a unique, alphanumeric, user-friendly Integration Name. This name is used to identify this integration when constructing an Access Flow.
  3. Enter the Project ID where BigQuery is enabled.
  4. Enter the Dataset Name to integrate.
  5. Click Connect.

Now that you have completed this integration, you can create access flows that grant permission to your BigQuery datasets.


Updated 2 months ago