Thanks for all your help! I wrote the following query and it works great for getting segment names and counts. But it doesn't work for getting segment descriptions, the description column is all empty. Do you know why? Should I get descriptions in a different way? SelectidentityMap.aepsegments.id as...

Thanks for the response, Arpan. I created a separate question: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform/obtaining-a-list-of-audience-names-and-descriptions-via-query/m-p/647916#M3822

I would like to run a query in Query Studio which produces a list of audiences with the following details: id, description, name, profile count. I am wondering how to expand the following query to get not only ids and profile counts  but also names and descriptions: SELECTCONCAT_WS('-', key, source_...

That's great. Is it possible to get extra details about the audience apart from its ID? I need to write a query where for every audience I list: the name, the description and the profile count.