I spent 3 hours figuring out how BigQuery inserts, deletes and updates data internally. Here's what I found.

"Just open the file and modify the data, ... No?"

My name is Vu Trinh, and I am a data engineer. I’m trying to make my life less dull by spending time learning and researching “how it works“ in the data engineering field. Here is a place where I share everything I’ve learned. Not subscribe yet? Here you go:

Image created by the author