Get more info for each aggregated bucket

This is a specific question for DSL but labelled as SQL, I copied your question to OpenSearch section [DSL] Get more info for each aggregated bucket