Even though it is very old and a lot has changed since, this old blog post is still an interesting read, especially the sections about size parameters and deep aggregations.
Thanks, @Christian_Dahlqvist,
I will go through the documents you shared and figure out a way to solve my use case.
Thanks for quick response and help.