Events

Quarantine DB Talk 2020: Query Optimization at Snowflake

Event Date: Monday September 21, 2020
Event Time: 05:00pm EDT
Location: https://cmu.zoom.us/j/562649242?pwd=djhicnFKWHdJM1o0MlFvYzg3SzB5Zz09
Speaker: Jiaqi Yan [INFO]

Title: Query Optimization At Snowflake

In this talk, I will give an introduction to Snowflake’s query optimizer. I will talk about the main features of Snowflake’s optimizer, explain the main philosophy behind the design decisions, and delve into some unique aspects of the implementation. I will also later expand into our infrastructures to facilitate optimizer development and discuss the opportunities and challenges for implementing and rolling out query optimizations for cloud-based databases.

This talk is part of the Quarantine Database Tech Talk Seminar Series.

Zoom Link: https://cmu.zoom.us/j/562649242 (Password 264771)

Bio:
Jiaqi Yan is a software engineer at Snowflake Computing. His main work spans Snowflake's query engine, serverless features, and engineering infrastructure. He currently leads development of performance improvements for Snowflake's query compiler and optimizer. Before joining Snowflake, Jiaqi was a software engineer at Oracle.

More Info: https://db.cs.cmu.edu/seminar2020/