Associate Data Practitioner

By Google · Question Mode

QuestionQ1

Data Pipeline Orchestration

Your team uses Google Sheets to track budget data that is updated each day. The team wants to compare the budget data with actual cost data stored in a BigQuery table. You need to create a solution that calculates the difference between each day’s budget and actual costs. You want to make sure your team can access daily updated results in Google Sheets. What should you do?

Explanation

BigQuery supports Google Sheets as a Google Drive external-table source through a Drive URI, allowing queries to use the current spreadsheet data. A join with the actual-cost table calculates the daily difference, and Connected Sheets can execute BigQuery queries on a defined schedule so the spreadsheet receives refreshed results without CSV-based snapshot exports.

Learn more

Community Discussion

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