Slack

Connect your Slack workspace to your data warehouse. Sync messages, channels, users, and files to BigQuery, Redshift, Postgres, Databricks, and more.

Using the Erathos platform

When selecting Slack as a new connector on the Erathos platform, you will need to name your connection and fill in the following form:

• Token — your Slack Bot User OAuth Token (starts with xoxb-), used to authenticate all requests to the Slack Web API

With this connection created you can seamlessly move your Slack data to your BigQuery, Redshift or Postgres data warehouse.

How to find my token?

To generate a Slack token, go to https://api.slack.com/apps and click Create New App (or select an existing app). Under OAuth & Permissions, add the bot token scopes required by the endpoints you want to sync — for example channels:read, channels:history, groups:read, groups:history, im:read, im:history, mpim:read, mpim:history, users:read, files:read, emoji:read, pins:read, reactions:read, bookmarks:read, reminders:read, dnd:read, search:read, team:read and usergroups:read — then click Install to Workspace (or Reinstall to Workspace).

On the same OAuth & Permissions page, copy the Bot User OAuth Token shown under Tokens for your workspace. It starts with xoxb-.

Paste the token into the Token field on the Erathos platform and click Save and close to complete the setup. Erathos validates the credentials against Slack's auth.test endpoint before saving the connection.

Endpoints and fields

conversations

Sync type availability: Full-refresh

Parent of conversation_members, messages, bookmarks, pins

Field	Type
id	text
name	text
name_normalized	text
is_channel	boolean
is_group	boolean
is_im	boolean
is_mpim	boolean
is_private	boolean
is_archived	boolean
is_shared	boolean
is_org_shared	boolean
is_ext_shared	boolean
is_default_shared	boolean
is_member	boolean
is_pending_ext_shared	boolean
pending_shared	json
pending_connected_team_ids	json
unlinked	integer
num_members	integer
priority	integer
user	text
created	timestamp
creator	text
topic	json
purpose	json
previous_names	json
locale	text
conversation_host_id	text

conversation_members

Sync type availability: Full-refresh

Child of conversations

Field	Type
user_id	text

messages

Sync type availability: Full and incremental refresh

Cursor: ts

Child of conversations

Parent of thread_replies

Field	Type	Cursor
type	text
subtype	text
text	text
user	text
ts	timestamp	✓
thread_ts	timestamp
reply_count	integer
reply_users	json
reply_users_count	integer
latest_reply	timestamp
blocks	json
attachments	json
reactions	json
edited	json
permalink	text
is_locked	boolean
subscribed	boolean
bot_id	text
app_id	text
files	json
upload	boolean
display_as_bot	boolean
client_msg_id	text
hidden	boolean

thread_replies

Sync type availability: Full and incremental refresh

Cursor: ts

Child of messages

Field	Type	Cursor
type	text
subtype	text
text	text
user	text
ts	timestamp	✓
thread_ts	timestamp
parent_user_id	text
reply_count	integer
reply_users	json
reply_users_count	integer
latest_reply	timestamp
blocks	json
attachments	json
reactions	json
edited	json
is_locked	boolean
subscribed	boolean
permalink	text

bookmarks

Sync type availability: Full-refresh

Child of conversations

Field	Type
id	text
channel_id	text
date_created	timestamp
date_updated	timestamp
type	text
title	text
link	text
user_id	text
last_updated_by_user_id	text

pins

Sync type availability: Full-refresh

Child of conversations

Field	Type
type	text
channel	text
created	timestamp
created_by	text
message	json
file	json
comment	json

conversation_connect_invites

Sync type availability: Full-refresh

Field	Type
id	text
date_created	timestamp
date_expires	timestamp
inviting_team_id	text
inviting_channel	json
invite_type	text
recipient_user_id	text

conversation_connect_invite_requests

Sync type availability: Full-refresh

