Installation #

Configuration #

kind: source
# Common source-plugin configuration
spec:
  name: slack
  path: cloudquery/slack
  registry: cloudquery
  version: "v4.7.4"
  tables: ["*"]
  destinations: ["postgresql"]

  # Slack specific configuration
  # Learn more about the configuration options at https://cql.ink/slack_source
  spec:
    # required
    token: "${SLACK_API_TOKEN}"

Slack Spec #

• token (string) (required)

  An API token to access Slack resources. This can be obtained by creating a Slack app.
• concurrency (integer, optional, default: 10000) A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.
• scheduler (string, optional, default: dfs) The scheduler to use when determining the priority of resources to sync. Supported values are dfs (depth-first search), round-robin, shuffle and shuffle-queue.

  For more information about this, see performance tuning.
• debug (boolean) (optional) (default: false)

  Turn on to activate debug logging from the Slack SDK.

Syncing message histories #

Example Queries #

List all active users in the Slack workspace #

select id, name from slack_users where deleted is not true;

Rank users by number of messages sent in public channels #

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;

List all bookmarks #

select title, link from slack_conversation_bookmarks;

List URLs to all uploaded files #

select title, url_private from slack_files;

List all external files #

select title, url_private from slack_files where is_external is true;