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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		The time when the user email was created.
email	text		The email ID.
id	text		The unique identifier for the user email.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The current status of the email. Can be one of pending/verified
user_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier for the user.
version_id	bigint		The 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