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	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
status	text	The user status.
updated_at	timestamp with time zone	The user's last updated time.
url	text	The URL of 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