Field	Type
id	text
date_created	timestamp
date_expires	timestamp
date_denied	timestamp
date_last_updated	timestamp
status	text
requesting_user_id	text
requesting_team_id	text
recipient_channel_id	text
channel_names_to_approve	json

users

Sync type availability: Full-refresh

Parent of users_get_presence

Field	Type
id	text
team_id	text
name	text
deleted	boolean
color	text
real_name	text
tz	text
tz_label	text
tz_offset	integer
profile	json
is_admin	boolean
is_owner	boolean
is_primary_owner	boolean
is_restricted	boolean
is_ultra_restricted	boolean
is_bot	boolean
is_app_user	boolean
is_email_confirmed	boolean
updated	timestamp
who_can_share_contact_card	text
Favorite programming language	text
Start date	date

In addition to the fields above, workspace-specific custom profile fields (defined in Slack and listed in the users_profile_fields endpoint) are appended to this table.

users_get_presence

Sync type availability: Full-refresh

Child of users

Field	Type
presence	text
online	boolean
auto_away	boolean
manual_away	boolean
connection_count	integer
last_activity	timestamp

users_conversations

Sync type availability: Full-refresh

Field	Type
id	text
name	text
name_normalized	text
is_channel	boolean
is_group	boolean
is_im	boolean
is_mpim	boolean
is_private	boolean
is_archived	boolean
is_shared	boolean
is_org_shared	boolean
is_ext_shared	boolean
is_default_shared	boolean
is_member	boolean
is_pending_ext_shared	boolean
pending_shared	json
pending_connected_team_ids	json
unlinked	integer
num_members	integer
priority	integer
user	text
created	timestamp
creator	text
topic	json
purpose	json
previous_names	json
locale	text
conversation_host_id	text

users_profile_fields

Sync type availability: Full-refresh

Field	Type
id	text
team_id	text
ordering	integer
label	text
hint	text
type	text
possible_values	json
is_hidden	boolean
is_protected	boolean
is_global	boolean

files

Sync type availability: Full and incremental refresh

Cursor: created

Parent of file_comments

Field	Type	Cursor
id	text
created	timestamp	✓
timestamp	timestamp
name	text
title	text
mimetype	text
filetype	text
pretty_type	text
user	text
user_team	text
editable	boolean
size	integer
mode	text
is_external	boolean
external_type	text
is_public	boolean
public_url_shared	boolean
display_as_bot	boolean
url_private	text
url_private_download	text
permalink	text
comments_count	integer
shares	json
channels	json
groups	json
ims	json
has_rich_preview	boolean
file_access	text

file_comments

Sync type availability: Full-refresh

Child of files

Field	Type
id	text
created	timestamp
timestamp	timestamp
user	text
comment	text
is_intro	boolean
reactions	json

files_remote

Sync type availability: Full and incremental refresh

Cursor: created

Field	Type	Cursor
id	text
created	timestamp	✓
timestamp	timestamp
name	text
title	text
mimetype	text
filetype	text
pretty_type	text
user	text
url	text
permalink	text
is_external	boolean
external_type	text
app_id	text
app_name	text
size	integer

usergroups

Sync type availability: Full-refresh

Parent of usergroup_members

Field	Type
id	text
team_id	text
name	text
description	text
handle	text
is_external	boolean
date_create	timestamp
date_update	timestamp
date_delete	timestamp
auto_type	text
enterprise_subteam_id	text
created_by	text
updated_by	text
deleted_by	text
prefs	json
user_count	integer

usergroup_members

Sync type availability: Full-refresh

Child of usergroups

Field	Type
user_id	text

team_info

Sync type availability: Full-refresh

Field	Type
id	text
name	text
url	text
domain	text
email_domain	text
icon	json
avatar_base_url	text
is_verified	boolean
enterprise_id	text
enterprise_name	text

auth_teams

Sync type availability: Full-refresh

Field	Type
id	text
name	text
url	text
domain	text
avatar_base_url	text
is_verified	boolean
enterprise_id	text
icon	json

team_preferences

