Table: slack_conversation

The Slack Conversations API provides your app with a unified interface to work with all the channel-like things encountered in Slack: public channels, private channels, direct messages, group direct messages, and shared channels.

Examples

Conversations shared with external workspaces

select
  id,
  name,
  is_shared
from
  slack_conversation
where
  is_ext_shared;

Most popular conversations

select
  name,
  num_members
from
  slack_conversation
where
  num_members is not null
order by
  num_members desc
limit
  5;

The #general channel (whatever it is called)

select
  *
from
  slack_conversation
where
  is_general;

Get conversation by ID

select
  *
from
  slack_conversation
where
  id = 'C02GC4A7Q';

All private channel and group conversations

select
  name,
  created,
  is_channel,
  is_group,
  is_private
from
  slack_conversation
where
  is_private
  and (
    is_channel
    or (
      is_group
      and not is_mpim
    )
  )
order by
  name;

.inspect slack_conversation

Unified interface to all conversation like things including public channels, private channels, direct messages, group direct messages and shared channels.

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
created	timestamp with time zone	Time when the conversation was created.
creator	text	ID of the user who created the conversation.
id	text	ID of the conversation.
is_archived	boolean	If true, the conversation has been archived.
is_channel	boolean	If true, the conversation is a public channel inside the workspace.
is_ext_shared	boolean	If true, the conversation is shared with an external workspace.
is_general	boolean	If true, this is the #general public channel (even if it's been renamed).
is_group	boolean	If true, the conversation is a private channel.
is_im	boolean	If true, the conversation is a direct message between two individuals or a user and a bot.
is_member	boolean	If true, the user running this query is a member of this conversation.
is_mpim	boolean	If true, this is an unnamed private conversation between multiple users.
is_org_shared	boolean	If true, the conversation is shared between multiple workspaces within the same Enterprise Grid.
is_pending_ext_shared	boolean	If true, the conversation hopes is awaiting approval to become is_ext_shared.
is_private	boolean	If true, the conversation is privileged between two or more members.
is_shared	boolean	If true, the conversation is shared across multiple workspaces. See also is_ext_shared.
name	text	Name of the conversation.
name_normalized	text	Name of the conversation normalized into simple ASCII characters.
num_members	bigint	Number of members in the conversation. Not set if the conversation is individual messages between fixed number of users.
purpose	text	Purpose of the conversation / channel.
purpose_creator	text	User who created the purpose for the conversation.
purpose_last_set	timestamp with time zone	Time when the purpose was last set.
topic	text	Topic of the conversation / channel.
topic_creator	text	User who created the topic for the conversation.
topic_last_set	timestamp with time zone	Time when the topic was last set.
workspace_domain	text	The domain name for the workspace.

turbot/slack