Troubleshooting BigQuery

GDG NYC

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

Jun 24, 2022, 4:00 – 5:00 PM (UTC)

123 RSVP'd

Key Themes

Career DevelopmentCloudDataDevOpsMachine Learning

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.

When

When

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

Agenda

4:00 PMTroubleshooting BigQuery: It’s All Fun and Games Until Someone Gets A Resource Exhausted Error
4:40 PMQuestions, Answers and Prizes

Speaker

  • Dan Sullivan

    4 Mile Analytics

    Principal Data Architect

Mentor

  • Anna Nerezova

    artnet.com

    Analytics and Optimization Consultant

Hosts

  • Linda Kovacs

    Accenture

    Software Engineer

  • Anna Nerezova

    artnet.com

    Analytics and Optimization Consultant

Partner

Dan Sullivan logo

Dan Sullivan

Organizers

  • Ralph Yozzo

    Tidalforce

    GDG Organizer

  • Anna Nerezova

    GDG Organizer

  • Bhavik Chopra

    Metropolitan Transportation Authority

    Computer Science Graduate Student

  • Shivika Arora

    JP Morgan

    Executive Director, Product

Contact Us