Table: pipes_organization_member - Query Pipes Organization Members using SQL

Pipes is a data integration service that allows users to connect, transform, and automate data processes across different platforms. An Organization Member in Pipes refers to a user who is part of a specific organization, with assigned roles and permissions to access and manage data processes. This includes information on the user's participation in projects, their roles, and the permissions granted to them.

Table Usage Guide

The pipes_organization_member table provides insights into user memberships within Pipes Organizations. As a data analyst or DevOps engineer, explore user-specific details through this table, including roles, permissions, and project participation. Utilize it to uncover information about users, such as their roles in the organization, their permissions, and their involvement in various projects.

Examples

Basic info

Explore which members belong to your organization and their current status. This can help you manage your team effectively by identifying active and inactive members.

select
  id,
  org_id,
  user_handle,
  status
from
  pipes_organization_member;

select
  id,
  org_id,
  user_handle,
  status
from
  pipes_organization_member;

List invited members

Explore which members have been invited to join your organization, helping you keep track of pending invitations and manage your team more effectively.

select
  id,
  org_id,
  user_handle,
  status
from
  pipes_organization_member
where
  status = 'invited';

select
  id,
  org_id,
  user_handle,
  status
from
  pipes_organization_member
where
  status = 'invited';

List members with owner role

Explore which members hold the 'owner' role within your organization. This helps in managing access controls and understanding the distribution of administrative responsibilities.

select
  id,
  org_id,
  user_handle,
  status
from
  pipes_organization_member
where
  role = 'owner';

select
  id,
  org_id,
  user_handle,
  status
from
  pipes_organization_member
where
  role = 'owner';

Schema for pipes_organization_member

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		The time when the member was invited.
created_by	jsonb		Information about the user who invited the member.
created_by_id	text		The unique identifier of the user who invited the member.
id	text		The unique identifier for the member.
org_handle	text	=	The handle of the organization.
org_id	text		The unique identifier for the organization.
role	text		The role of the member.
scope	text		The scope of the role. Will always be 'org'.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The member current status. Possible values are: invited, accepted.
updated_at	timestamp with time zone		The member's last update time.
updated_by	jsonb		Information about the user who last updated the member.
updated_by_id	text		The unique identifier of the user who last updated the member.
user	jsonb		Information about the user.
user_handle	text	=	The handle name for the user.
user_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier for the user.
version_id	bigint		The current version ID for the member.

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_organization_member