Table: pipes_organization - Query Pipes Organizations using SQL

Users can create their own connections and workspaces, but they are not shared with other users. Organizations, on the other hand, include multiple users and are intended for organizations to collaborate and share workspaces and connections.

Table Usage Guide

The pipes_organization table provides insights into Organizations within Pipes. As a data engineer, explore organization-specific details through this table, including the name, description, and creation date of the organization. Utilize it to uncover information about organizations, such as those with specific data flows, the relationships between organizations, and the verification of data pipelines.

Examples

Basic info

Analyze the status of different organizational entities within your system. This is useful to understand the overall health and activity status of various organizations for effective management.

select
  id,
  org_id,
  org_handle,
  status
from
  pipes_organization;

select
  id,
  org_id,
  org_handle,
  status
from
  pipes_organization;

Schema for pipes_organization

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
avatar_url	text		The avatar URL of the organization.
created_at	timestamp with time zone		The time when the organization was created.
created_by	jsonb		Information about the user who created the organization.
created_by_id	text		The unique identifier of the user who created the organization.
display_name	text		The display name for the organization.
handle	text	=	The handle name for the organization.
id	text		The unique identifier for a organization.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
updated_at	timestamp with time zone		The organization's last update time.
updated_by	jsonb		Information about the user who last updated the organization.
updated_by_id	text		The unique identifier of the user who last updated the organization.
url	text		The URL of the organization.
user_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier for the user.
version_id	bigint		The current version ID for the organization.

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