Troubleshooting BigQuery

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

Jun 24, 2022, 4:00 – 5:00 PM

71
RSVP'd

Key Themes

Career DevelopmentCertification PrepCloudDataInclusionMachine LearningNetworking

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.

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.


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

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

When

When

Friday, June 24, 2022
4:00 PM – 5:00 PM UTC

Agenda

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

Speaker

  • Dan Sullivan

    4 Mile Analytics

    Principal Data Architect

Partner

Dan Sullivan logo

Dan Sullivan

Organizers

  • Linda Kovacs

    Accenture

    GDG Lead & WTM Ambassador

  • Fausto Hernandez

    Team Member

  • Blain Smith

    Team Member

  • Chadd Portwine

    Team Member

Contact Us