Slack 이 페이지에서
Slack is a cloud-based team communication platform.
Slack integration replicates data from a single Slack workspace using the Slack Web API . To replicate data from multiple workspaces, create an additional Slack integration for each workspace.
See the
Schema section for a list of objects available for replication.
기능 스냅샷 유용한 링크와 지원되는 기능을 포함하여 이 커넥터에 대한 전반적인 내용을 살펴보겠습니다.
특징/기능 지원 세부 정보 지원되는 Qlik Talend Data Integration 프로젝트 복제 프로젝트 에만 해당됩니다. 데이터 파이프라인 프로젝트는 지원되지 않습니다.대상 업데이트 방법
복제 작업:
데이터 레이크 작업에 데이터 랜딩:
메타데이터 관리
수동 메타데이터 생성이 필요하지 않습니다. 스키마 진화
열 데이터 유형 변경 작업만 지원됩니다. LOB 열(NCLOB, CLOB 및 BLOB) 복제 지원되지 않음. 예정된 CDC 필수. 이렇게 하면 소스의 변경 내용이 대상에 최신 상태로 유지됩니다.
복제 작업의 경우 작업 예약
레이크 랜딩 작업의 경우 레이크 랜딩 작업을 위한 CDC 일정
알림 부분적으로 지원됨
작업 변경 알림 설정
모니터링 중 CDC에만 해당되며, 이 커넥터의 경우 전체 로드가 적용되지 않습니다.
개별 데이터 작업 모니터링
JSON 열 페이로드의 자동 압축 해제 지원되지 않음. 소스 데이터 집합의 JSON 열 페이로드는 대상에서 자동으로 압축 해제되지 않습니다.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
정보 메모 사용하는 계정에 가져오려는 테이블에 대한 읽기 액세스 권한이 있는지 확인합니다.
Qlik Talend Cloud supports data replication from one Slack workspace per connection. To replicate data from multiple workspaces, set up a separate Slack connection for each workspace in Qlik Talend Cloud , using a unique OAuth token for every connection.
To retrieve your token:
Navigate to the Slack App site . Click Create an App . Enter a name for the app and select the workspace you want to replicate data from. Click Create App . Once your app is created, select it and navigate to Features > OAuth & Permissions . Scroll to the Scopes section. In the Bot Token Scopes section, click Add an OAuth Scope . In the field that appears, search for the following scopes:
channels:historychannels:joinchannels:readfiles:readgroups:readlinks:readreactions:readremote_files:readremote_files:writeteam:readuseergroups:readusers.profile:readusers:readusers:read.emailAfter the required scopes are added to the app, you need to install it to your Slack workspace. If you do not have the required permissions to install apps, you may need Workspace Owner approval. See Slack's documentation for app installation requirements.
Scroll up to the OAuth Tokens & Redirect URLs section of the OAuth & Permissions page. In this section, click Install App to Workspace . Complete the steps that follow to install the app or submit a request to your Workspace Owner for approval.
Result: Once the app is installed in your workspace, a Tokens for Your Workspace section containing a Bot User OAuth Access Token field is displayed.
Copy and paste your token into a secured file. Creating the connection 자세한 내용은 SaaS 응용 프로그램에 연결
필요한 연결 속성을 입력합니다. 연결 이름 에 연결 이름을 입력합니다.
연결이 만들어질 때 연결에 대한 메타데이터를 정의하려면 연결 메타데이터 열기 를 선택합니다.
만들기 를 클릭합니다.
Connection settings Setting Description Data gateway
사용 사례에 필요한 경우 데이터 이동 게이트웨이 를 선택합니다.
정보 메모 이 필드는 데이터 이동 게이트웨이 를 지원하지 않으므로 Qlik Talend Cloud 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이 를 사용하지 않으려면 없음 을 선택합니다.
데이터 이동 게이트웨이 의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 Qlik 데이터 게이트웨이 - 데이터 이동
Start Date Enter the date, in the format MM/DD/YYYY, from which the data must be replicated from your source to your target. Token Token. Join Public Channels Select the check box to replicate data for all public channels in the workspace you are connecting. Include Private Channels Select the check box to include data from private channels. Exclude Archived Channels Select the check box to exclude data from archived channels.
정보 메모 Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 1.
Depending on your destination, table and column names may not appear as they are outlined below.
channel_members
The channel_members table contain info about members of channels in your Slack workspace. Channels include conversations, channels, and direct messages in your Slack workspace.
channel_members table foreign keys Join channel_members with on channels channel_members.channel_id = channels.id channel_members.user_id = channels.creator channel_members.user_id = channels.members files channel_members.channel_id = files.channels channel_members.channel_id = files.pinned_to channel_members.user_id = files.user messages channel_members.channel_id = messages.channel_id channel_members.channel_id = messages.pinned_to channel_members.user_id = messages.reply_users channel_members.user_id = messages.reactions.users channel_members.user_id = messages.user remote_files channel_members.channel_id = remote_files.channels channel_members.channel_id = remote_files.pinned_to channel_members.user_id = remote_files.user threads channel_members.channel_id = threads.channel_id channel_members.user_id = threads.user channel_members.user_id = threads.reply_users user_groups channel_members.user_id = user_groups.members channel_members.user_id = user_groups.purpose.creator channel_members.user_id = user_groups.topic.creator users channel_members.user_id = users.id
channel_members table schema
channel_id
STRING
user_id
STRING
channels
The channels table contains info about the channels in your Slack workspace. This includes conversations, channels, and direct messages.
정보 메모 Some types of channels - for example, private or archived channels - will be replicated only if the appropriate settings are configured in the integration’s settings. Refer to the Slack
setup steps for more info.
channels table foreign keys Join channels with on channel_members channels.id = channel_members.channel_id channels.creator = channel_members.user_id channels.members = channel_members.user_id files channels.id = files.channels channels.id = files.pinned_to channels.pending_connected_team_ids = files.source_team channels.pending_connected_team_ids = files.user_team channels.creator = files.user channels.members = files.user messages channels.id = messages.channel_id channels.id = messages.pinned_to channels.pending_connected_team_ids = messages.bot_profile.team_id channels.pending_connected_team_ids = messages.team channels.pending_connected_team_ids = messages.source_team channels.pending_connected_team_ids = messages.user_team channels.creator = messages.reply_users channels.members = messages.reply_users channels.creator = messages.reactions.users channels.members = messages.reactions.users channels.creator = messages.user channels.members = messages.user remote_files channels.id = remote_files.channels channels.id = remote_files.pinned_to channels.pending_connected_team_ids = remote_files.source_team channels.pending_connected_team_ids = remote_files.user_team channels.creator = remote_files.user channels.members = remote_files.user threads channels.id = threads.channel_id channels.pending_connected_team_ids = threads.team channels.creator = threads.user channels.members = threads.user channels.creator = threads.reply_users channels.members = threads.reply_users teams channels.pending_connected_team_ids = teams.id users channels.pending_connected_team_ids = users.team_id channels.creator = users.id channels.members = users.id user_groups channels.creator = user_groups.members channels.members = user_groups.members channels.creator = user_groups.purpose.creator channels.members = user_groups.purpose.creator channels.creator = user_groups.topic.creator channels.members = user_groups.topic.creator
channels table schema
channel_id
STRING
created
DATE-TIME
creator
STRING
id
STRING
is_archived
BOOLEAN
is_channel
BOOLEAN
is_ext_shared
BOOLEAN
is_general
BOOLEAN
is_group
BOOLEAN
is_im
BOOLEAN
is_member
BOOLEAN
is_mpim
BOOLEAN
is_org_shared
BOOLEAN
is_pending_ext_shared
BOOLEAN
is_private
BOOLEAN
is_shared
BOOLEAN
members
ARRAY
This is a nested data structure.
name
STRING
name_normalized
STRING
num_members
INTEGER
parent_conversation
STRING
pending_connected_team_ids
ARRAY
This is a nested data structure.
pending_shared
ARRAY
This is a nested data structure.
previous_names
ARRAY
This is a nested data structure.
purpose
OBJECT
This is a nested data structure:
creator: STRING last_set: DATE-TIME value: STRING
shared_team_ids
ARRAY
This is a nested data structure.
topic
OBJECT
This is a nested data structure:
creator: STRING last_set: DATE-TIME value: STRING
unlinked
DATE-TIME
files
The files table contains info about Slack team files.
files table foreign keys Join files with on channels files.channels = channels.id files.pinned_to = channels.id files.source_team = channels.pending_connected_team_ids files.user_team = channels.pending_connected_team_ids files.user = channels.creator files.user = channels.members channel_members files.channels = channel_members.channel_id files.pinned_to = channel_members.channel_id files.user = channel_members.user_id messages files.channels = messages.channel_id files.pinned_to = messages.channel_id files.channels = messages.pinned_to files.pinned_to = messages.pinned_to files.id = messages.file_ids files.source_team = messages.bot_profile.team_id files.user_team = messages.bot_profile.team_id files.source_team = messages.team files.user_team = messages.team files.source_team = messages.source_team files.user_team = messages.source_team files.source_team = messages.user_team files.user_team = messages.user_team files.user = messages.reply_users files.user = messages.reactions.users files.user = messages.user remote_files files.channels = remote_files.channels files.pinned_to = remote_files.channels files.channels = remote_files.pinned_to files.pinned_to = remote_files.pinned_to files.groups = remote_files.groups files.source_team = remote_files.source_team files.user_team = remote_files.source_team files.source_team = remote_files.user_team files.user_team = remote_files.user_team files.user = remote_files.user threads files.channels = threads.channel_id files.pinned_to = threads.channel_id files.source_team = threads.team files.user_team = threads.team files.user = threads.user files.user = threads.reply_users user_groups files.groups = user_groups.id files.groups = user_groups.parent_group files.user = user_groups.members files.user = user_groups.purpose.creator files.user = user_groups.topic.creator teams files.source_team = teams.id files.user_team = teams.id users files.source_team = users.team_id files.user_team = users.team_id files.user = users.id
files table schema
channels
ARRAY
This is a nested data structure.
comments_count
INTEGER
created
DATE-TIME
date_delete
DATE-TIME
display_as_bot
BOOLEAN
editable
BOOLEAN
editor
STRING
external_id
STRING
external_type
STRING
external_url
STRING
filetype
STRING
groups
ARRAY
This is a nested data structure.
has_rich_preview
BOOLEAN
id
STRING
image_exif_rotation
INTEGER
ims
ARRAY
This is a nested data structure.
is_external
BOOLEAN
is_public
BOOLEAN
is_starred
BOOLEAN
is_tombstoned
BOOLEAN
last_editor
STRING
mimetype
STRING
mode
STRING
name
STRING
non_owner_editable
BOOLEAN
num_stars
INTEGER
original_h
INTEGER
original_w
INTEGER
permalink
STRING
permalink_public
STRING
pinned_info
OBJECT
This is a nested data structure.
pinned_to
ARRAY
This is a nested data structure.
pretty_type
STRING
preview
STRING
public_url_shared
BOOLEAN
size
INTEGER
source_team
STRING
state
STRING
thumb_1024
STRING
thumb_1024_h
INTEGER
thumb_1024_w
INTEGER
thumb_160
STRING
thumb_360
STRING
thumb_360_h
INTEGER
thumb_360_w
INTEGER
thumb_480
STRING
thumb_480_h
INTEGER
thumb_480_w
INTEGER
thumb_64
STRING
thumb_720
STRING
thumb_720_h
INTEGER
thumb_720_w
INTEGER
thumb_80
STRING
thumb_800
STRING
thumb_800_h
INTEGER
thumb_800_w
INTEGER
thumb_960
STRING
thumb_960_h
INTEGER
thumb_960_w
INTEGER
thumb_tiny
STRING
timestamp
DATE-TIME
title
STRING
updated
DATE-TIME
url_private
STRING
url_private_download
STRING
user
STRING
user_team
STRING
username
STRING
messages
The messages table contains the history of messages and events in conversations in your Slack workspace.
messages table foreign keys Join messages with on channels messages.channel_id = channels.id messages.pinned_to = channels.id messages.bot_profile.team_id = channels.pending_connected_team_ids messages.team = channels.pending_connected_team_ids messages.source_team = channels.pending_connected_team_ids messages.user_team = channels.pending_connected_team_ids messages.reply_users = channels.creator messages.reactions.users = channels.creator messages.user = channels.creator messages.reply_users = channels.members messages.reactions.users = channels.members messages.user = channels.members channel_members messages.channel_id = channel_members.channel_id messages.pinned_to = channel_members.channel_id messages.reply_users = channel_members.user_id messages.reactions.users = channel_members.user_id messages.user = channel_members.user_id files messages.channel_id = files.channels messages.pinned_to = files.channels messages.channel_id = files.pinned_to messages.pinned_to = files.pinned_to messages.file_ids = files.id messages.bot_profile.team_id = files.source_team messages.team = files.source_team messages.source_team = files.source_team messages.user_team = files.source_team messages.bot_profile.team_id = files.user_team messages.team = files.user_team messages.source_team = files.user_team messages.user_team = files.user_team messages.reply_users = files.user messages.reactions.users = files.user messages.user = files.user remote_files messages.channel_id = remote_files.channels messages.pinned_to = remote_files.channels messages.channel_id = remote_files.pinned_to messages.pinned_to = remote_files.pinned_to messages.bot_profile.team_id = remote_files.source_team messages.team = remote_files.source_team messages.source_team = remote_files.source_team messages.user_team = remote_files.source_team messages.bot_profile.team_id = remote_files.user_team messages.team = remote_files.user_team messages.source_team = remote_files.user_team messages.user_team = remote_files.user_team messages.reply_users = remote_files.user messages.reactions.users = remote_files.user messages.user = remote_files.user threads messages.channel_id = threads.channel_id messages.pinned_to = threads.channel_id messages.bot_profile.team_id = threads.team messages.team = threads.team messages.source_team = threads.team messages.user_team = threads.team messages.reply_users = threads.user messages.reactions.users = threads.user messages.user = threads.user messages.reply_users = threads.reply_users messages.reactions.users = threads.reply_users messages.user = threads.reply_users teams messages.bot_profile.team_id = teams.id messages.team = teams.id messages.source_team = teams.id messages.user_team = teams.id users messages.bot_profile.team_id = users.team_id messages.team = users.team_id messages.source_team = users.team_id messages.user_team = users.team_id messages.reply_users = users.id messages.reactions.users = users.id messages.user = users.id user_groups messages.reply_users = user_groups.members messages.reactions.users = user_groups.members messages.user = user_groups.members messages.reply_users = user_groups.purpose.creator messages.reactions.users = user_groups.purpose.creator messages.user = user_groups.purpose.creator messages.reply_users = user_groups.topic.creator messages.reactions.users = user_groups.topic.creator messages.user = user_groups.topic.creator
messages table schema
blocks
ARRAY
This is a nested data structure:
bot_id
STRING
bot_profile
OBJECT
This is a nested data structure:
app_id: STRING deleted: BOOLEAN id: STRING name: STRING team_id: STRING updated: DATE-TIME
channel_id
STRING
client_msg_id
STRING
display_as_bot
BOOLEAN
file_id
STRING
file_ids
ARRAY
This is a nested data structure.
icons
OBJECT
This is a nested data structure:
inviter
STRING
is_delayed_message
BOOLEAN
is_intro
BOOLEAN
is_starred
BOOLEAN
last_read
DATE-TIME
latest_reply
STRING
name
STRING
old_name
STRING
parent_user_id
STRING
permalink
STRING
pinned_to
ARRAY
This is a nested data structure.
purpose
STRING
reactions
ARRAY
This is a nested data structure:
count: INTEGER name: STRING users: ARRAY, which is also a nested data structure.
reply_count
INTEGER
reply_users
ARRAY
This is a nested data structure.
reply_users_count
INTEGER
source_team
STRING
subscribed
BOOLEAN
subtype
STRING
team
STRING
text
STRING
thread_ts
STRING
topic
STRING
ts
DATE-TIME
type
STRING
unread_count
INTEGER
upload
BOOLEAN
user
STRING
user_team
STRING
username
STRING
remote_files
The remote_files table contains info about remote files added to Slack.
Replication Method
CDC
Primary Key
id
Replication Key
updated
Useful links
Slack API method
remote_files table foreign keys Join remote_files with on channels remote_files.channels = channels.id remote_files.pinned_to = channels.id remote_files.source_team = channels.pending_connected_team_ids remote_files.user_team = channels.pending_connected_team_ids remote_files.user = channels.creator remote_files.user = channels.members channel_members remote_files.channels = channel_members.channel_id remote_files.pinned_to = channel_members.channel_id remote_files.user = channel_members.user_id files remote_files.channels = files.channels remote_files.pinned_to = files.channels remote_files.channels = files.pinned_to remote_files.pinned_to = files.pinned_to remote_files.groups = files.groups remote_files.source_team = files.source_team remote_files.user_team = files.source_team remote_files.source_team = files.user_team remote_files.user_team = files.user_team remote_files.user = files.user messages remote_files.channels = messages.channel_id remote_files.pinned_to = messages.channel_id remote_files.channels = messages.pinned_to remote_files.pinned_to = messages.pinned_to remote_files.source_team = messages.bot_profile.team_id remote_files.user_team = messages.bot_profile.team_id remote_files.source_team = messages.team remote_files.user_team = messages.team remote_files.source_team = messages.source_team remote_files.user_team = messages.source_team remote_files.source_team = messages.user_team remote_files.user_team = messages.user_team remote_files.user = messages.reply_users remote_files.user = messages.reactions.users remote_files.user = messages.user threads remote_files.channels = threads.channel_id remote_files.pinned_to = threads.channel_id remote_files.source_team = threads.team remote_files.user_team = threads.team remote_files.user = threads.user remote_files.user = threads.reply_users user_groups remote_files.groups = user_groups.id remote_files.groups = user_groups.parent_group remote_files.user = user_groups.members remote_files.user = user_groups.purpose.creator remote_files.user = user_groups.topic.creator teams remote_files.source_team = teams.id remote_files.user_team = teams.id users remote_files.source_team = users.team_id remote_files.user_team = users.team_id remote_files.user = users.id
remote_files table schema
channels
ARRAY
This is a nested data structure.
comments_count
INTEGER
created
DATE-TIME
date_delete
DATE-TIME
display_as_bot
BOOLEAN
editable
BOOLEAN
editor
STRING
external_id
STRING
external_type
STRING
external_url
STRING
filetype
STRING
groups
ARRAY
This is a nested data structure.
has_rich_preview
BOOLEAN
id
STRING
image_exif_rotation
INTEGER
ims
ARRAY
This is a nested data structure.
is_external
BOOLEAN
is_public
BOOLEAN
is_starred
BOOLEAN
is_tombstoned
BOOLEAN
last_editor
STRING
mimetype
STRING
mode
STRING
name
STRING
non_owner_editable
BOOLEAN
num_stars
INTEGER
original_h
INTEGER
original_w
INTEGER
permalink
STRING
permalink_public
STRING
pinned_info
OBJECT
This is a nested data structure.
pinned_to
ARRAY
This is a nested data structure.
pretty_type
STRING
preview
STRING
public_url_shared
BOOLEAN
size
INTEGER
source_team
STRING
state
STRING
thumb_1024
STRING
thumb_1024_h
INTEGER
thumb_1024_w
INTEGER
thumb_160
STRING
thumb_360
STRING
thumb_360_h
INTEGER
thumb_360_w
INTEGER
thumb_480
STRING
thumb_480_h
INTEGER
thumb_480_w
INTEGER
thumb_64
STRING
thumb_720
STRING
thumb_720_h
INTEGER
thumb_720_w
INTEGER
thumb_80
STRING
thumb_800
STRING
thumb_800_h
INTEGER
thumb_800_w
INTEGER
thumb_960
STRING
thumb_960_h
INTEGER
thumb_960_w
INTEGER
thumb_tiny
STRING
timestamp
DATE-TIME
title
STRING
updated
DATE-TIME
url_private
STRING
url_private_download
STRING
user
STRING
user_team
STRING
username
STRING
teams
The teams table contains info about teams in your Slack workspace.
teams table foreign keys Join teams with on channels teams.id = channels.pending_connected_team_ids files teams.id = files.source_team teams.id = files.user_team messages teams.id = messages.bot_profile.team_id teams.id = messages.team teams.id = messages.source_team teams.id = messages.user_team remote_files teams.id = remote_files.source_team teams.id = remote_files.user_team threads teams.id = threads.team users teams.id = users.team_id
teams table schema
archived
BOOLEAN
avatar_base_url
STRING
created
DATE-TIME
date_create
DATE-TIME
deleted
DATE-TIME
description
STRING
discoverable
STRING
domain
STRING
email_domain
STRING
enterprise_id
STRING
enterprise_name
STRING
has_compliance_export
BOOLEAN
icon
OBJECT
This is a nested data structure:
image_102: STRING image_132: STRING image_230: STRING image_34: STRING image_44: STRING image_68: STRING image_88: STRING image_default: BOOLEAN
id
STRING
is_assigned
BOOLEAN
is_enterprise
INTEGER
messages_count
INTEGER
msg_edit_window_mins
INTEGER
name
STRING
over_integrations_limit
BOOLEAN
over_storage_limit
BOOLEAN
plan
STRING
threads
The threads table contains info about conversation threads in your Slack team.
정보 메모 While this table uses Full Table, it’s not truly replicated in full during each replication job. Each time a message in a thread is updated, the entire thread and all the messages it contains will be replicated in full. This means that while only updated threads are replicated, they are replicated in full whenever they’re updated.
threads table foreign keys Join threads with on channels threads.channel_id = channels.id threads.team = channels.pending_connected_team_ids threads.user = channels.creator threads.reply_users = channels.creator threads.user = channels.members threads.reply_users = channels.members channel_members threads.channel_id = channel_members.channel_id threads.user = channel_members.user_id threads.reply_users = channel_members.user_id files threads.channel_id = files.channels threads.channel_id = files.pinned_to threads.team = files.source_team threads.team = files.user_team threads.user = files.user threads.reply_users = files.user messages threads.channel_id = messages.channel_id threads.channel_id = messages.pinned_to threads.team = messages.bot_profile.team_id threads.team = messages.team threads.team = messages.source_team threads.team = messages.user_team threads.user = messages.reply_users threads.reply_users = messages.reply_users threads.user = messages.reactions.users threads.reply_users = messages.reactions.users threads.user = messages.user threads.reply_users = messages.user remote_files threads.channel_id = remote_files.channels threads.channel_id = remote_files.pinned_to threads.team = remote_files.source_team threads.team = remote_files.user_team threads.user = remote_files.user threads.reply_users = remote_files.user teams threads.team = teams.id users threads.team = users.team_id threads.user = users.id threads.reply_users = users.id user_groups threads.user = user_groups.members threads.reply_users = user_groups.members threads.user = user_groups.purpose.creator threads.reply_users = user_groups.purpose.creator threads.user = user_groups.topic.creator threads.reply_users = user_groups.topic.creator
threads table schema
blocks
ARRAY
This is a nested data structure:
channel_id
STRING
client_msg_id
STRING
latest_reply
STRING
reply_count
INTEGER
reply_users
ARRAY
This is a nested data structure.
reply_users_count
NUMBER
subscribed
BOOLEAN
team
STRING
text
STRING
thread_ts
STRING
ts
DATE-TIME
type
STRING
user
STRING
user_groups
The user_groups table contains info about user groups from your Slack team.
user_groups table foreign keys Join user_groups with on files user_groups.id = files.groups user_groups.parent_group = files.groups user_groups.members = files.user user_groups.purpose.creator = files.user user_groups.topic.creator = files.user remote_files user_groups.id = remote_files.groups user_groups.parent_group = remote_files.groups user_groups.members = remote_files.user user_groups.purpose.creator = remote_files.user user_groups.topic.creator = remote_files.user channel_members user_groups.members = channel_members.user_id user_groups.purpose.creator = channel_members.user_id user_groups.topic.creator = channel_members.user_id channels user_groups.members = channels.creator user_groups.purpose.creator = channels.creator user_groups.topic.creator = channels.creator user_groups.members = channels.members user_groups.purpose.creator = channels.members user_groups.topic.creator = channels.members messages user_groups.members = messages.reply_users user_groups.purpose.creator = messages.reply_users user_groups.topic.creator = messages.reply_users user_groups.members = messages.reactions.users user_groups.purpose.creator = messages.reactions.users user_groups.topic.creator = messages.reactions.users user_groups.members = messages.user user_groups.purpose.creator = messages.user user_groups.topic.creator = messages.user threads user_groups.members = threads.user user_groups.purpose.creator = threads.user user_groups.topic.creator = threads.user user_groups.members = threads.reply_users user_groups.purpose.creator = threads.reply_users user_groups.topic.creator = threads.reply_users users user_groups.members = users.id user_groups.purpose.creator = users.id user_groups.topic.creator = users.id
user_groups table schema
created
DATE-TIME
creator
STRING
id
STRING
is_archived
BOOLEAN
is_deleted
BOOLEAN
is_group
BOOLEAN
is_moved
INTEGER
is_mpim
BOOLEAN
is_open
BOOLEAN
is_pending_ext_shared
BOOLEAN
is_read_only
BOOLEAN
is_thread_only
BOOLEAN
last_read
DATE-TIME
members
ARRAY
This is a nested data structure.
name
STRING
name_normalized
STRING
num_members
INTEGER
parent_group
STRING
priority
NUMBER
purpose
OBJECT
This is a nested data structure:
creator: STRING last_set: INTEGER value: STRING
topic
OBJECT
This is a nested data structure:
creator: STRING last_set: INTEGER value: STRING
unread_count
INTEGER
unread_count_display
INTEGER
users
The users table lists contains info about the users in your Slack team. This includes deactivated and deleted users.
Replication Method
CDC
Primary Key
id
Replication Key
updated
Useful links
Slack API method
users table foreign keys Join users with on channels users.team_id = channels.pending_connected_team_ids users.id = channels.creator users.id = channels.members files users.team_id = files.source_team users.team_id = files.user_team users.id = files.user messages users.team_id = messages.bot_profile.team_id users.team_id = messages.team users.team_id = messages.source_team users.team_id = messages.user_team users.id = messages.reply_users users.id = messages.reactions.users users.id = messages.user remote_files users.team_id = remote_files.source_team users.team_id = remote_files.user_team users.id = remote_files.user teams users.team_id = teams.id threads users.team_id = threads.team users.id = threads.user users.id = threads.reply_users channel_members users.id = channel_members.user_id user_groups users.id = user_groups.members users.id = user_groups.purpose.creator users.id = user_groups.topic.creator
users table schema
color
STRING
deleted
BOOLEAN
has_2fa
BOOLEAN
id
STRING
is_admin
BOOLEAN
is_app_user
BOOLEAN
is_bot
BOOLEAN
is_owner
BOOLEAN
is_primary_owner
BOOLEAN
is_restricted
BOOLEAN
is_ultra_restricted
BOOLEAN
name
STRING
profile
OBJECT
This is a nested data structure:
real_name
STRING
team_id
STRING
tz
STRING
tz_label
STRING
tz_offset
INTEGER
updated
DATE-TIME
