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	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
status	text	The current status of the email. Can be one of pending/verified
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