Popular channels
SQL query for Slack
Get the top 10 most popular channels in Slack based on the number of messages.
SELECT channel_id, COUNT(*) as message_count FROM messages GROUP BY channel_id ORDER BY message_count DESC LIMIT 10;
Slack data model
Channels
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed