Skip to main content

Peliqan

Try for free
Request a demo

Slack

Most active channels and users

SQL query for Slack

Retrieve the most active channels and users from the Slack data tables.

SELECT channel_name, COUNT(*) as channel_messages FROM messages_table GROUP BY channel_name ORDER BY channel_messages DESC LIMIT 5; SELECT user_name, COUNT(*) as user_messages FROM messages_table GROUP BY user_name ORDER BY user_messages DESC LIMIT 5;

Try this query now in Slack

Slack data model

Slack
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