data-engineer-pro video for as a BigQuery administrator responsible for supporting a diverse team of data consumers utilizing tools like Looker for ad hoc
As a BigQuery administrator responsible for supporting a diverse team of data consumers utilizing tools like Looker for ad hoc queries and downstream reporting, you've recently observed a slowdown in query results within your single organizational project. Suspecting potential causes such as job queuing or slot contention, you're keen to investigate and pinpoint where performance issues are occurring. Given the complexity of your environment and the critical nature of maintaining optimal performance, what comprehensive approach would you recommend to thoroughly assess and address these slowdowns? Considering factors such as resource allocation, monitoring capabilities, administrative insights, and security concerns, outline the steps you would take to delve into the query job information and identify the root causes of the performance degradation.