Table: slack_search
Searches for messages and files matching a query.
NOTE: The slack_search table requires the query field to be specified
in all queries, otherwise it does not know what to search for.
Examples
Search for anything using standard slack search syntax
select user_name, timestamp, channel ->> 'name' as channel, textfrom slack_searchwhere query = 'in:#steampipe from:nathan urgent after:3/12/2021';Consolidate results of multiple searches
select user_name, timestamp, channel ->> 'name' as channel, textfrom slack_searchwhere query in( 'in:#steampipe from:nathan urgent after:3/12/2021', 'in:#steampipe from:kai urgent after:3/12/2021' );.inspect slack_search
Search slack for anything using a query.
| Name | Type | Description |
|---|---|---|
| _ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
| attachments | jsonb | Attachments matching the query. |
| blocks | jsonb | Block sections in the matching artifact. |
| channel | jsonb | Channel or conversation where the search result was found. |
| permalink | text | URL for the search result. |
| query | text | The search query. |
| text | text | Search result text, including query. |
| timestamp | timestamp with time zone | Timestamp of the matching artifact. |
| type | text | Type of the artifact matching the search. |
| user_id | text | ID of the user responsible for the matching text. |
| user_name | text | Name of the user responsible for the matching text. |
| workspace_domain | text | The domain name for the workspace. |