QuestionQ89

VerifiedEnsuring the successful operation of a cloud solution

You are using Data 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 Data Studio are broken, and you want to analyze the problem. What should you do?

Explanation

The issue is in the data layer, not the application layer. Review the nightly BigQuery job in the BigQuery interface to check its execution status and any error messages. This is where you find detailed job logs and can diagnose data refresh failures. Cloud Debugger (shut down in May 2023), Error Reporting (for application errors), and a Cloud Logging filter for the Data Studio report are not appropriate for diagnosing BigQuery job failures.

Learn more

Community Discussion

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