Speaker: Dan Sullivan

Dan Sullivan is a Principal Data Architect at 4 Mile Analytics. He is a software architect and data scientist with extensive experience in data science, machine learning, and cloud architecture. Dan is the author of the official Google Cloud study guides for the Professional Architect, Professional Data Engineer, and Associate Cloud Engineer certification exams as well as the instructor of over a dozen courses on machine learning, data science, and cloud computing on LinkedIn Learning and Udemy.

Talk title: Troubleshooting BigQuery: It’s All Fun and Games Until Someone Gets A Resource Exhausted Error

BigQuery is designed to scale to petabytes of data and efficiently retrieve that data using a full range of SQL queries but things do not always go as planned. Queries may take too long to execute or fail because of insufficient resources. Without an understanding of BigQuery architecture and how to find details about errors it can be difficult to troubleshoot errors. In this presentation, we’ll review how BigQuery allocates resources and discuss how to use execution details, logs, and information_schema data to analyze errors in BigQuery. We’ll also look into data modeling and ingestion best practices that can help minimize performance problems.

Prizes:

Dan Sullivan https://www.udemy.com/user/dan-sullivan-3/

Dan Sullivan will provide free access for all attendees to his new Google Cloud BigQuery course on Udemy.