Professional Data Engineer

By Google · Question Mode

QuestionQ41

Preparing and using data for analysis

You store and analyze relational data in BigQuery on Google Cloud, with all data located in US regions. You also have a variety of object stores across Microsoft Azure and Amazon Web Services (AWS), likewise in US regions. You want to query all of your data in BigQuery each day while moving as little data as possible. What should you do?

Explanation

BigQuery Omni lets BigQuery analyze data that remains in Amazon S3 and Azure Blob Storage through BigLake tables. BigQuery Omni joins support combining those external tables with BigQuery tables in the US multi-region, eliminating the need to copy the source data into BigQuery before querying it.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!