Table: steampipecloud_process

Allows to track various activities performed on an identity in Steampipe Cloud.

Examples

Basic info

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

List processes that are being run by an identity pipeline

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

List user processes

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

List running processes

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

Schema for steampipecloud_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.