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 💪
Get new posts, recommended reading and other exclusive information every week. SPAM free - no 3rd party ads, only the information about waitingforcode! Curious about the content ? Check some of already sent newsletters
"But I've read that doing streaming on Redshift is not a good thing if we INSERT row by row. Is that true?" 🤔 Check if you can answer this and +300 other questions about AWS Big Data services in my AWS Big Data services quizz