You are using Looker Studio to visualize a table from your data warehouse that is built on top of BigQuery. Data is appended to the data warehouse during the day. At night, the daily summary is recalculated by overwriting the table. You just noticed that the charts in Looker Studio are broken, and you want to analyze the problem. What should you do?

Question

Accepted Answer

D. Use the BigQuery interface to review the nightly job and look for any errors. Since the BigQuery table is overwritten nightly, the most direct approach to diagnose why Looker Studio charts are broken is to examine the execution and logs of that nightly job within the BigQuery interface to identify any failures or data quality issues during the recalculation process.

Answer

A. In Cloud Logging, create a filter for your Looker Studio report. Cloud Logging might contain some operational logs, but it's not the primary place to diagnose data processing errors related to a BigQuery job that populates a table used by Looker Studio.

Answer

B. Use the open source CLI tool, Snapshot Debugger, to find out why the data was not refreshed Snapshot Debugger is a tool for debugging application code, not for analyzing data processing failures within BigQuery or data pipeline jobs.

Answer

C. Review the Error Reporting page in the Google Cloud console to find any errors. Error Reporting aggregates application errors and is generally not the go-to service for identifying failures in BigQuery data loading or transformation jobs.

You are using Looker Studio to visualize a table from your data warehouse that is built on top of BigQuery. Data is appended to the data warehouse during the day. At night, the daily summary is recalc

Question

Options

How the community answered

Why each option

Topics

Community Discussion