Slack

Tables in the Slack connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	channels	26
2	channel_members	2
3	threads	15
4	users	19				API Reference
5	channel_messages	41

Table: channels

No	Column Name	Type	Notes
1	is_private	BOOLEAN
2	purpose	VARCHAR
3	is_pending_ext_shared	BOOLEAN
4	locale	VARCHAR
5	pending_shared	VARCHAR
6	is_channel	BOOLEAN
7	is_shared	BOOLEAN
8	is_read_only	BOOLEAN
9	id	VARCHAR
10	previous_names	VARCHAR
11	last_read	VARCHAR
12	creator	VARCHAR
13	is_im	BOOLEAN
14	is_member	BOOLEAN
15	is_mpim	BOOLEAN
16	created	INTEGER
17	name_normalized	VARCHAR
18	is_ext_shared	BOOLEAN
19	is_group	BOOLEAN
20	unlinked	INTEGER
21	is_archived	BOOLEAN
22	is_general	BOOLEAN
23	num_members	INTEGER
24	name	VARCHAR
25	topic	VARCHAR
26	is_org_shared	BOOLEAN

Table: channel_members

No	Column Name	Type	Notes
1	member_id	VARCHAR
2	channel_id	VARCHAR

Table: threads

No	Column Name	Type	Notes
1	client_msg_id	VARCHAR
2	blocks	VARCHAR
3	reply_users	VARCHAR
4	team	VARCHAR
5	type	VARCHAR
6	reply_count	INTEGER
7	float_ts	DOUBLE
8	subscribed	BOOLEAN
9	thread_ts	VARCHAR
10	reply_users_count	DOUBLE
11	text	VARCHAR
12	channel_id	VARCHAR
13	user	VARCHAR
14	ts	VARCHAR
15	latest_reply	VARCHAR

Table: users

No	Column Name	Type	Notes
1	is_ultra_restricted	BOOLEAN
2	color	VARCHAR
3	tz	VARCHAR
4	is_owner	BOOLEAN
5	is_restricted	BOOLEAN
6	has_2fa	BOOLEAN
7	profile	VARCHAR
8	tz_label	VARCHAR
9	is_primary_owner	BOOLEAN
10	real_name	VARCHAR
11	team_id	VARCHAR
12	is_admin	BOOLEAN
13	is_app_user	BOOLEAN
14	deleted	BOOLEAN
15	tz_offset	INTEGER
16	name	VARCHAR
17	id	VARCHAR
18	is_bot	BOOLEAN
19	updated	INTEGER

Table: channel_messages

No	Column Name	Type	Notes
1	attachments	VARCHAR
2	client_msg_id	VARCHAR
3	purpose	VARCHAR
4	upload	BOOLEAN
5	is_intro	BOOLEAN
6	type	VARCHAR
7	float_ts	DOUBLE
8	is_delayed_message	BOOLEAN
9	subscribed	BOOLEAN
10	unread_count	INTEGER
11	subtype	VARCHAR
12	reply_users_count	INTEGER
13	file_ids	VARCHAR
14	inviter	VARCHAR
15	text	VARCHAR
16	display_as_bot	BOOLEAN
17	bot_id	VARCHAR
18	latest_reply	VARCHAR
19	last_read	VARCHAR
20	parent_user_id	VARCHAR
21	blocks	VARCHAR
22	reply_users	VARCHAR
23	team	VARCHAR
24	icons	VARCHAR
25	reply_count	INTEGER
26	user_team	VARCHAR
27	pinned_to	VARCHAR
28	is_starred	BOOLEAN
29	bot_profile	VARCHAR
30	old_name	VARCHAR
31	source_team	VARCHAR
32	thread_ts	VARCHAR
33	file_id	VARCHAR
34	name	VARCHAR
35	topic	VARCHAR
36	reactions	VARCHAR
37	permalink	VARCHAR
38	channel_id	VARCHAR
39	user	VARCHAR
40	ts	VARCHAR
41	username	VARCHAR

External Resources

• Here
• Documentation
• Apps Page
• Channels (conversations)
• Channel Members (conversation Members)
• Messages (conversation History)
• Threads (conversation Replies)
• User Groups
• Files
• Remote Files
• Requests Limitation

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.