steampipe plugin install pipes

Table: pipes_user_email - Query Pipes User Emails using SQL

Pipes allows users to connect and move data between various cloud and on-premises applications. It provides a simplified way to set up and manage integrations for various Steampipe plugins. Pipes helps you stay informed about the health and performance of your data integrations and take appropriate actions when predefined conditions are met.

Table Usage Guide

The pipes_user_email table provides insights into user emails within Pipes service. As a data analyst or IT administrator, explore user-specific email details through this table, including associated user details and email addresses. Utilize it to uncover information about users, such as their email address, the associated user details, and the verification of user email data.

Examples

Basic info

Explore which users have registered their emails and when, to gain insights into user activity and status. This can help in understanding the growth and engagement levels of your user base.

select
id,
email,
status,
created_at
from
pipes_user_email;
select
id,
email,
status,
created_at
from
pipes_user_email;

Schema for pipes_user_email

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
created_attimestamp with time zoneThe time when the user email was created.
emailtextThe email ID.
idtextThe unique identifier for the user email.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statustextThe current status of the email. Can be one of pending/verified
user_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier for the user.
version_idbigintThe version ID of the user email.

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)" -- pipes

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

steampipe_export_pipes --config '<your_config>' pipes_user_email