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 💪
"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