Back to source list
Official
Premium
Slack
The CloudQuery Slack plugin extracts information from your Slack organization(s) and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v5.1.1
Type
Source
Platforms
Date Published
Slack Conversation Histories
The slack_conversation_histories table shows data for Slack Conversation Histories.
This table supports incremental syncing. Read more about incremental syncing here.
Table Options #
ConversationHistoriesTableOptions contains configuration for the slack_conversation_histories table
Time #
CloudQuery configtype.Time
Allows for defining timestamps in both absolute(RFC3339) and relative formats. Absolute timestamp example:
2024-01-01T12:00:00+00:00.
Relative timestamps can take this format:nowx seconds [ago|from now]x minutes [ago|from now]x hours [ago|from now]x days [ago|from now]untilfield usage:until: nowuntil: 2 days agountil: 10 months 3 days 4h20m from nowuntil: 2024-01-01T12:00:00+00:00
(
string) (pattern: (^now$|^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(.(\\d{1,9}))?(Z|((-|\\+)\\d{2}:\\d{2}))$|^\\d{4}-\\d{2}-\\d{2}$|^[-+]?([0-9]*(\\.[0-9]*)?[a-z]+)+$|^(([0-9]+\\s+(nanoseconds?|ns|microseconds?|us|µs|μs|milliseconds?|ms|seconds?|s|minutes?|m|hours?|h|days?|d|months?|M|years?|Y)|[-+]?([0-9]*(\\.[0-9]*)?[a-z]+)+))(\\s+(([0-9]+\\s+(nanoseconds?|ns|microseconds?|us|µs|μs|milliseconds?|ms|seconds?|s|minutes?|m|hours?|h|days?|d|months?|M|years?|Y)|[-+]?([0-9]*(\\.[0-9]*)?[a-z]+)+)))*\\s+(ago|from\\s+now)$))Primary Keys #
| Name | Type |
|---|---|
| channel_id | utf8 |
| team_id | utf8 |
| ts | utf8 |
Columns #
| Name | Type |
|---|---|
| attachments | json |
| bot_id | utf8 |
| bot_profile | json |
| channel | utf8 |
| channel_id | utf8 |
| client_msg_id | utf8 |
| comment | json |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| deleted_ts | utf8 |
| delete_original | bool |
| edited | json |
| event_ts | utf8 |
| files | json |
| hidden | bool |
| icons | json |
| inviter | utf8 |
| is_starred | bool |
| item_type | utf8 |
| last_read | utf8 |
| latest_reply | utf8 |
| members | list<item: utf8, nullable> |
| metadata | json |
| name | utf8 |
| old_name | utf8 |
| parent_user_id | utf8 |
| permalink | utf8 |
| pinned_to | list<item: utf8, nullable> |
| purpose | utf8 |
| reactions | json |
| replace_original | bool |
| reply_count | int64 |
| reply_to | int64 |
| reply_users | list<item: utf8, nullable> |
| response_type | utf8 |
| subscribed | bool |
| subtype | utf8 |
| team | utf8 |
| team_id | utf8 |
| text | utf8 |
| thread_ts | utf8 |
| topic | utf8 |
| ts | utf8 |
| type | utf8 |
| unread_count | int64 |
| upload | bool |
| user | utf8 |
| username | utf8 |
Relations
This table depends on:
Slack ConversationsThe following tables depend on "Slack Conversation Histories":