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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
bot_id	text		ID of the bot making the connection. null if not a bot.
enterprise_id	text		ID of the enterprise grid. null if not an enterprise workspace.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
team	text		Name of the workspace team.
team_id	text		ID of the workspace team.
url	text		URL of the workspace.
user	text		Name of the user making the connection.
user_id	text		ID of the user making the connection.
workspace_domain	text	=, !=, ~~, ~~, !~~, !~~	The 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