Troubleshooting BigQuery

GDG Capital Region
Fri, Jun 24, 2022, 12:00 PM (EDT)

71 RSVP'ed

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

About this event

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.


Dan Sullivan 

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

This event is brought to you in collaboration with the following GDG chapters:

  • GDG Lawrence
  • GDG Capital Region
  • Cloud Study Network (Germany)



Friday, Jun 24
12:00 PM - 1:00 PM (EDT)


  • Linda Kovacs

    Linda Kovacs


    GDG Lead & WTM Ambassador

    View Profile
  • Fausto Hernandez

    Fausto Hernandez

    Team Member

    View Profile
  • Jason Rotella

    Jason Rotella

    GDG Founding Organizer

    View Profile
  • Blain Smith

    Blain Smith

    Team Member

  • Chadd Portwine

    Chadd Portwine

    Team Member