I teach SQL and data engineering to 400k+ people on YouTube. Founder of SQLNest.
Warsaw, Poland
Joined May 2022
- Tweets8
- Following4
- Followers264
- Likes15
Quiz #1
A table has 100 columns and your query reads only 3 of them. Which file format helps most?
0%CSV
0%JSON
0%Parquet
0%Plain text
0 votes • Final results 1
111
Quiz #1
Answer: C (Parquet). Parquet stores data by column, so the engine reads only the 3 columns it needs and skips the other 97. It also compresses well. CSV and JSON force a read of every row in full.
11
A gift from #youtube ❤️
It’s been an amazing journey so far and I just want to say THANK YOU 🙏🏼
#youtubecreatorawards instagram.com/p/Cio6o4kvrt5/…
A must try desert 🍧😋 if you are in Melaka, Malaysia.
#justberrysdesserthouse @ Melaka, Malaysia instagram.com/p/Cg4Ectqv1mY/…
3
Which one do you choose ?
youtu.be/LNlzx-YX8rI
100%Data Analyst
0%Business Analyst
2 votes • Final results