Table: pipes_user - Query Pipes User using SQL

Pipes User is a resource within the Pipes platform that allows for user identification and management. It provides a centralized way to manage user details within the Pipes platform, including user ID, name, and email. Pipes User helps users to stay informed about the details and status of various users within the platform.

Table Usage Guide

The pipes_user table provides insights into user details within the Pipes platform. As a system administrator, explore user-specific details through this table, including user ID, name, and email. Utilize it to uncover information about users, such as their identification details and email addresses, facilitating better user management and communication.

Examples

Basic info

Explore the status and identifiers of users in your system. This can be useful for understanding user activity and maintaining account security.

select
  id,
  display_name,
  status,
  handle
from
  pipes_user;

select
  id,
  display_name,
  status,
  handle
from
  pipes_user;

Schema for pipes_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
avatar_url	text		The avatar URL of the user.
created_at	timestamp with time zone		The creation time of the user.
display_name	text		The display name for the user.
handle	text		The handle name of the user.
id	text		The unique identifier for the user.
preview_access_mode	text		The preview mode for the current user.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The user status.
updated_at	timestamp with time zone		The user's last updated time.
url	text		The URL of the user.
user_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier for the user.
version_id	bigint		The version ID of the user.

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