Build and operate the data processing systems behind analytics and ML on Google Cloud, including BigQuery, Dataflow, and Pub/Sub, and track your readiness for the Professional Data Engineer exam.
Advanced
Prepare and test your skills
Advanced
Prepare and test your skills
Google Cloud feature
BigQuery API
Topic in 2 exam domains
- BigQuery API · Feature
- BigQuery API · Service
The application programming interface that enables programmatic and console access to BigQuery services and resources.
Where this appears on the exam
2 objectives in 1 of 5 domains
Related topics
This topicWorks alongsideBuilds on theseBuilds on theseBuilds on theseBuilds on theseApplied
BigQuery APIService
Customer-managed encryption keysFeatureGoogle Cloud StorageServiceGoogle Cloud consoleFeatureCloud MonitoringServiceApigeeServiceBigQuery Data Transfer ServiceServiceCloud LoggingServiceCMEKFeatureBigQueryServiceCloud SQLServiceBigQuery BI EngineServiceGoogle Kubernetes EngineServiceManaged Service for Apache AirflowServicePoints to what builds on itWorks with or alternative toHover or tap a line to see what connects the two
- Apigee depends on BigQuery API From the official documentation: “Apigee uses the BigQuery API to leverage BigQuery export features when exporting to Cloud Storage.”
- BigQuery API is part of BigQuery From the official documentation: “BigQuery, including the BigQuery API and the target table.”
- BigQuery API works with BigQuery BI Engine From the official documentation: “BI Engine directly integrates with the BigQuery API.”
- BigQuery API is an alternative to Google Cloud console From the official documentation: “To retrieve query results from temporary tables, you can use the Google Cloud console or the [BigQuery API](/bigquery/docs/reliability-read#read_with_api).”
- BigQuery Data Transfer Service depends on BigQuery API From the official documentation: “Create a project and enable the BigQuery API.”
- Google Kubernetes Engine depends on BigQuery API From the official documentation: “This happens because Google Kubernetes Engine depends on BigQuery and Managed Service for Apache Airflow inherits this dependency from the Kubernetes Engine API.”
- Managed Service for Apache Airflow depends on BigQuery API From the official documentation: “**Important:** If you disable the BigQuery API, your Managed Airflow environment stops working. This happens because Google Kubernetes Engine depends on BigQuery and Managed Service for Apache Airflow inherits this dependency from the Kubernetes Engine API.”
- BigQuery works with Cloud Logging From the official documentation: “BigQuery utilizes Cloud Logging for some of your log data.”
- BigQuery works with BigQuery Data Transfer Service From the official documentation: “The BigQuery Data Transfer Service uses load jobs to load Amazon S3 data into BigQuery.”
- BigQuery works with Cloud SQL From the official documentation: “Add credentials to connect BigQuery to Cloud SQL.”
- Cloud Logging works with Customer-managed encryption keys From the official documentation: “To use Cloud Logging with Customer-managed encryption keys (CMEK), you must complete the steps in the [Enable CMEK for an organization](/logging/docs/routing/managed-encryption#enable) page in the Cloud Logging documentation.”
- BigQuery works with Cloud Monitoring From the official documentation: “You can use Monitoring to export your metrics to BigQuery.”
- BigQuery is an alternative to Google Cloud Storage From the official documentation: “The training data can be either a CSV file in Cloud Storage or a table in BigQuery.”
- BigQuery works with Google Cloud Storage From the official documentation: “Load Cloud Storage data into BigQuery”
- Cloud Monitoring works with Cloud SQL From the official documentation: “You can also get more details by viewing the Cloud Monitoring logs for your Cloud SQL destination instance.”
- CMEK secures Cloud SQL From the official documentation: “Enable CMEK for Cloud SQL Databases”
- Cloud Logging works with Cloud SQL From the official documentation: “Cloud SQL uses Cloud Logging.”
- Cloud Logging works with Managed Service for Apache Airflow From the official documentation: “You can use [Cloud Monitoring](/monitoring/docs) and [Cloud Logging](/logging/docs) with Managed Service for Apache Airflow.”
- CMEK secures BigQuery From the official documentation: “Enable CMEK for BigQuery Tables”
- Customer-managed encryption keys secures BigQuery From the official documentation: “You can either create CMEKs manually to protect your BigQuery resources or use Cloud KMS Autokey.”
- Customer-managed encryption keys secures Cloud SQL From the official documentation: “Enable CMEK for Cloud SQL Databases”
- BigQuery works with Managed Service for Apache Airflow From the official documentation: “You can use Managed Airflow to orchestrate services in your data pipelines, such as triggering a job in BigQuery or starting a Dataflow pipeline.”
- Cloud Monitoring works with Managed Service for Apache Airflow From the official documentation: “You can use [Cloud Monitoring](/monitoring/docs) and [Cloud Logging](/logging/docs) with Managed Service for Apache Airflow.”
- Customer-managed encryption keys secures Managed Service for Apache Airflow From the official documentation: “This page describes how to use [Customer Managed Encryption Keys (CMEK)](/kms/docs/cmek) to protect Managed Airflow environments.”
- Managed Service for Apache Airflow depends on Cloud SQL From the official documentation: “Managed Airflow uses Cloud SQL to run Airflow database.”
- Apigee works with Customer-managed encryption keys From the official documentation: “This page describes using CMEK with Apigee.”
- BigQuery depends on Cloud Logging From the official documentation: “BigQuery utilizes Cloud Logging for some of your log data.”
- BigQuery Data Transfer Service works with Customer-managed encryption keys From the official documentation: “When you specify a CMEK with a transfer, the BigQuery Data Transfer Service applies the CMEK to any intermediate on-disk cache of ingested data so that the entire data transfer workflow is CMEK compliant.”
- Cloud SQL works with Google Cloud Storage From the official documentation: “Imports data into a Cloud SQL instance from a SQL dump or CSV file in Cloud Storage.”
- BigQuery works with BigQuery BI Engine From the official documentation: “BigQuery BI Engine lets you perform fast, low-latency analysis services and interactive analytics with reports and dashboards backed by BigQuery.”
- BigQuery BI Engine is part of BigQuery From the official documentation: “BI Engine acceleration is part of BigQuery job processing.”
- Cloud Logging works with Cloud Monitoring From the official documentation: “If a log entry matches the filter of the alerting policy, then Cloud Logging extracts labels and forwards the data to Cloud Monitoring.”
- Cloud Logging is an alternative to Google Cloud Storage From the official documentation: “When you specify your own service account for builds, you must store your build logs in a Cloud Logging bucket, in a user-created Cloud Storage bucket, or in a Google Cloud-created and user-owned Cloud Storage bucket.”
- Cloud Logging works with Google Kubernetes Engine From the official documentation: “As an example, if you are using GKE, you can [use Cloud Logging to query](/logging/docs/view/building-queries) for GKE cluster audit logs.”
- Cloud SQL works with Google Kubernetes Engine From the official documentation: “The [Connecting from Google Kubernetes Engine](/sql/docs/sqlserver/connect-kubernetes-engine) page demonstrates how to configure and connect to Cloud SQL.”
- Customer-managed encryption keys secures Cloud Logging From the official documentation: “Cloud Logging supports encrypting Log storage with CMEK keys.”
- Customer-managed encryption keys secures Google Kubernetes Engine From the official documentation: “In IL5, CMEK is enabled by default for Compute Engine, Google Kubernetes Engine (GKE), Cloud Storage, and Cloud SQL.”
- Google Kubernetes Engine depends on BigQuery From the official documentation: “This happens because Google Kubernetes Engine depends on BigQuery and Managed Service for Apache Airflow inherits this dependency from the Kubernetes Engine API.”
- Managed Service for Apache Airflow depends on Google Cloud Storage From the official documentation: “Managed Airflow uses a [Cloud Storage](/storage) bucket to store DAGs of your Managed Airflow environment.”
- Managed Service for Apache Airflow depends on Google Kubernetes Engine From the official documentation: “Managed Airflow depends on GKE to deliver support for non-RFC 1918 addresses for Pods and Services.”
- Apigee works with BigQuery From the official documentation: “You can use the Apigee API to export all analytics data for an entire day from Apigee to your own data repository, such as Google Cloud Storage or BigQuery.”
- Apigee works with Cloud Logging From the official documentation: “This page describes how to find and use [Cloud Logging](/logging/docs) to query and view maintenance logs for an Apigee instance.”
- Apigee works with Cloud Monitoring From the official documentation: “If you are behind a corporate proxy or firewall, Apigee may not be able to send metrics to Cloud Monitoring with its default settings.”
- Apigee works with Google Cloud Storage From the official documentation: “You can use the Apigee API to export all analytics data for an entire day from Apigee to your own data repository, such as Google Cloud Storage or BigQuery.”
- BigQuery BI Engine works with Cloud Monitoring From the official documentation: “You can monitor and configure alerts for BigQuery BI Engine with Cloud Monitoring.”
- BigQuery Data Transfer Service works with Cloud Logging From the official documentation: “The BigQuery Data Transfer Service exports logs and metrics to Cloud Monitoring and Cloud Logging that provide observability into your transfers.”
- BigQuery Data Transfer Service works with Cloud Monitoring From the official documentation: “The BigQuery Data Transfer Service exports logs and metrics to Cloud Monitoring and Cloud Logging that provide observability into your transfers.”
- BigQuery Data Transfer Service works with Cloud SQL From the official documentation: “To transfer data from a private Cloud SQL instance in one project to BigQuery in another project, BigQuery Data Transfer Service requires a connector network to bridge private network connectivity.”
- BigQuery Data Transfer Service works with CMEK From the official documentation: “For information about how customer-managed encryption keys (CMEK) works with the BigQuery Data Transfer Service, see [Specify encryption key with scheduled queries](#CMEK).”
- BigQuery Data Transfer Service works with Google Cloud Storage From the official documentation: “As part of the data transfer, BigQuery Data Transfer Service writes data from Amazon Redshift to Cloud Storage as CSV files.”
- Cloud Logging is an alternative to Cloud Monitoring From the official documentation: “To see the status of your invalidation request or find a definitive list of recently submitted requests, you can use Cloud Logging or Cloud Monitoring.”
- Cloud Logging works with Google Cloud Storage From the official documentation: “See [Routing and storage overview](/logging/docs/routing/overview) to route logs from Logging to Cloud Storage, BigQuery, or Pub/Sub.”
- Cloud Monitoring works with Google Cloud Storage From the official documentation: “You can configure Cloud Storage client libraries to to generate gRPC related metrics in Cloud Monitoring.”
- Cloud Monitoring works with Google Kubernetes Engine From the official documentation: “This page describes how to configure a Google Kubernetes Engine (GKE) cluster to send a curated set of cAdvisor/Kubelet metrics to Cloud Monitoring using Google Cloud Managed Service for Prometheus.”
- Cloud SQL works with Customer-managed encryption keys From the official documentation: “To learn more about using customer-managed encryption keys with Cloud SQL, see [Overview of customer-managed encryption keys](/sql/docs/postgres/cmek).”
- Cloud SQL works with Managed Service for Apache Airflow From the official documentation: “Managed Airflow updates the Airflow `airflow_db` connection to point to the new Cloud SQL database.”
- CMEK is part of Apigee From the official documentation: “**Dashboard availability:** This dashboard is not available if your Apigee organization was provisioned with compliance-related Apigee features, such as [data residency](/apigee/docs/api-platform/get-started/drz-concepts)…”
- CMEK secures Managed Service for Apache Airflow From the official documentation: “Maintaining required permission for the CMEK key used for Managed Airflow environment encryption and rotating it according to your needs.”
- Customer-managed encryption keys secures Apigee From the official documentation: “To ensure that customer-managed encryption keys are always used when encrypting your data in Apigee, create the following organization policy constraint:”
- Customer-managed encryption keys secures BigQuery Data Transfer Service From the official documentation: “When you specify a CMEK with a transfer, the BigQuery Data Transfer Service applies the CMEK to any intermediate on-disk cache of ingested data so that the entire data transfer workflow is CMEK compliant.”
How learners score on this topic
Last updated