
Google Professional Data Engineer
Get started today
Ultimate access to all questions.
You're working with a BigQuery table and execute a query that includes a WHERE clause filtering data by a timestamp and an ID column. Despite the filter targeting a small subset of data, the bq query --dry_run
command reveals the query performs a full table scan. Your goal is to minimize the data scanned by BigQuery without modifying your SQL queries. What's the best approach?
You're working with a BigQuery table and execute a query that includes a WHERE clause filtering data by a timestamp and an ID column. Despite the filter targeting a small subset of data, the bq query --dry_run
command reveals the query performs a full table scan. Your goal is to minimize the data scanned by BigQuery without modifying your SQL queries. What's the best approach?
Real Exam