21 - Snowflake Data Warehouse Internals (CMU Advanced Databases / Spring 2023)

Prof. Andy Pavlo (www.cs.cmu.edu...)
Slides: 15721.courses....
15-721 Advanced Database Systems (Spring 2023)
Carnegie Mellon University
15721.courses....

[@gilpinim]

58:43 I'm super curious about Andy's opinion. too bad it's cut 😂😂

[@HeIsVeryMinkas]

Is that In Baltimore by K Mack in the intro? You got some good taste in hiphop.

[@Analytics-Today]

Terrific Talk - Thanks. Same question as @taLin - "DBMS supports query plan hints" (47:09) ? I wasn't aware of that - is that true? That's completely against the grain if true.

[@jmitesh01]

While Snowflake automatically clusters micro-partition in background what do the actual clustering key do to the Snowflake stored data? I'm guessing cluster key is rearrangment within a micro-partition i.e., How does query optimizer utilizes clustering key?

[@xinliang3113]

"59:00" The gang fight video is so funny!!! Where can I find this video online?

[@talin331]

Hi Andy,
Thanks a lot for the lecture! Can you please clarify what you mean by "DBMS supports query plan hints" (47:09) ? As far as I know because of Snowflake's philosophy "as a service" there are no hints and no plans to implement them.
Thanks,
Tania.

[@ChuckLathrope]

No runtime hints still. Maybe talking about how you can visually see the query plan as executed in query profile view and select nodes to focus in on in the new UI and also can get a plan given some sql with explain_json function.

[@jiqingtang2858]

Spills of the off camera discussions?