I wanted to write this post after the one about aggregation modes but I didn't. Before explaining different aggregation strategies, I prefer to clarify aggregation internals. It should help you to better understand the next part.
You want to learn data engineering but have no idea where and how to start in this wide domain? Check if Become a Data Engineer can help you 💪
"What's the scope of a temporary table?"
🤔
Check if you can answer this and +300 other questions about AWS Big Data services in my AWS Big Data services quizz