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
visual modeling canvas
Topic in 1 exam domain
An interactive, drag-and-drop workspace in Looker to build, edit, and join BigQuery data models and publish Explores without writing LookML code.
Where this appears on the exam
1 objective in 1 of 5 domains
~15% of exam
Related topics
FoundationsThis topicWorks alongsideBuilds on theseAppliedLookerServiceCloud SQLService
visual modeling canvasFeature
customer-managed encryption keysFeatureData StudioServiceBigQueryServiceSpannerServiceAlloyDB for PostgreSQLServiceBigQuery BI EngineServicePoints to what builds on itWorks with or alternative toHover or tap a line to see what connects the two
- BigQuery works with visual modeling canvas From the official documentation: “The visual modeling canvas in Looker lets you connect to BigQuery data sources so that you can build and edit LookML data models by using an interactive, drag-and-drop canvas.”
- visual modeling canvas is part of Looker From the official documentation: “The visual modeling canvas in Looker lets you connect to BigQuery data sources so that you can build and edit LookML data models by using an interactive, drag-and-drop canvas.”
- BigQuery works with Cloud SQL From the official documentation: “Add credentials to connect BigQuery to Cloud SQL.”
- BigQuery works with Data Studio From the official documentation: “Select the BigQuery [connector](/data-studio/connector).”
- BigQuery works with Looker From the official documentation: “Connect Looker to the BigQuery project.”
- BigQuery works with Spanner From the official documentation: “Reverse ETL (BigQuery to Spanner)”
- 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”
- Cloud SQL works with Looker From the official documentation: “To get started, see [Use Looker with Cloud SQL](/sql/docs/sqlserver/looker).”
- AlloyDB for PostgreSQL works with BigQuery From the official documentation: “BigQuery AlloyDB federation lets BigQuery query data residing in AlloyDB in real time without copying or moving the data.”
- customer-managed encryption keys works with Spanner From the official documentation: “This page describes how to use manually-created customer-managed encryption keys (CMEK) for Spanner.”
- AlloyDB for PostgreSQL is an alternative to Cloud SQL From the official documentation: “The sample code uses Cloud SQL as the vector database, whereas this reference architecture uses AlloyDB for PostgreSQL.”
- 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.”
- AlloyDB for PostgreSQL works with customer-managed encryption keys From the official documentation: “This page describes how to create, configure, and apply customer-managed encryption keys (CMEK) for AlloyDB for PostgreSQL.”
- AlloyDB for PostgreSQL works with Looker From the official documentation: “Looker supports connections to [AlloyDB for PostgreSQL](/alloydb/docs/overview), a fully managed, cloud-native database service from Google Cloud that is compatible with PostgreSQL.”
- BigQuery BI Engine works with Data Studio From the official documentation: “BI Engine integrates with Data Studio to accelerate data exploration and analysis.”
- BigQuery BI Engine works with Looker From the official documentation: “If you are using [BigQuery BI Engine](/bigquery/docs/bi-engine-intro) with Looker, you can use the **Query Performance Metrics** Explore to view database-specific information about your queries.”
- 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 Data Studio From the official documentation: “Data Studio supports both public and private IP connections to PostgreSQL on Cloud SQL.”
- Cloud SQL is an alternative to Spanner From the official documentation: “If you're interested in evaluating how the performance of your on-premises databases compares to [Cloud SQL](/sql), [Spanner](/spanner), [Firestore](/firestore), or [Bigtable](/bigtable), you could implement a PoC where the same business logic uses different databases.”
- customer-managed encryption keys secures AlloyDB for PostgreSQL From the official documentation: “If you enable CMEK on a cluster, then AlloyDB uses your key to encrypt all of your cluster's data in storage.”
- customer-managed encryption keys is part of Cloud SQL From the official documentation: “Cloud SQL also lets you add another layer of encryption to data using [customer-managed encryption keys (CMEK)](/sql/docs/postgres/cmek).”
- customer-managed encryption keys works with Looker From the official documentation: “CMEK is supported only for Looker data sources.”
- customer-managed encryption keys secures Spanner From the official documentation: “To learn how to use manually-created CMEKs to protect your Spanner resources, see [Secure a database with CMEK](/spanner/docs/use-cmek).”
- Data Studio works with Looker From the official documentation: “See the [Connecting to Data Studio](/looker/docs/looker-studio-connector) documentation page to learn more about connecting Looker and Data Studio.”
- Data Studio is an alternative to Looker From the official documentation: “You can also [export these recommendations to BigQuery](/recommender/docs/bq-export/export-recommendations-to-bq) and then examine them using [Data Studio](/bigquery/docs/visualize-looker-studio) or [Looker](/bigquery/docs/looker).”
- Looker works with Spanner From the official documentation: “This page explains how to set up a connection in Looker to Google Spanner.”
How learners score on this topic
Last updated