Sync type availability: Full-refresh

Field	Type
allow_message_deletion	boolean
disable_file_editing	boolean
disable_file_pasting	boolean
display_real_names	boolean
log_to_channels	boolean
who_can_manage_integrations	json
who_can_manage_channels	json
default_channels	json

team_billable_info

Sync type availability: Full-refresh

Field	Type
user_id	text
billable	boolean

team_access_logs

Sync type availability: Full-refresh

Field	Type
user_id	text
username	text
date_first	timestamp
date_last	timestamp
count	integer
ip	text
user_agent	text
isp	text
country	text
region	text

team_integration_logs

Sync type availability: Full-refresh

Field	Type
user_id	text
user_name	text
service_id	integer
service_type	text
date	timestamp
change_type	text
app_type	text
app_id	text
scope	text
channel	text
rss_feed	json

team_external_teams

Sync type availability: Full-refresh

Field	Type
id	text
name	text
url	text
domain	text
avatar_base_url	text
is_verified	boolean
date_created	timestamp
date_updated	timestamp

apps_activities

Sync type availability: Full and incremental refresh

Cursor: created

Field	Type	Cursor
id	text
app_id	text
team_id	text
user_id	text
created	timestamp	✓
entity_type	text
entity_id	text
event_type	text
source	json

apps_event_authorizations

Sync type availability: Full-refresh

Field	Type
enterprise_id	text
team_id	text
user_id	text
is_bot	boolean
is_enterprise_install	boolean

apps_datastore_query

Sync type availability: Full-refresh

Field	Type
id	text
created	timestamp
updated	timestamp
name	text

emoji

Sync type availability: Full-refresh

Field	Type
name	text
url	text

reactions

Sync type availability: Full-refresh

Field	Type
type	text
channel	text
user	text
message	json
file	json
comment	json

stars

Sync type availability: Full-refresh

Field	Type
type	text
channel	text
date_create	timestamp
message	json
file	json
comment	json

reminders

Sync type availability: Full-refresh

Field	Type
id	text
creator	text
user	text
text	text
recurring	boolean
time	timestamp
complete_ts	timestamp

scheduled_messages

Sync type availability: Full and incremental refresh

Cursor: post_at

Field	Type	Cursor
id	text
channel_id	text
text	text
post_at	timestamp	✓
date_created	timestamp
thread_ts	timestamp

search_messages

Sync type availability: Full-refresh

Field	Type
score	float
type	text
user	text
ts	timestamp
text	text
permalink	text
channel	json
attachments	json
blocks	json
no_reactions	boolean

search_files

Sync type availability: Full-refresh

Field	Type
score	float
id	text
created	timestamp
timestamp	timestamp
name	text
title	text
mimetype	text
filetype	text
pretty_type	text
user	text
size	integer
mode	text
is_external	boolean
external_type	text
is_public	boolean
permalink	text
channels	json
groups	json
ims	json

search_all

Sync type availability: Full-refresh

Field	Type
score	float
type	text
user	text
ts	timestamp
text	text
permalink	text
channel	json
attachments	json
blocks	json
no_reactions	boolean

assistant_search_context

Sync type availability: Full-refresh

Field	Type
query	text
messages	json
files	json
channels	json
users	json

list_items

Sync type availability: Full-refresh

Field	Type
id	text
list_id	text
date_created	timestamp
created_by	text
date_updated	timestamp
updated_by	text
archived	boolean
fields	json

workflows_featured

Sync type availability: Full-refresh

Field	Type
id	text
name	text
date_created	timestamp
date_updated	timestamp
channel_ids	json

functions_workflows_steps

Sync type availability: Full-refresh

Field	Type
step_id	text
version	text
inputs	json
outputs	json

dnd_team_info

Sync type availability: Full-refresh

Field	Type
user_id	text
dnd_enabled	boolean
next_dnd_start_ts	timestamp
next_dnd_end_ts	timestamp

Entity Relationships