Table: slack_emoji - Query Slack Emojis using SQL

Slack is a digital workspace that connects users to the people and tools they work with. Emojis are a critical part of Slack as they help to express emotions, clarify messages, and create a more engaging and friendly environment. Custom emojis can be created in Slack to personalize and enhance communication.

Table Usage Guide

The slack_emoji table provides insights into custom emojis within a Slack workspace. As a team administrator, this table allows you to monitor and manage custom emojis, providing details such as the emoji name, creator, and creation date. Utilize it to understand emoji usage trends, identify inappropriate emojis, and maintain a positive and professional communication environment.

Examples

List all emoji

Explore the entire range of emojis available on your Slack workspace. This can help to understand the variety of expressions available for enhancing communication within your team.

select
  *
from
  slack_emoji;

select
  *
from
  slack_emoji;

Find emoji aliases

Discover the segments that use aliases in place of actual emojis in Slack. This is useful for understanding how custom emojis are being utilized within your workspace.

select
  *
from
  slack_emoji
where
  url like 'alias:%';

select
  *
from
  slack_emoji
where
  url like 'alias:%';

Schema for slack_emoji

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
name	text		Name of the emoji, used in message text.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
url	text		URL of the emoji image.
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_emoji