BigQuery

A fully managed enterprise data warehouse that helps you manage and analyze your data with built-in features like machine learning, geospatial analysis, and business intelligence.

Overview

  • Reduce Over Privileges - Discover existing privileges to GCP roles, groups and services to convert to on-demand access flows to reduce over-privileges.
  • Self Service Access - Empower your developers to gain self-servable access to GCP services, buckets, instances and more using Slack.
  • Automated Approval Workflows - Create approval workflows to specific sensitive resources.
  • Restricted Third Party Access - Grant third-party (customer or vendor) time-based access to specific buckets, databases or instances with MFA verification.
  • Review Access - View a detailed access audit of who was granted access to which specific instances, buckets or other resources in GCP.

Prerequisites

  • GCP integration connected to Apono
  • At least 1 BigQuery dataset instance

How To Integrate GCP BigQuery

📘

Have you connected a GCP project?

Make sure you have first integrated a GCP project with Apono. If not, follow this GCP Integration step-by-step guide.

  1. Click on Integrations Catalog
  2. Under GCP, look for GCP BigQuery and click Connect
18061806
  1. Fill in the Integration details
  • Type the Integration Name
  • Choose the Cloud Account from the dropdown list (list of Organization IDs)

In the Google Console, search for BigQuery to review the BigQuery details

695695
  • Project ID - the project ID where the BigQuery installed
  • Dataset Name - the name of the database

👍

Hurray!!

You've successfully integrated Apono with your GCP BigQuery. You should see the new integration in your Connected Integrations.
You can now use this integration in your existing or new Access Flow. Check this guide out for more information on creating your first Access Flow in Apono.


What’s Next