Slack Source PluginLatest: v1.1.3
The CloudQuery Slack plugin extracts information from your Slack organization(s) and loads it into any supported CloudQuery destination (e.g. PostgreSQL).
Install a custom Slack app with read-only permissions into your workspace by clicking the button below and following the instructions:
Once installed into the workspace, go to Install App (under Settings) and copy the Bot User OAuth Token. You will need this in your source config in the next step.
Set up a CloudQuery source config. See Configuration for an example and available options.
If this is your first time running CloudQuery, check out the Quickstart page for help on setting up a destination and running your first sync.
That's it, happy querying!
The Slack source plugin supports syncing of message histories, but only for channels that the bot is added to. If you would like to sync the messages and threads in a channel, add the CloudQuery bot that you installed in Step 1 to the channel before running a sync, and make sure that the
slack_conversation_histories table is included in the tables list in your Slack plugin source config.
select id, name from slack_users where deleted is not true;
select u.name, count(h.user) from slack_conversation_histories h join slack_conversation_replies r on h.ts = r.conversation_history_ts join slack_users u on u.id = h.user group by u.name order by count desc;
select title, link from slack_conversation_bookmarks;
select title, url_private from slack_files;
select title, url_private from slack_files where is_external is true;