Table: pipes_process - Query Pipes Processes using SQL

Pipes provides a way to query and manage processes for various Steampipe plugins, including retrieving process status, duration, and other details. It helps you stay informed about the state and performance of your Steampipe plugins and take appropriate actions based on the retrieved data.

Table Usage Guide

The pipes_process table provides insights into running processes within Pipes. As a DevOps engineer, this table allows you to explore process-specific details, including status, duration, and associated metadata. Utilize it to monitor and manage processes, such as those with long durations, the state of different processes, and the verification of process details.

Examples

Basic info

Explore which processes are currently active and when they were created. This can help in understanding the operational flow and managing resources effectively.

select
  id,
  identity_handle,
  identity_type,
  pipeline_id,
  type,
  state,
  created_at
from
  pipes_process;

select
  id,
  identity_handle,
  identity_type,
  pipeline_id,
  type,
  state,
  created_at
from
  pipes_process;

List processes that are being run by an identity pipeline

Explore which processes are being managed by a specific pipeline. This can be useful to understand the pipeline's activity and monitor its performance.

select
  id,
  identity_handle,
  identity_type,
  pipeline_id,
  type,
  state,
  created_at
from
  pipes_process
where
  pipeline_id is not null;

select
  id,
  identity_handle,
  identity_type,
  pipeline_id,
  type,
  state,
  created_at
from
  pipes_process
where
  pipeline_id is not null;

List user processes

Explore which processes are initiated by users within a system. This can be particularly useful to monitor user activity and manage system resources effectively.

select
  id,
  identity_handle,
  identity_type,
  pipeline_id,
  type,
  state,
  created_at
from
  pipes_process
where
  identity_type = 'user';

select
  id,
  identity_handle,
  identity_type,
  pipeline_id,
  type,
  state,
  created_at
from
  pipes_process
where
  identity_type = 'user';

List running processes

Explore which processes are currently active. This is useful for monitoring ongoing operations and identifying any that may be causing issues or consuming excessive resources.

select
  id,
  identity_handle,
  identity_type,
  pipeline_id,
  type,
  state,
  created_at
from
  pipes_process
where
  state = 'running';

select
  id,
  identity_handle,
  identity_type,
  pipeline_id,
  type,
  state,
  created_at
from
  pipes_process
where
  state = 'running';

Schema for pipes_process

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone		The time when the process was created.
created_by	jsonb		Information about the user who created the process.
created_by_id	text		The unique identifier of the user who created the process.
id	text	=	The unique identifier for the process.
identity_handle	text	=	The handle of the identity.
identity_id	text	=	The unique identifier of the identity to which the process belongs to.
identity_type	text		The type of identity, can be org/user.
pipeline_id	text		The unique identifier for the pipeline if a process is for a pipeline run/execution.
state	text		The current state of the process.
type	text		The type of action executed by the process.
updated_at	timestamp with time zone		The time when the process was last updated.
updated_by	jsonb		Information about the user who last updated the process.
updated_by_id	text		The unique identifier of the user who last updated the process.
version_id	bigint		The current version ID for the process.

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_process