data-engineer-pro video for scenario: You are a BigQuery admin supporting a team of data consumers who run ad hoc queries and downstream reporting in tools such
Scenario: You are a BigQuery admin supporting a team of data consumers who run ad hoc queries and downstream reporting in tools such as Looker. All data and users are combined under one organizational project. You recently found out some slowness in query results and want to analyse where the slowdowns are occurring. You consider that there might be some job queuing or slot contention occurring as users run jobs, which slows down access to results. You need to check the query job information and determine where performance is being affected. Question: How can you investigate query job information to identify where the slowdowns are occurring and address the performance issues?