steampipe plugin install slack

Table: slack_connection - Query Slack Connections using SQL

Slack is a channel-based messaging platform. It is used to communicate, collaborate, and share files. Slack Connections refer to the integrations set up between Slack and other third-party applications or services.

Table Usage Guide

The slack_connection table provides insights into the connections set up in a Slack workspace. As a system administrator or a team manager, you can use this table to retrieve information about the application or services connected to your Slack workspace, their connection status, and other related details. This information can be useful in managing and troubleshooting issues related to third-party integrations.

Examples

Connection information

Explore the status and details of your Slack connections to ensure they are functioning correctly and securely. This can be useful in troubleshooting or auditing the security of your communication channels.

select
*
from
slack_connection;
select
*
from
slack_connection;

Schema for slack_connection

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
bot_idtextID of the bot making the connection. null if not a bot.
enterprise_idtextID of the enterprise grid. null if not an enterprise workspace.
teamtextName of the workspace team.
team_idtextID of the workspace team.
urltextURL of the workspace.
usertextName of the user making the connection.
user_idtextID of the user making the connection.
workspace_domaintextThe domain name for the workspace.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- slack

You can pass the configuration to the command with the --config argument:

steampipe_export_slack --config '<your_config>' slack_connection